Restore the archived redo log that is missing and attempt recovery again.
Recovery is complete and you can open the database.
Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.
Recover the entire database and apply all archived redo logs again.
Recovery is not possible because an archived redo log has been lost.
第1题:
You can control instance recover performance by setting parameters to define targets for()
第2题:
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?()
第3题:
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?()
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8
第4题:
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()
第5题:
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()
第6题:
You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order?() 1. Grant the appropriate privileges (CONNECT and RESOURCE) and roles (RECOVERY_CATALOG_OWNER) to the user responsible for performing backup and recover operations. 2. Register the target database in the catalog. 3. Create the catalog using the RMAN command line interpreter. 4. Create a user and schema which will own the recovery catalog. 5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog. 6. Connect to the target database using SYSDBA privileges.
第7题:
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()
第8题:
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()
第9题:
You are trying to recover your database. During the recovery process, you receive the following error: ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289: suggestion : /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-00280: change 5033391 for thread 1 is in sequence #11 ORA-00278: log file ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log: {
第10题:
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()