OCP恢复 - 随笔分类(第2页) - 巴啦啦大魔王

053-152

摘要：You are performing incomplete recovery using RMAN. You execute the following RUN block:RUN{SET UNTIL SCN 1107600;RESTORE DATABASE;RECOVER DATABASE;}Wh 阅读全文

posted @ 2017-11-16 15:06 巴啦啦大魔王阅读(154) 评论(0) 推荐(0)

053-154

摘要：A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message: Which is the recommended sequ 阅读全文

posted @ 2017-11-16 14:59 巴啦啦大魔王阅读(129) 评论(0) 推荐(0)

053-268

摘要：You are using Recovery Manager (RMAN) for backup and recovery operations with a recoverycatalog. You have been taken database backups every evening. O 阅读全文

posted @ 2017-11-16 14:29 巴啦啦大魔王阅读(149) 评论(0) 推荐(0)

053-673

摘要：In Recovery Manager (RMAN), you are taking image copies of the datafiles of your productiondatabase and rolling them forward as regular intervals. You 阅读全文

posted @ 2017-11-16 14:25 巴啦啦大魔王阅读(94) 评论(0) 推荐(0)

053-161

摘要：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)

053-670

摘要：After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best optio 阅读全文

posted @ 2017-11-16 13:49 巴啦啦大魔王阅读(141) 评论(0) 推荐(0)

053-663

摘要：Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is ru 阅读全文

posted @ 2017-11-16 13:39 巴啦啦大魔王阅读(142) 评论(0) 推荐(0)

053-662

摘要：To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change trackin 阅读全文

posted @ 2017-11-16 13:38 巴啦啦大魔王阅读(125) 评论(0) 推荐(0)

053-657

摘要：The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you 阅读全文

posted @ 2017-11-16 13:28 巴啦啦大魔王阅读(174) 评论(0) 推荐(0)

053-654

摘要：You are using Recovery Manager (RMAN) with a recovery catalog to back up your productiondatabase. The backups and the archived redo log files are copi 阅读全文

posted @ 2017-11-16 13:25 巴啦啦大魔王阅读(166) 评论(0) 推荐(0)

053-642

摘要：In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While i 阅读全文

posted @ 2017-11-16 11:21 巴啦啦大魔王阅读(132) 评论(0) 推荐(0)

053-635

摘要：While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space 阅读全文

posted @ 2017-11-16 11:02 巴啦啦大魔王阅读(124) 评论(0) 推荐(0)

053-679

摘要：Which mode of database shutdown requires an instance recovery at the time of the next database startup?A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONAL 数据库在关阅读全文

posted @ 2017-11-15 17:47 巴啦啦大魔王阅读(126) 评论(0) 推荐(0)

053-627

摘要：In Recovery Manager (RMAN), you are taking image copies of the data files of your productiondatabase and rolling them forward at regular intervals. Yo 阅读全文

posted @ 2017-11-15 17:37 巴啦啦大魔王阅读(119) 评论(0) 推荐(0)

053-625

摘要：Your database is running in ARCHIVELOG mode.One of the data files,USERDATA01.dbf,inthe USERS tablespace is damaged and you need to recover the file un 阅读全文

posted @ 2017-11-15 17:20 巴啦啦大魔王阅读(163) 评论(0) 推荐(0)

053-613

摘要：You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?A. Enable the f 阅读全文

posted @ 2017-11-15 16:11 巴啦啦大魔王阅读(157) 评论(0) 推荐(0)

053-611

摘要：To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:SQL> ALTER TABLESPACE 阅读全文

posted @ 2017-11-15 16:09 巴啦啦大魔王阅读(103) 评论(0) 推荐(0)

053-607

摘要：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)

053-604

摘要：You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that 阅读全文

posted @ 2017-11-15 15:46 巴啦啦大魔王阅读(113) 评论(0) 推荐(0)

053-601

摘要：You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prere 阅读全文

posted @ 2017-11-15 15:36 巴啦啦大魔王阅读(108) 评论(0) 推荐(0)

随笔分类 - OCP恢复

公告