Home » Server Options » Data Guard » Primary and standby issues (Oracle 9i, Apps 11i, Sun Solaris Server)
Primary and standby issues [message #407023] Mon, 08 June 2009 03:32 Go to next message
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 Smile
Re: Primary and standby issues [message #407028 is a reply to message #407023] Mon, 08 June 2009 03:50 Go to previous messageGo to next message
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 #407048 is a reply to message #407023] Mon, 08 June 2009 05:14 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Creating a Single Instance Physical Standby for a RAC Primary.

The document is for 10g, but the process is the same.
Re: Primary and standby issues [message #407054 is a reply to message #407023] Mon, 08 June 2009 05:31 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
Thank you guys, I really appreciate it..

We are not implementing RAC, so is it okay to follow the steps you gave?

(I'm new to the DBA world by the way)

[Updated on: Mon, 08 June 2009 05:33]

Report message to a moderator

Re: Primary and standby issues [message #407057 is a reply to message #407023] Mon, 08 June 2009 05:36 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
amshajri wrote on Mon, 08 June 2009 04:32
Sitaution details:

We are running primary database on multi-node server

What are you considering a multi-node server ?
Re: Primary and standby issues [message #407062 is a reply to message #407057] Mon, 08 June 2009 05:43 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
ebrian wrote on Mon, 08 June 2009 14:36

What are you considering a multi-node server ?

I meant we have two instances in one server and only one instance in the other server which we want to be as a standby db. Embarassed
Re: Primary and standby issues [message #407065 is a reply to message #407062] Mon, 08 June 2009 05:54 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
As Sahba mentioned, you can't just turn the testing database into a standby database. You'll have to create the standby from the primary.

Check Creating a Standby Database with Recovery Manager.
Re: Primary and standby issues [message #407067 is a reply to message #407023] Mon, 08 June 2009 06:03 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
Thank you ebrian..

Thank you Sahba..

I'm sure it'll help me alot.
Re: Primary and standby issues [message #407113 is a reply to message #407023] Mon, 08 June 2009 08:50 Go to previous messageGo to next message
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
Re: Primary and standby issues [message #407115 is a reply to message #407113] Mon, 08 June 2009 08:58 Go to previous message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
Thank you Sahba for the advice..

I really hope everything works well.
Previous Topic: Setup Physical Standby Database
Next Topic: PHYSICAL STANDBY SWITCHOVER PROBLEM
Goto Forum:
  


Current Time: Thu Mar 28 11:30:48 CDT 2024