Home » RDBMS Server » Backup & Recovery » clearing unarchived log file (10.2.0.3)
clearing unarchived log file [message #326255] Tue, 10 June 2008 21:35 Go to next message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
Hello, I am trying to recover from the loss of the unarchived redo log group:

SQL> select group#, members, status, archived
  2  from v$log;

    GROUP#    MEMBERS STATUS     ARCHIVED
---------- ---------- ---------- ---------------
         2          2 INACTIVE   NO
         1          2 CURRENT    NO



However, when I try to clear the logfile group, database just hangds.

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;


Database was open when the group was "lost". What can I do in this situation?

thank you!
Re: clearing unarchived log file [message #326270 is a reply to message #326255] Tue, 10 June 2008 23:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must have at least 3 groups.
So first add a group.

Regards
Michel
Re: clearing unarchived log file [message #326313 is a reply to message #326255] Wed, 11 June 2008 01:18 Go to previous messageGo to next message
abed24
Messages: 16
Registered: October 2006
Location: Jordan
Junior Member

did you try to switch to logfile group 1 before clearing group 2 ?

alter system switch logfile;

*caution: don't shutdown your db
Re: clearing unarchived log file [message #326321 is a reply to message #326313] Wed, 11 June 2008 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
did you try to switch to logfile group 1 before clearing group 2 ?

See the query result, group 1 is the current redo logs.

Regards
Michel
Re: clearing unarchived log file [message #326436 is a reply to message #326313] Wed, 11 June 2008 09:02 Go to previous message
lotusdeva
Messages: 198
Registered: March 2005
Senior Member
switching logfile didn't help, so I had to shutdown. After I cleared the group, I took whole backup for future recoveries. Thank you!
Previous Topic: Is my backup strategy safe?
Next Topic: Copy part of database to a new database
Goto Forum:
  


Current Time: Wed Dec 07 08:33:09 CST 2016

Total time taken to generate the page: 0.12434 seconds