You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.

B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

相关问题推荐

• 下列程序的运行结果为 #include＜iostream.h＞ template＜class TT＞ class FF {TT a1，a2，a3； public： FF(TT b1，TT b2，TT b3){a1＝b1；a2=b2；a3＝b3；} TT Sum(){return a1+a2+a3；}}； void main() { FF＜int＞x(int(1.1)，2，3)，y(int(4.2)，5，6)； cout＜＜x.Sum()＜＜‘‘＜

  A．6.1 15.2

  B．6 15

  C．6 15.2

  D．6.1 15

  查看答案

• You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）

  A、 Use ROLLBACK command with SCN 663571.

  B、 Perform Flashback Transaction Query with SCN 663571.

  C、 Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

  D、 Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

  查看答案

• You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

  A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.

  B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.

  C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.

  D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

  查看答案

• You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

  A、 The index tablespace contains bitmap indexes.

  B、 The index tablespace contains more than one data file.

  C、 The index tablespace supports only complete recovery.

  D、 The index tablespace is not a dictionary-managed tablespace.

  E、 There is a dependency relationship between a table and its indexes.

  查看答案

• Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）

  A、 Disable SQL tracing for the APPS tablespace.

  B、 Disable logging attributes for the APPS tablespace.

  C、 Modify the tablespace to be a dictionary-managed tablespace.

  D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.

  E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

  查看答案