OraFAQ Forum: Backup & Recovery » RMAN recovery to DR

Home » RDBMS Server » Backup & Recovery » RMAN recovery to DR

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

RMAN recovery to DR [message #359445]

Sun, 16 November 2008 05:56

bbasra
Messages: 2
Registered: November 2008

Junior Member

Hi,

I have taken over this task but stuck and could do with some help.

Any changes made in the live database are not there when I recover on the DR.

So i cleared down the FRA Except for the ArchiveLogs folder.

It seems like the recovery is not looking for the latest backup. Log file is attached.

Any ideas?

The script run is:

recovery.bat

del /f/q C:\Oracle\ora10g\oradata\DIM10\*.* > c:\oracleRMAN\restore-backup.log
oradim -startup -sid dim10 -starttype srvc
copy E:\oraclerecoveryarea\DIM10\controlfile\ctrl2.ora C:\Oracle\ora10g\oradata\DIM10\ctl1pcms.ora >> c:\oracleRMAN\restore-backup.log
rman target sys/change_on_install CMDFILE=c:\oracleRMAN\restore-backup.script >> c:\oracleRMAN\restore-backup.log
rman target sys/change_on_install CMDFILE=c:\oracleRMAN\open-after-restore.script >> c:\oracleRMAN\restore-backup.log

restore-backup.script

set dbid=2318069170
run {
startup mount
restore database;
recover database until scn 9999999;
}

open-after-restore.script

run
{
alter database open resetlogs;
}

Attachment: restore-backup.log
(Size: 8.22KB, Downloaded 1335 times)

[Updated on: Sun, 16 November 2008 06:01]

Report message to a moderator

Re: RMAN recovery to DR with Roll-forward [message #359451 is a reply to message #359445]

Sun, 16 November 2008 09:46

ebrian
Messages: 2794
Registered: April 2006

Senior Member

I split your thread, but next time you should start your own thread. If you want to reference another thread then just include it in your post.

If you removed the backupsets from the FRA, then how do you expect the restore process to restore the files ?

[Updated on: Sun, 16 November 2008 09:48]

Report message to a moderator

Re: RMAN recovery to DR [message #359453 is a reply to message #359445]

Sun, 16 November 2008 09:59

bbasra
Messages: 2
Registered: November 2008

Junior Member

Hi,

Sorry.

Continuing from http://www.orafaq.com/forum/t/124889/132256/

I only deleted the old backup sets as recent ones have been created but the recovery will not restore the latest but the old backup sets.

Even with the old backupsets there, any recent changes to the db are not recovered.

Report message to a moderator

Re: RMAN recovery to DR [message #359458 is a reply to message #359453]

Sun, 16 November 2008 12:16

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You should try restoring your controlfile from the backup with RMAN.

Otherwise, you should issue CROSSCHECK BACKUP after you MOUNT the database.

Report message to a moderator

Previous Topic:	*How to take RMAN backup in IBM TS3100 tape library*
Next Topic:	Archive Backup Failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 12:44:35 CST 2024