Home » RDBMS Server » Backup & Recovery » how to apply archive on consistent backup ... (Oracle 10.2.0.4 AIX 6L )
how to apply archive on consistent backup ... [message #494507] Tue, 15 February 2011 05:54 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hello,

Shall i need you suggestion in applying the archive files for cold backup.

Actually, i have test database open in read only and i want to apply archive files carry from production database at daily level.
When i'm going for recovery, since database is already in consistent state, it is not asking for recovery.

Please suggest.

Regards,
Jay vardhan
Re: how to apply archive on consistent backup ... [message #494511 is a reply to message #494507] Tue, 15 February 2011 06:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need to use the backup controlfile, recover until last archivelog is applied,stop and open database with RESETLOGS.
Something like this

alter database recover until cancel using backup controlfile;
alter database recover continue default; --until it errors.
alter database recover cancel;
alter database open resetlogs;
Re: how to apply archive on consistent backup ... [message #494512 is a reply to message #494511] Tue, 15 February 2011 06:46 Go to previous message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks Mahesh for providing the steps.

Regards,
Jay vardhan
Previous Topic: restore with rman
Next Topic: RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
Goto Forum:
  


Current Time: Thu Mar 28 15:36:29 CDT 2024