随笔分类 - OCP恢复
摘要:When performing a full database disaster recovery with RMAN, in what order would you executethese steps?A. Restore the control file from autobackups.B
阅读全文
摘要:What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?A. TS_CHEC
阅读全文
摘要:Which command is used to begin a tablespace point-in-time recovery?A. Restore tablespaceB. Recover tablespaceC. Tablespace recoverD. Recover to timeE.
阅读全文
摘要:True or false: tablespace point-in-time recovery is possible only with RMAN.A. TrueB. False Tablespace point-in-time recovery has been done in Oracle
阅读全文
摘要:What is the result of this command? RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Li
阅读全文
摘要:David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the contr
阅读全文
摘要:Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?A. shutd
阅读全文
摘要:What will be the end result of this set of RMAN commands?shutdown abortstartup mountrestore datafile 4 until time ,,09/30/2008:15:00:00; recover dataf
阅读全文
摘要:If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status ofMEDIA_CORRUPT, what RMAN command would you run to correct the problem?A. re
阅读全文
摘要:You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. Wha
阅读全文
摘要:You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP.You want to"roll back" the data in the USERS tablespace to the w
阅读全文
摘要:Which of the following does the recover command not do? A. Restore archived redo logs.B. Apply archived redo logs.C. Restore incremental backups.D. Ap
阅读全文
摘要:Which of the following are valid until command options when attempting point-in-time recovery inRMAN? (Choose all that apply.)A. until timeB. until ch
阅读全文
摘要:Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:RESTORE CONTR
阅读全文
摘要:What is the correct order of the following commands if you wanted to restore datafile 4, which wasaccidentally removed from the file system?A. sql 'al
阅读全文
摘要:You need to restore your database back to 9/30/2008 at 18:00. In what order would you run thefollowing commands to compete this task?A. restore contro
阅读全文
摘要:What is the end result of these commands if they are successful?RMAN> show retention policy;RMAN configuration parameters for database with db_unique_
阅读全文
摘要:Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?A. restore datafiles until time '09/28/2008:21:03:11';B. restore databas
阅读全文
摘要:If you lost your entire database, including the database spfile, control files, online redo logs, anddatabase datafiles, what kind of recovery would b
阅读全文
摘要:Given a complete loss of your database, in what order would you need to perform the followingRMAN operations to restore it?A. restore controlfileB. re
阅读全文
浙公网安备 33010602011771号