OraFAQ Forum: Backup & Recovery » RMAN-06556: datafile 1 must be restored from backup older than scn

Home » RDBMS Server » Backup & Recovery » RMAN-06556: datafile 1 must be restored from backup older than scn

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN-06556: datafile 1 must be restored from backup older than scn [message #315191]

Sat, 19 April 2008 16:54

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 ?

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

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 ?

Report message to a moderator

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

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;

Report message to a moderator

Previous Topic:	RMAN job completed with warnings
Next Topic:	logs syncing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 17:23:14 CST 2024