随笔分类 -  RMAN

摘要: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)
摘要: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 information does the report schema command not provide? (Choose all that apply.)A. Size of the datafiles B. Size of the tempfilesC. Date of last 阅读全文
posted @ 2017-11-10 18:26 巴啦啦大魔王 阅读(57) 评论(0) 推荐(0)
摘要:Why would you execute the report obsolete command?A. To list all backups that were no longer available for restore operationsB. To list all backups th 阅读全文
posted @ 2017-11-10 18:22 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
摘要:What does the minimize load database parameter mean when backing up a database?A. RMAN will attempt to make the backup run as fast as possible without 阅读全文
posted @ 2017-11-10 18:15 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0)
摘要:If a backup set is expired, what can you do to correct the problem?A. Change the retention criteria.B. Make the lost backup set pieces available to RM 阅读全文
posted @ 2017-11-10 17:46 巴啦啦大魔王 阅读(65) 评论(0) 推荐(0)
摘要:You run the following commands:RMAN> list expired backup; RMAN> delete expired backup;What will happen to the backup set pieces associated with the ba 阅读全文
posted @ 2017-11-10 17:35 巴啦啦大魔王 阅读(82) 评论(0) 推荐(0)
摘要:What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?A. crosscheckB. 阅读全文
posted @ 2017-11-10 16:41 巴啦啦大魔王 阅读(153) 评论(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)
摘要: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)
摘要:True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.A. TrueB. False There is no equivalent RMAN co 阅读全文
posted @ 2017-11-10 15:02 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-fileautobackups. Which files are not backed up during the RMAN ba 阅读全文
posted @ 2017-11-10 14:53 巴啦啦大魔王 阅读(128) 评论(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)
摘要: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)
摘要:Which commands are used for RMAN database recovery? (Choose all that apply.)A. restoreB. repairC. copyD. recoverE. replace The restore command is used 阅读全文
posted @ 2017-11-10 14:07 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
摘要:Which is the correct way to connect to both the target database and the recovery catalogfrom the RMAN command line? Assume that the target database is 阅读全文
posted @ 2017-11-10 13:34 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
摘要:How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?A. Issue the grant command from the SYS 阅读全文
posted @ 2017-11-10 12:36 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
摘要:You have created a script in the recovery catalog called backup_database. Which of the followingcommands would successfully execute that script?A. run 阅读全文
posted @ 2017-11-10 12:25 巴啦啦大魔王 阅读(80) 评论(0) 推荐(0)
摘要:If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that 阅读全文
posted @ 2017-11-10 12:19 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)