随笔分类 -  OCP恢复

摘要:You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/ 阅读全文
posted @ 2017-11-15 15:31 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
摘要:The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the 阅读全文
posted @ 2017-11-15 15:24 巴啦啦大魔王 阅读(132) 评论(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)
摘要:You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are c 阅读全文
posted @ 2017-11-15 15:06 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
摘要:In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the se 阅读全文
posted @ 2017-11-15 15:04 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
摘要:Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup 阅读全文
posted @ 2017-11-15 15:00 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
摘要:Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.All the users on the database use the default tempor 阅读全文
posted @ 2017-11-15 13:52 巴啦啦大魔王 阅读(152) 评论(0) 推荐(0)
摘要:In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals-Set t 阅读全文
posted @ 2017-11-15 13:50 巴啦啦大魔王 阅读(151) 评论(0) 推荐(0)
摘要:Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)A. configuri 阅读全文
posted @ 2017-11-15 13:45 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
摘要:In your test database:-You are using Recovery Manager (RMAN) to perform incremental backups of your test database-The test database is running in NOAR 阅读全文
posted @ 2017-11-15 13:14 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
摘要:Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.You are informed that some 阅读全文
posted @ 2017-11-15 11:39 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
摘要:Your production database it functional on the SHOST1 host. You are backing up the productiondatabase by using Recovery Manager (RMAN) with the recover 阅读全文
posted @ 2017-11-15 11:33 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0)
摘要:While querying the EMPLOYEES table, you receive an ORA-01578 message indicating blockcorruption in File# 1201 and Block# 1968. You analyze the table a 阅读全文
posted @ 2017-11-14 10:11 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
摘要:Which of the following are correct about block media recovery? (Choose all that apply.) A. Physical and logical block corruption is recorded automatic 阅读全文
posted @ 2017-11-13 18:33 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
摘要:Which of the following is not an advantage of block media recovery (BMR)?A. Reduced MTTR.B. Datafiles remain offline while corrupt blocks are repaired 阅读全文
posted @ 2017-11-13 18:20 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
摘要:Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object inthat tablespace has a foreign key constraint owned by 阅读全文
posted @ 2017-11-13 14:09 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0)
摘要:If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?A. TS_OBJECTS_TO_BE_DROP 阅读全文
posted @ 2017-11-13 14:01 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
摘要:Which of the following restrictions are not true with respect to tablespace point-in-time recovery?(Choose all that apply.)A. The target database must 阅读全文
posted @ 2017-11-13 13:57 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
摘要:When running the tablespace point-in-time commandrecover tablespace usersuntil time ,,10/06/2008:22:42:00 auxiliary destination ,,c:\oracle\auxiliary; 阅读全文
posted @ 2017-11-13 13:38 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
摘要:Which command would correctly start a TSPITR of the USERS tablespace?A. recover tablespace users until time '10/06/2008:22:42:00' auxiliary 'c:\oracle 阅读全文
posted @ 2017-11-13 10:47 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)