| Lost current online log file [message #469111] |
Tue, 03 August 2010 06:53  |
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
|
Senior Member |
|
|
Hi suppose I lost all members of online log file group currently being weitten to and need recovery I recovered it upto to the lost archive log using "RECOVER DATABASE UNTIL CANCEL".But when I open the database It says database inconsistent and It doesnt open.
So should I use "Recover database until time" in this case to recover consistent copy of database.If I recover database until time does it always do a consistent recovery up to most consistent SCN whichever is close to time specified?
|
|
|
|
|
|
|
|
| Re: Lost current online log file [message #469549 is a reply to message #469111] |
Thu, 05 August 2010 02:22  |
Yasir Hashmi
Messages: 304
Registered: April 2006
|
Senior Member |
|
|
Hi,
If you lost the current log group,you need to do incomeplete recovery or if you have flashback enabled,flashback the database. THe SCn upto which you want to restore can be get by:
SQL>select group#,first_change# from v$log;
Then
RMAN>run
{
set until scn <SCN>;
restore database;
recover database;
sql "alter database open resetlogs";
}
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
