SOLVED

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

Asked by OracleDba••13 views•oracle
1
2
3
4
5
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.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
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.
OracleDba•

Post Your Solution