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?()
Ashut down and restart the instance
Badd new tempfiles to the temporary tablespaces after recovery
Cperform a media recovery and open the database with the RESETLOGS option
Dperform a media recovery and bring the database to NOARCHIVELOG mode
-
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
-
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
-
What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()
ABMR lowers the mean time to recover (MTTR).
BBMR supports pointintime recovery of individual data blocks.
CBMR enables you to use incremental backups for block recovery.
DBMR enables recovery even when the database is not mounted or open.
EBMR enables you to use proxy backups to perform block media recovery.
FBMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.
-
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’;