Home » RDBMS Server » Backup & Recovery » resetlogs issue (10.2.0.1)
resetlogs issue [message #546497] Wed, 07 March 2012 03:47 Go to next message
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



Re: resetlogs issue [message #546515 is a reply to message #546497] Wed, 07 March 2012 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: resetlogs issue [message #546517 is a reply to message #546515] Wed, 07 March 2012 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: resetlogs issue [message #546543 is a reply to message #546517] Wed, 07 March 2012 05:51 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks Michel!
Previous Topic: RMAN Restore to another Device
Next Topic: how to use the incarnation command
Goto Forum:
  


Current Time: Thu Mar 28 06:46:01 CDT 2024