A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter.
The first choice to be made is whether a backup should be of the entire database, or just a part of it.A full backup is the is a backup of all Datafiles, control files and the spfile. Remember that as all multiplexed copies of the control files are identical, ...
When the database is taken in backup mode the checkpoint takes place and the datafile header gets frozenAs the checkpoint takes place the database writer writes all the blocks from database buffer cache to datafiles.The same blocks are also written from ...
Full: Full backup means backing up everything.
Incremental: Incremental backup means backing up everything that has
changed since last full backup.
Differential: Differential seems to be another name for incremental.
Network: Network backup usually ...
Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy?
Backup data from MS Sql Server to Access Database following stapes have to do:-1. Create DSN on SQL server (check Sql server Database name,server name,user name,password)2. open MS access database go to importselect ODBC (DSN name) ...
Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. - All Data files. - All Control files.
A backup of one or more database files taken while the database is closed. Typically, closed backups are also whole database backups. If you closed the database cleanly, then all the files in the backup are consistent. SQL>SHUTDOWN IMMEDIATE (or) NORMAL ...
Which two commands perform a full backup of all files in the root (/) file system to the default /dev/rmt/0 tape device? (Choose two) A. ufsdump 0 / B. ufsdump /dev/rmt/0 / C. ufsdump / /dev/rmt/0 D. ufsdump 0 /dev/rmt/0 / E. ufsdump Of /dev/rmt/0 /
Answer: C, D
How to recover the DB if we lost controlfile and we are not having backup also and the database is down...?
Use Export and Import tools for backups and restore resp.you can use exp and imp as well ...
* What are constraints and derivation?* Explain the process of taking backup in DataStage?*What are the different types of lookups available in DataStage?
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
