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 copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.<br /> The archive log files generated after the last backup are intact on one of the remote locations.<br /> While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）<p> 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 copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the product..

第1题

[单选题] When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

A、Until SCN B、Until time C、Until cancel D、Recover using backup control file.

点击查看答案

第2题

[单选题] Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）

A、2，4，3 B、1，4，3，2 C、2，5，4，3，6 D、5，2，4，3，6 E、1，5，4，3，6，2

点击查看答案

第3题

[单选题] Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）

A、2, 4, 3 B、1, 4, 3, 2 C、2, 5, 4, 3, 6 D、5, 2, 4, 3, 6 E、1, 5, 4, 3, 6, 2

点击查看答案

第4题

[单选题] You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach. B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach. C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name. D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

点击查看答案

第5题

[单选题] You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach. B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach. C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name. D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

点击查看答案

第6题

[多选题] Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)

A、The user has dropped an important table that needs to be recovered. B、The database files are corrupted when the database is open. C、You are not able to start up the database instance because the required database files are missing. D、The archived log files are missing for which backup is not available.

点击查看答案

第7题

[单选题] You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

A、 by using the Flashback Database feature B、 by using RMAN incomplete recovery C、 by performing a user-managed incomplete recovery D、 by dropping and re-creating the index tablespace

点击查看答案

第8题

[] Advise（）your fishing gear．

A、A.you recovery B、B.you recover C、C.you recovering D、D.you recovered

点击查看答案

第9题

[单选题] In user-managed backup and recover procedures， how are data files backed up？（）

A、Using SQL commands. B、Using SQL*Plus commands. C、Using operating system commands. D、Using Recover Manager commands.

点击查看答案

第10题

[单选题] You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: Which option illustrates the correct sequence that you must use?（）

A、8, 1, 3, 2, 4, 5, 7, 6 B、1, 8, 3, 4, 2, 5, 7, 6 C、1, 3, 4, 2, 8, 5, 6, 7 D、1, 3, 2, 4, 6, 5, 7, 8

点击查看答案

请使用微信扫码支付