While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the orruption?
A. restore database until time ’06-SEP-2008 06:30:00′); recover database until time ’06-SEP-2008 06:30:00′);
alter database open;
B. restore database until time ’06-SEP-2008 06:30:00′); recover database until time ’06-SEP-2008 06:30:00′);
alter database open resetlogs;
C. restore database until time ’06-SEP-2008 18:29:55′); recover database until time ’06-SEP-2008 18:29:55′);
alter database open resetlogs;
D. restore database until time ’06-SEP-2008 18:29:55′); alter database open resetlogs;
E. restore database until time ’06-SEP-2008 18:29:55′); recover database; alter database open resetlogs;
What is the purpose of the until change option of the restore command?
A. It allows you to select the SCN that you want to restore to.
B. It allows you to select the log sequence number you want to restore to.
C. It allows you to select the timestamp you want to restore to.
D. It allows you to manually stop the restore at any time as online redo logs are applied.
E. None of the above.
What is the purpose of the recover command? (Choose all that apply.)
A. Recover database datafiles from physical disk backup sets.
B. Recover required incremental backups from physical disk backup sets.
C. Recover required archived redo logs from physical disk backup sets.
D. Apply incremental backups to recover the database.
E. Apply archived redo logs to recover the database.
What is an obsolete backup set?
A. A backup set that is missing one or more backup set pieces
B. A backup that has exceeded the retention criteria and is no longer needed
C. A backup set that does not include archived redo logs
D. A backup set that can not be recovered due to corruption
E. A backup set superceded by a datafile copy
What is the purpose of the list expired backup command?
A. Lists all backups impacted by a resetlogs command
B. Lists all backups that are subject to retention criteria
C. Lists all backups that are missing associated physical backup set pieces
D. Lists the status of datafile backup failures due to the use of the duration command
E. Lists backups that cannot be used by the restore command because they have been marked as disabled
What is the purpose of the catalog command?
A. To review RMAN control file and recovery catalog metadata and ensure that its correct
B. To delete RMAN backup-related metadata from the recovery catalog
C. To create metadata in the control file and the recovery catalog related to backup set pieces
D. To create a report that lists database backups
E. To rebuild the recovery catalog
Which of the following commands will fail?
A. report schema;
B. report need backup;
C. report need backup days 3;
D. report user;
E. report obsolete;
What are the two different types of database duplication? (Choose two.)
E. Failure driven
When youre performing a tablespace point-in-time recovery, which tablespaces will always be restored to the auxiliary instance? (Choose all that apply.)
A. The SYSTEM tablespace.
B. The UNDO tablespace.
C. All tablespaces with tables.
D. All tablespaces with indexes.
E. No tablespaces are automatically restored.
Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)
A. Backup-based database duplication.
B. Active database duplication.
C. Tablespace point-in-time recovery.
D. No operation requires the creation of an auxiliary instance.
If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.
|One Time Purchase||✔||✖||✖||✖||✖|
|100% Pass Guarantee||✔||✖||✖||✖||✖|
|100% Money Back||✔||✖||✖||✖||✖|