| Primary and standby issues [message #407023] |
Mon, 08 June 2009 03:32  |
amshajri
Messages: 20
Registered: June 2009
Location: Oman
|
Junior Member |
|
|
Sitaution details:
We are running primary database on multi-node server and and testing database on another single-node server. We want to make test db as a physical standby database.
What steps do we need to follow?
Thanks 
|
|
|
|
| Re: Primary and standby issues [message #407028 is a reply to message #407023] |
Mon, 08 June 2009 03:50  |
Sahba1969
Messages: 14
Registered: March 2009
Location: Austria
|
Junior Member |
|
|
Hi,
i assume, you want to get the test db on a standalone server to be a standby db to the RAC primary.
1.the server must be of the same Operating system as your primary db server, as well as the oracle software version
2.your test db have to be deleted from the server.
4.go through the installation process of setting up a physical standby db, i.e. make a RMAN backup of the primary, and restore as physical standby db.
you cannot use a standalone test db to setup as physical standby db. the standby db will need to have the same DBID as the primary db.
good luck.
regards
Sahba
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Primary and standby issues [message #407113 is a reply to message #407023] |
Mon, 08 June 2009 08:50 |
Sahba1969
Messages: 14
Registered: March 2009
Location: Austria
|
Junior Member |
|
|
amshajri,
for every primary db, you can setup up to 8 standby dbs (you have 1 to 10 destinations, the 10th is mainly for Flash Recovery Area, and local archive destination).
this means, for the 2 instances you have on one server, for each of the instances can have a standby db.
therefore, you need to choose one of the instance to be your primary db, and use the test server to setup the standby db on it.
read the note you recieved from ebrian, and soon you'll see how Oracle Data Guard should be setup and maintained.
be carefull with the oracle files, not to mess them up, as you have two instances.
have fun with the setup.
Sahba
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
