OraFAQ Forum: Backup & Recovery » Restoring Rman backup on test db in same network

Home » RDBMS Server » Backup & Recovery » Restoring Rman backup on test db in same network (oracle 10g 10.2.0.3.0 (Linux 64bit))

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

Restoring Rman backup on test db in same network [message #439812]

Tue, 19 January 2010 09:15

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

Hi,
I have rman backup from production database. Name and SID of production database is Prod1 and i want to to check this RMAN backup after restoring it on the other test server (VMDB) for Disaster recovery.

Now problem is that, i want to test it for DR, where i only need to run a script to restore and recover a database at the time of disaster in production site.

My disaster recovery site will be in different network, so i can keep the name of database and sid same as of Production but is it possible that i could install the database in test database with same db name and same sid as of Production when Test and Production database are in same network.

Report message to a moderator

Re: Restoring Rman backup on test db in same network [message #439814 is a reply to message #439812]

Tue, 19 January 2010 09:19

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

Senior Member
Account Moderator

>>it possible that i could install the database in test database
I beleive you meant Test Server.
Yes.
You can same SID and DBNAME in a separate server.

Report message to a moderator

Re: Restoring Rman backup on test db in same network [message #439816 is a reply to message #439814]

Tue, 19 January 2010 09:25

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

But this test server is in same network (but with different IP Address), does not it create a conflict between running production and test.
Network i means it is connected on same network switch

[Updated on: Tue, 19 January 2010 09:26]

Report message to a moderator

Re: Restoring Rman backup on test db in same network [message #439817 is a reply to message #439816]

Tue, 19 January 2010 09:30

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

Senior Member
Account Moderator

It should'nt (unless you want to Wink

.
Oracle Services are identified by a combination of ip/hostname,port and SID (in tnsnames.ora or jdbc like connection).

Report message to a moderator

Re: Restoring Rman backup on test db in same network [message #439821 is a reply to message #439817]

Tue, 19 January 2010 09:50

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

One more question i can have same DBID as of Production in other database server when it is running.

Secondly, do i need to install only oracle with patch update without database in test server or i should install database and then restor backup on the same database.

Report message to a moderator

Re: Restoring Rman backup on test db in same network [message #439826 is a reply to message #439821]

Tue, 19 January 2010 10:03

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

Senior Member
Account Moderator

Depends on how you restore.
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10734/rcmrecov.htm#1007704

Generally, you want the DBID to be different.
I would prep the target server to be in same Oracle version/patchset as the source.

Report message to a moderator

Re: Restoring Rman backup on test db in same network [message #439830 is a reply to message #439826]

Tue, 19 January 2010 10:27

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

i am not using catalog in rman backup creation. So i think i do not need DBID to restore the database

Report message to a moderator

Re: Restoring Rman backup on test db in same network [message #441183 is a reply to message #439812]

Fri, 29 January 2010 04:47

entekeralam
Messages: 19
Registered: January 2010

Junior Member

Check this.. This is to restore RAC to single instance. But steps will be similar for your requirement

dbaregistry.blogspot.com/2010/01/howto-restore-rac-database-to-single.html

Report message to a moderator

Previous Topic:	Restore from backup
Next Topic:	Need to move the datafiles from ASM to Veritas file system vxfs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 10:13:15 CDT 2024