Home » RDBMS Server » Backup & Recovery » Restore RAC backup to stand alone
Restore RAC backup to stand alone [message #301020] Tue, 19 February 2008 00:31 Go to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
Hi All,

I have 9i RAC (2 nodes) production DB (using raw devices) taken backup daily to another node using rman.
now, I want to test this backup by restore it to anew 9i host stand alone.

note: both prod & test have same oracle and OS version

Is there any clear procedure?

thanks in advance
Re: Restore RAC backup to stand alone [message #301021 is a reply to message #301020] Tue, 19 February 2008 00:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Advanced User's Guide
Chapter 7 Advanced RMAN Recovery Techniques
Section Restore and Recovery of the Database on a New Host

Regards
Michel
Re: Restore RAC backup to stand alone [message #301023 is a reply to message #301020] Tue, 19 February 2008 00:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Same procedure.
Just cross mount or NFS mount your backup area (say, if you are backing up to /backup) so that the /backup is visible from other node
Or
You need to copy the files.
If you are doing a point in time restoration, do a restoration/clone after taking a backup and point a point in time before. Else you may need to copy archived logs also.
Re: Restore RAC backup to stand alone [message #301038 is a reply to message #301020] Tue, 19 February 2008 00:51 Go to previous messageGo to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
thanks all

but this procedure for 10g Release 2 (10.2) , Is it workable?

I'm asking for 9i
Re: Restore RAC backup to stand alone [message #301040 is a reply to message #301038] Tue, 19 February 2008 00:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quoting myself.
>>Same procedure.

Just follow the same procedure that exists already.
Just change the sid,node, path etc.
And just refer to 9i manual.

[Updated on: Tue, 19 February 2008 00:57]

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301056 is a reply to message #301020] Tue, 19 February 2008 01:40 Go to previous messageGo to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
This scenario is talking about restore stand alone db to anew host stand alone also, no mention for RAC as you know each instance of RAC has its own archivelog.

your help is appertained
Re: Restore RAC backup to stand alone [message #301059 is a reply to message #301056] Tue, 19 February 2008 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't worry, RMAN knows which archived logs to apply, just give it access to them, all of them from both threads.

Regards
Michel
Re: Restore RAC backup to stand alone [message #301095 is a reply to message #301020] Tue, 19 February 2008 03:27 Go to previous messageGo to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
thanks Michel.

one more question , what you think about this note in the link.
can I use RESYNC CATALOG to resolve this issue?

Note:
If you perform a test restore only, then do not connect to the recovery catalog when restoring the datafiles. Otherwise, RMAN records information about the restored datafiles to the recovery catalog. This intereferes with future attempts to restore and recover the primary database. If you must use a recovery catalog because the control file is not large enough to contain the RMAN repository data on all of the backups that you need to restore, then export the catalog and import it into a different schema or database and use the copied recovery catalog for the test restore. Otherwise, the catalog considers the restored database as the current target database.

Regards
Re: Restore RAC backup to stand alone [message #301098 is a reply to message #301095] Tue, 19 February 2008 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, I don't know the answer.
Tests have to be made.

Regards
Michel
Re: Restore RAC backup to stand alone [message #301100 is a reply to message #301098] Tue, 19 February 2008 03:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need to register again in recovery catalog.
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrepos.htm#431385

Re: Restore RAC backup to stand alone [message #302932 is a reply to message #301020] Wed, 27 February 2008 06:52 Go to previous messageGo to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
Greeting,

when I connect to target DB to run a backup script, is it needed to connect with sys user or any other user has SYSDBA role?

Regards
Re: Restore RAC backup to stand alone [message #302954 is a reply to message #302932] Wed, 27 February 2008 07:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmcnctg.htm#443912

Generally, any user with sysdba role.
Generally, there is a less need for more than one SYSDBA user (default being sys) in a typical database.
Re: Restore RAC backup to stand alone [message #305182 is a reply to message #301020] Mon, 10 March 2008 00:46 Go to previous message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
hi all,

full restore of my production DB was successfully restored to a test node and up to this point db is mounted.
now when I tried to open DB I got :
---------------------------------------------
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oradata/system_001.dbf'
-----------------------------------------------
I tried to do recover using rman also

run {
set archivelog destination to '/oradata/arch_files';
Allocate CHANNEL t1 DEVICE TYPE 'SBT_TAPE' ;
restore archivelog all;
recover database;
Release channel t1;
}

the result is :
RMAN-00571: ====================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ========
RMAN-00571: ====================================================
RMAN-03002: failure of restore command at 03/10/2008 08:12:57
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 2 seq 5179 scn 7248975219054 found to restore
notes : it shows many lines as RMAN-06025 !!
also I did not find any redo file restored !!

Is there any missing point on this case ?

thanks

Previous Topic: recovery manager
Next Topic: Recovering data from corrupted DMP file
Goto Forum:
  


Current Time: Wed Dec 07 11:00:01 CST 2016

Total time taken to generate the page: 0.14410 seconds