ORA-00350: Log 4 Of Instance Needs To Be Archived - Learnomate Technologies

ANKUSH THAVALI
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.