The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five/x7fdigit number starting with 0.  What could be the possible reason？（）

A、These are the data files that are corrupted.

B、There is no SYSAUX tablespace in your database

C、There is a read­only tablespace in your database.

D、These are the data files that cannot be recovered.

相关问题推荐

• In which two conditions are resumable statements suspended？（）

  A

   when a user exceeds the space quota

  B

   when a user session is terminated

  C

   when a table that is being accessed by the current transaction is not found

  D

   when a user manually suspends the statement

  E

   when the maximum extents of a segment is reached

  查看答案

• You are operating your database in the manual archiving mode. Currently， your database is configured with the following online redo log groups and members：    You tried to drop Group 1 from the database but received the following errors：        ORA-01623： log 1 is current log for thread 1 cannot drop        ORA-00312： online log 1 thread 1：   ’D:///ORACLE/ORADATA/TESTDB/REDO01a.LOG’   What might be the reason for these errors？（）  

  A、  Group 1 is an active or current online redo log group.

  B、  Group 1 is an inactive online redo group that has not been archived yet.

  C、  The members of the Group 1 are temporarily asymmetric with the members of other groups.

  D、  The size of the online redo log members of Group 1 is different from the size of the members in other groups.

  查看答案

• In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command：  RMAN> RESTORE CONTROLFILE；  Which two operations do you need to perform after restoring the control file from backup？（）

  A

   shut down and restart the instance

  B

   add new tempfiles to the temporary tablespaces after recovery

  C

   perform a media recovery and open the database with the RESETLOGS option

  D

   perform a media recovery and bring the database to NOARCHIVELOG mode

  查看答案

• Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors：   ORA-00313： open failed for members of log group 1 of thread 1   ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue？（）

  A、 SQL>ALTER DATABASE DROP LOGFILE GROUP 1；

  B、 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；

  C、 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；

  D、 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；

  查看答案

• You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （） 

  A、 ASM_POWER_LIMIT

  B、 ASM_DISKSTRING

  C、 ASM_DISKGROUPS

  D、 LARGE_POOL_SIZE

  查看答案