Home » RDBMS Server » Backup & Recovery » Restoring from RMAN backup nocatalog to a new machine
Restoring from RMAN backup nocatalog to a new machine [message #115831] Thu, 14 April 2005 11:25 Go to next message
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.
Re: Restoring from RMAN backup nocatalog to a new machine [message #115854 is a reply to message #115831] Thu, 14 April 2005 13:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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?
Re: Restoring from RMAN backup nocatalog to a new machine [message #115857 is a reply to message #115854] Thu, 14 April 2005 13:49 Go to previous messageGo to next message
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.
Backing up to a remote site. [message #116342 is a reply to message #115857] Tue, 19 April 2005 10:15 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous message
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.
Previous Topic: Backup software
Next Topic: Need Help In Replication.
Goto Forum:
  


Current Time: Fri Mar 29 09:53:54 CDT 2024