Cause: The logfile group 2 contain committed data which are not written into data file because of checkpoint not completed.
Solution: Perform the manual checkpoint using ALTER SYSTEM CHECKPOINT GLOBAL command and drop the logfile.
SQL> alter database drop logfile group 2;
*
ERROR at line 2:
ORA-01624: log 2 needed for crash recovery of instance
ORA-00312: online log 2 thread 1: '+DATA/CBSDB/ONLINELOG/redo-02-01.log'
So to make ACTIVE to INACTIVE exeute system level checkpoint.
SQL> ALTER SYSTEM CHECKPOINT GLOBAL;
System altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL>
Solution: Perform the manual checkpoint using ALTER SYSTEM CHECKPOINT GLOBAL command and drop the logfile.
SQL> alter database drop logfile group 2;
*
ERROR at line 2:
ORA-01624: log 2 needed for crash recovery of instance
ORA-00312: online log 2 thread 1: '+DATA/CBSDB/ONLINELOG/redo-02-01.log'
So to make ACTIVE to INACTIVE exeute system level checkpoint.
SQL> ALTER SYSTEM CHECKPOINT GLOBAL;
System altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL>
An Oracle database system identified by an alphanumeric system identifier or SID comprises at least one instance of the application, along with data storage. Also connect with the best Oracle Online Training in your locality at CatchExperts.com
ReplyDelete