Home » RDBMS Server » Backup & Recovery » RMAN-06556: datafile 1 must be restored from backup older than scn
RMAN-06556: datafile 1 must be restored from backup older than scn [message #315191] Sat, 19 April 2008 16:54 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10g in Linux machine .

I took a full database backup using RMAN . controlfile autobackup is set to off and I dont have any other backup of controlfile .

Now I lost all the members of current log file and the instance terminated .
When I tried restoring from backup and using recover until sequence to recover the database I faced this error

RMAN-03002: failure of recover command at 04/19/2008 13:21:32
RMAN-06556: datafile 1 must be restored from backup older than scn 5965106363950


Let me know what should be done ?
Re: RMAN-06556: datafile 1 must be restored from backup older than scn [message #315197 is a reply to message #315191] Sat, 19 April 2008 17:39 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>Let me know what should be done ?
datafile 1 must be restored from backup older than scn 5965106363950

Or start from scratch with a fresh installation & no data.

Re: RMAN-06556: datafile 1 must be restored from backup older than scn [message #315198 is a reply to message #315191] Sat, 19 April 2008 17:55 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I don't have a older backup so you mean to say that I cannot recover this database by any means ?

When I searched in the net I cam across this parameter
_allow_resetlogs_corruption = true
which allowed me to open the database using resetlogs , ofcourse there is a compromise to data consistency

Is this the only one way to get the database running ?
Re: RMAN-06556: datafile 1 must be restored from backup older than scn [message #315205 is a reply to message #315198] Sat, 19 April 2008 22:00 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How are you performing your restore/recovery?

If you have a good RMAN backup and you only lost your current redo log, then you'll lose any data in that log, but you should still be able to recover.

Startup mount your database and perform the following query:

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

At this point, you should be able to perform the following in RMAN:

RMAN> run {
      restore database;
      recover database until scn <scn_from_current_log_above>;
      }
RMAN> alter database open resetlogs;
Previous Topic: RMAN job completed with warnings
Next Topic: logs syncing
Goto Forum:
  


Current Time: Mon Dec 05 21:33:04 CST 2016

Total time taken to generate the page: 0.10140 seconds