随笔分类 -  control files

摘要:For which database operation would you need the database to be in the MOUNT state?A.renaming the control filesB.re-creating the control filesC.droppin 阅读全文
posted @ 2017-12-12 16:27 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
摘要:Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are bac 阅读全文
posted @ 2017-11-16 16:54 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
摘要:You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your product 阅读全文
posted @ 2017-11-16 14:19 巴啦啦大魔王 阅读(144) 评论(0) 推荐(0)
摘要:Indentify two advantages of using recovery catalog instead of the control file of the database inRecovery Manager (RMAN). (Choose two.)A. You can use 阅读全文
posted @ 2017-11-16 13:30 巴啦啦大魔王 阅读(158) 评论(0) 推荐(0)
摘要:Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance term 阅读全文
posted @ 2017-11-15 15:57 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
摘要:The database is configured in ARCHIVELOG mode and regular complete database backups are taken.The loss of which two types of files may require a recov 阅读全文
posted @ 2017-11-15 15:16 巴啦啦大魔王 阅读(156) 评论(0) 推荐(0)
摘要:Why would you run the delete obsolete command? (Choose all that apply.)A. To remove missing backup set pieces physically from diskB. To remove metadat 阅读全文
posted @ 2017-11-10 17:40 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
摘要:You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have anautomated cross-check script that also does a delete ex 阅读全文
posted @ 2017-11-10 16:54 巴啦啦大魔王 阅读(107) 评论(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)
摘要: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)
摘要: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)
摘要:What command would you issue to enable automated backups of control files?A. alter database controlfile autobackup onB. alter system controlfile autob 阅读全文
posted @ 2017-11-10 13:39 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
摘要:What methods are available to recover lost control files? (Choose all that apply.)A. Backup control file.B. Emergency control file.C. The create contr 阅读全文
posted @ 2017-11-09 16:03 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0)