Home » RDBMS Server » Backup & Recovery » RMAN recovery to DR
RMAN recovery to DR [message #359445] Sun, 16 November 2008 05:56 Go to next message
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;
}

[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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: RMAN recovery to DR [message #359458 is a reply to message #359453] Sun, 16 November 2008 12:16 Go to previous message
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.
Previous Topic: ***How to take RMAN backup in IBM TS3100 tape library***
Next Topic: Archive Backup Failed
Goto Forum:
  


Current Time: Mon Dec 05 02:36:03 CST 2016

Total time taken to generate the page: 0.09315 seconds