随笔分类 - OCP恢复
摘要:You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup
阅读全文
摘要: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
阅读全文
摘要:In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals-Set t
阅读全文
摘要:Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)A. configuri
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Your production database it functional on the SHOST1 host. You are backing up the productiondatabase by using Recovery Manager (RMAN) with the recover
阅读全文
摘要:While querying the EMPLOYEES table, you receive an ORA-01578 message indicating blockcorruption in File# 1201 and Block# 1968. You analyze the table a
阅读全文
摘要:Which of the following are correct about block media recovery? (Choose all that apply.) A. Physical and logical block corruption is recorded automatic
阅读全文
摘要: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
阅读全文
摘要:Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object inthat tablespace has a foreign key constraint owned by
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:When running the tablespace point-in-time commandrecover tablespace usersuntil time ,,10/06/2008:22:42:00 auxiliary destination ,,c:\oracle\auxiliary;
阅读全文
摘要: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
阅读全文
浙公网安备 33010602011771号