- 21 Dec, 2023
- 0 Comments
- 1 Min Read
ORA-00350: Log 4 Of Instance Needs To Be Archived
Problem :
After restoring a RAC database to a standalone database through RMAN, we tried to drop the redo log groups belongs to thread 2. We got this error.Solution :
Before dropping, we need to clear the redolog using below command.SQL> alter database clear unarchived logfile group 7; Database altered.Now try to drop again:
SQL> alter database drop logfile group 7; Database altered.