单项选择题

A.You need to perform the restore and recover operation……

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

A.You need to perform the restore and recover operations manually, because the backup was made manually.
B.First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database.
C.First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database.
D.You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

<上一题目录下一题>

热门试题

单项选择题Whichfilesmustbesynchronizedinorderforadatabasetostart？（）

A.temp files
B.online data files
C.offline data files
D.read only data files

多项选择题Whichthreestatementsaretrueaboutdatabaserecoveryoperations？（）

A.Damaged or lost data files are restored from backups.
B.Redo log file entries are used to roll forward the database.
C.Undo segments are used to roll back any uncommitted transactions.
D.Transactions that were active when the failure occurred are restarted.
E.Transactions that were active when the failure occurred are automatically committed during the recover procedure.

单项选择题Whenperforminganincompleterecoverofthewholedatabase，whichdatafilesmustyourestore？（）

A.Only the damaged or lost data files.
B.All of the data files of the database.
C.Only the data files belonging to the SYSTEM tablespace.
D.The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

单项选择题You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG； Where is the information that the database is now in ARCHIVELOG mode stored？（）

A.SPFILE
B.archive log
C.control file
D.system tablespace

单项选择题You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’ BACKUP df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）

A.Only the data files.
B.Only the data files and the online logs.
C.The data files， control files， and the online logs.
D.The data files and control files， but not the online logs.