Home » RDBMS Server » Backup & Recovery » Lost current online log file (Windows,10.2.0.3)
Lost current online log file [message #469111] Tue, 03 August 2010 06:53 Go to next message
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 #469145 is a reply to message #469111] Tue, 03 August 2010 09:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10629
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen.htm#CACFFJFB
Re: Lost current online log file [message #469268 is a reply to message #469145] Wed, 04 August 2010 02:01 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
If I recover database until time does it always do a consistent recovery up to most consistent SCN whichever is close to time specified? I cant get It do explain
Re: Lost current online log file [message #469549 is a reply to message #469111] Thu, 05 August 2010 02:22 Go to previous message
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";
}



Previous Topic: RMAN-06555: datafile 11 must be restored from backup created before
Next Topic: Media Recovery failed due to the missing Log files.
Goto Forum:
  


Current Time: Mon Nov 24 00:55:55 CST 2014

Total time taken to generate the page: 0.04650 seconds