OraFAQ Forum: Backup & Recovery » how to apply archive on consistent backup ...

Home » RDBMS Server » Backup & Recovery » how to apply archive on consistent backup ... (Oracle 10.2.0.4 AIX 6L )

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

how to apply archive on consistent backup ... [message #494507]

Tue, 15 February 2011 05:54

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

Report message to a moderator

Re: how to apply archive on consistent backup ... [message #494511 is a reply to message #494507]

Tue, 15 February 2011 06:35

Mahesh Rajendran
Messages: 10708
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;

Report message to a moderator

Re: how to apply archive on consistent backup ... [message #494512 is a reply to message #494511]

Tue, 15 February 2011 06:46

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks Mahesh for providing the steps.

Regards,
Jay vardhan

Report message to a moderator

Previous Topic:	restore with rman
Next Topic:	RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:56:42 CST 2024