Home » RDBMS Server » Backup & Recovery » Restoring Rman backup on test db in same network (oracle 10g 10.2.0.3.0 (Linux 64bit))
Restoring Rman backup on test db in same network [message #439812] Tue, 19 January 2010 09:15 Go to next message
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.





Re: Restoring Rman backup on test db in same network [message #439814 is a reply to message #439812] Tue, 19 January 2010 09:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Restoring Rman backup on test db in same network [message #439816 is a reply to message #439814] Tue, 19 January 2010 09:25 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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).
Re: Restoring Rman backup on test db in same network [message #439821 is a reply to message #439817] Tue, 19 January 2010 09:50 Go to previous messageGo to next message
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.
Re: Restoring Rman backup on test db in same network [message #439826 is a reply to message #439821] Tue, 19 January 2010 10:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Restoring Rman backup on test db in same network [message #439830 is a reply to message #439826] Tue, 19 January 2010 10:27 Go to previous messageGo to next message
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
Re: Restoring Rman backup on test db in same network [message #441183 is a reply to message #439812] Fri, 29 January 2010 04:47 Go to previous message
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
Previous Topic: Restore from backup
Next Topic: Need to move the datafiles from ASM to Veritas file system vxfs
Goto Forum:
  


Current Time: Mon Dec 05 02:54:47 CST 2016

Total time taken to generate the page: 0.12100 seconds