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 performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }

  A、 NOMOUNT

  B、 MOUNT

  C、 OPEN

  D、 RESTRICTED

  查看答案

• Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）

  A

  The database opens normally.

  B

  The database prompts for a database recovery.

  C

  The database writer writes to a trace file， indicating that the temporary file is not found.

  D

  The database gets mounted and throws an error indicating that the temporary file requires recovery.

  查看答案

• What are the two advantages of RMAN Block Media Recovery （BMR） over file/x7flevel recovery？（）

  A

  BMR lowers the mean time to recover （MTTR）.

  B

  BMR supports point­in­time recovery of individual data blocks.

  C

  BMR enables you to use incremental backups for block recovery.

  D

  BMR enables recovery even when the database is not mounted or open.

  E

  BMR enables you to use proxy backups to perform block media recovery.

  F

  BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.

  查看答案

• View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

  A

   all the data files belonging to the USERS tablespace

  B

   password file

  C

   online redo log files

  D

   the current control file

  E

   archived redo log files

  F

   the current server parameter file

  G

   data files belonging to the USERS tablespace and all the default tablespaces

  查看答案

• You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）

  A、 Index cluster

  B、 Hash cluster

  C、 Sorted Hash cluster

  D、 Real Application Cluster

  查看答案