OraFAQ Forum: Backup & Recovery » Restore RAC backup to stand alone

Home » RDBMS Server » Backup & Recovery » Restore RAC backup to stand alone

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

Restore RAC backup to stand alone [message #301020]

Tue, 19 February 2008 00:31

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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301021 is a reply to message #301020]

Tue, 19 February 2008 00:33

Michel Cadot
Messages: 68650
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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301023 is a reply to message #301020]

Tue, 19 February 2008 00:35

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301038 is a reply to message #301020]

Tue, 19 February 2008 00:51

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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301040 is a reply to message #301038]

Tue, 19 February 2008 00:53

Mahesh Rajendran
Messages: 10707
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

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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301059 is a reply to message #301056]

Tue, 19 February 2008 01:43

Michel Cadot
Messages: 68650
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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301095 is a reply to message #301020]

Tue, 19 February 2008 03:27

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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301098 is a reply to message #301095]

Tue, 19 February 2008 03:36

Michel Cadot
Messages: 68650
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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #301100 is a reply to message #301098]

Tue, 19 February 2008 03:37

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #302932 is a reply to message #301020]

Wed, 27 February 2008 06:52

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

Report message to a moderator

Re: Restore RAC backup to stand alone [message #302954 is a reply to message #302932]

Wed, 27 February 2008 07:26

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Restore RAC backup to stand alone [message #305182 is a reply to message #301020]

Mon, 10 March 2008 00:46

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 23:34:49 CDT 2024