| clearing unarchived log file [message #326255] |
Tue, 10 June 2008 21:35  |
lotusdeva
Messages: 201
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!
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
