随笔分类 -  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 阅读全文
posted @ 2017-11-13 10:35 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-13 10:32 巴啦啦大魔王 阅读(125) 评论(0) 推荐(0)
摘要:Which command is used to begin a tablespace point-in-time recovery?A. Restore tablespaceB. Recover tablespaceC. Tablespace recoverD. Recover to timeE. 阅读全文
posted @ 2017-11-13 10:14 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-13 10:11 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 18:19 巴啦啦大魔王 阅读(72) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 16:34 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 16:25 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 16:23 巴啦啦大魔王 阅读(182) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 16:12 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 16:08 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 16:03 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 15:54 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 15:36 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 15:27 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 15:21 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 15:07 巴啦啦大魔王 阅读(114) 评论(0) 推荐(0)
摘要:What is the end result of these commands if they are successful?RMAN> show retention policy;RMAN configuration parameters for database with db_unique_ 阅读全文
posted @ 2017-11-10 14:47 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 14:39 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
摘要:If you lost your entire database, including the database spfile, control files, online redo logs, anddatabase datafiles, what kind of recovery would b 阅读全文
posted @ 2017-11-10 14:36 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 14:23 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)