Until SCN
Until time
Until cancel
Recover using backup control file.
第1题:
When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()
第2题:
Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database?()
第3题:
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?()
A. Mount the container database (CDB) and restore the control file from the control file auto backup.
B. Recover and open the CDB in NORMAL mode.
C. Mount the CDB and then recover and open the database, with the RESETLOGS option.
D. Open all the pluggable databases.
E. Recover each pluggable database.
F. Start the database instance in the nomount stage and restore the control file from control file auto backup.
第4题:
Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database?()
第5题:
You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’2004-08-05:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()
第6题:
You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?() a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database.
第7题:
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()
第8题:
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()
第9题:
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()
第10题:
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()