OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » resetlogs issue (10.2.0.1)

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

resetlogs issue [message #546497]

Wed, 07 March 2012 03:47

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
If my database has resetlogs,do it can not recover to the time which before the resetlogs?

1.do incomplete recover

run{
allocate channel c1 type disk;
allocate channel c2 type disk;
set until time "to_date('2012-02-29 04:02:29','YYYY-MM-DD HH24:MI:SS')";
restore database;
recover database;
}

2. open the database with resetlogs

alter database open resetlogs;

3.backup the database

run{
allocate channel dup type disk;
backup format '/u01/app/oracle/duplicate/df_t%t_s%s_p%p' database;
backup current controlfile format '/u01/app/oracle/duplicate/ct_t%t_s%s_p%p';
sql 'alter system archive log current';
backup format '/u01/app/oracle/duplicate/al_t%t_s%s_p%p' archivelog all delete input;
release channel dup;
}

4.Do incomplete recover just as step1

run{
allocate channel c1 type disk;
allocate channel c2 type disk;
set until time "to_date('2012-02-29 04:02:29','YYYY-MM-DD HH24:MI:SS')";
restore database;
recover database;
}

executing command: SET until clause
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 03/06/2012 21:29:48
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

Report message to a moderator

Re: resetlogs issue [message #546515 is a reply to message #546497]

Wed, 07 March 2012 04:35

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
 *Cause: UNTIL TIME and RECOVERY WINDOW cannot be less than the database
         creation time or RESETLOGS time.
 *Action: Check the UNTIL TIME or RECOVERY WINDOW. If the database
          needs to be restored to an old incarnation, use the
          RESET DATABASE TO INCARNATION command.

Once again post the COMPLETE sessions NOT just your interpretation.

Regards
Michel

Report message to a moderator

Re: resetlogs issue [message #546517 is a reply to message #546515]

Wed, 07 March 2012 04:38

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The answer is in your previous topic how to use the incarnation command where I am still waiting for a feedback as for many other ones.

Regards
Michel

Report message to a moderator

Re: resetlogs issue [message #546543 is a reply to message #546517]

Wed, 07 March 2012 05:51

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks Michel!

Report message to a moderator

Previous Topic:	RMAN Restore to another Device
Next Topic:	how to use the incarnation command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 06:18:16 CDT 2025