OraFAQ Forum: Backup & Recovery » Restoring from RMAN backup nocatalog to a new machine

Home » RDBMS Server » Backup & Recovery » Restoring from RMAN backup nocatalog to a new machine

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

Restoring from RMAN backup nocatalog to a new machine [message #115831]

Thu, 14 April 2005 11:25

rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD

Junior Member

Hello. I am trying to test a restore and recover to a separate machine for a disaster recovery scenario. I am using Oracle 9.2.0.4 between 2 Unix servers one running solaris 8 and one running solaris 9. I can pull out the control file from my backup, but it does not seem to see the full backup I took with RMAN. i.e:

RMAN> restore database;

Starting restore at 14-APR-05

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/14/2005 09:49:52
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

My thinking was once I recovered the control file from the backup set the database would know where the database files are. Any ideas? In the Advanced Oracle RMAN guide it says the next step is to register the backup with the catalog? This is confusing because the scenario says 'Recovery not using a catalog.' Once again any help would be appreciated.

Report message to a moderator

Re: Restoring from RMAN backup nocatalog to a new machine [message #115854 is a reply to message #115831]

Thu, 14 April 2005 13:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

the backed up control file and whole backupset should be available and seen locally in the new machine.
have you done that?

Report message to a moderator

Re: Restoring from RMAN backup nocatalog to a new machine [message #115857 is a reply to message #115854]

Thu, 14 April 2005 13:49

rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD

Junior Member

Yes. I mounted the drive on the other machine so the directory structure is the same. I can pull the controlfile from the backup but not the datafiles. I am new to RMAN.

Report message to a moderator

Backing up to a remote site. [message #116342 is a reply to message #115857]

Tue, 19 April 2005 10:15

rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD

Junior Member

I have figured out how to restore the database to a new machine. What I need to know now is:

Is there a way to apply only new redo logs to the restored database to keep it up to date with my production database?

I am tasked with bringing a disaster recovery site up to speed and we can only transfer a limited amount of data there.

[Updated on: Tue, 19 April 2005 10:15]

Report message to a moderator

Re: Backing up to a remote site. [message #116343 is a reply to message #116342]

Tue, 19 April 2005 10:18

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it is what called as standby database.
Look into RMAN document for creating a standby database.

[Updated on: Tue, 19 April 2005 10:18]

Report message to a moderator

Re: Backing up to a remote site. [message #116896 is a reply to message #116343]

Fri, 22 April 2005 15:03

rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD

Junior Member

I have figured out how I am going to do it. I am going to leave the standby databases in a recover mode and feed it archive logs on a daily basis.

Report message to a moderator

Previous Topic:	Backup software
Next Topic:	Need Help In Replication.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 06:14:47 CST 2025