SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1:
'/u01/oracle/PROD/db/apps_st/data/log01a.dbf'
ORA-00312: online log 1 thread 1:
'/u01/oracle/PROD/db/apps_st/data/log01b.dbf'
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
2 0 NO CLEARING_CURRENT
1 0 YES CLEARING
SQL> alter database clear logfile group 1;
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 2 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 2 thread 1:
'/u01/oracle/PROD/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1:
'/u01/oracle/PROD/db/apps_st/data/log02b.dbf'
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
2 0 NO CLEARING_CURRENT
1 0 YES UNUSED
SQL> alter database clear logfile group 2;
Database altered.
SQL> alter database open resetlogs;
No comments:
Post a Comment