单项选择题
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()
A. You do not need to restore all the data files.
B. You do not need to open the database with the RESETLOGS operation
C. You do not need to perform a full backup after the RESETLOGS operation.
D. You do not need to recover all the data files to the same system change number (SCN).
相关考题
-
单项选择题
Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure?Howwouldyourecoverthelostredologmember?()
A. import the database from the last export
B. restore all the members in the group from the last backup
C. drop the lost member from the database and then add a new member to the group
D. restore all the database files from the backup and then perform a complete recovery
E. restore all the database files from the backup and then perform an incomplete recovery -
多项选择题
Youareperformingablockmediarecoveryonthetools01.dbfdatafileintheSALESdatabaseusingRMAN.Whichtwostatementsarecorrectinthisscenario?()
A. You must ensure that the SALES database is mounted or open.
B. You must restore a backup control file to perform a block media recovery.
C. You must take the tools01.dbf data file offline before you start a block media recovery.
D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported. -
单项选择题
Oneofthetablespacesisread-onlyinyourdatabase.Thelossofallcontrolfilesforcedyoutore-createthecontrolfile.Whichoperationdoyouneedtoperformafterre-creatingthecontrolfileandopeningthedatabase?()
A. drop and re-create the read-only tablespaces
B. rename the read-only data files to their correct file names
C. change the tablespace status from read/write to read-only
D. re-create the read-only tablespace because it is automatically removed
