Master in Oracle Golden Gate | Join us for the demo session on 22nd November 2025 at 6:00 PM IST

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

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 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.

Let's Talk

Find your desired career path with us!

Let's Talk

Find your desired career path with us!