After re-sizing redo log getting below error while dropping redo log group.
Before drop we should make sure aleast 3 redo group are there and droping group should be in INACTIVE state.
SQL> alter database drop logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance (thread 1)
ORA-00312: online log 1 thread 1: '/u01/oradata//redolog/redo01_a.log'
So to make ACTIVE to INACTIVE exeute system level checkpoint.
SQL> ALTER SYSTEM CHECKPOINT GLOBAL;
System altered.
SQL>
SQL> select GROUP#,THREAD#,STATUS from v$log;
GROUP# THREAD# STATUS
---------- ---------- ----------------
1 1 INACTIVE
4 1 INACTIVE
5 1 CURRENT
6 1 INACTIVE
7 1 INACTIVE
8 1 INACTIVE
Now drop the group.
SQL> alter database drop logfile group 1;
Database altered.
SQL>
Before drop we should make sure aleast 3 redo group are there and droping group should be in INACTIVE state.
SQL> alter database drop logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance (thread 1)
ORA-00312: online log 1 thread 1: '/u01/oradata//redolog/redo01_a.log'
So to make ACTIVE to INACTIVE exeute system level checkpoint.
SQL> ALTER SYSTEM CHECKPOINT GLOBAL;
System altered.
SQL>
SQL> select GROUP#,THREAD#,STATUS from v$log;
GROUP# THREAD# STATUS
---------- ---------- ----------------
1 1 INACTIVE
4 1 INACTIVE
5 1 CURRENT
6 1 INACTIVE
7 1 INACTIVE
8 1 INACTIVE
Now drop the group.
SQL> alter database drop logfile group 1;
Database altered.
SQL>
No comments:
Post a Comment