OraFAQ Forum: Data Guard » Creating 2 Physical Standbys

Home » Server Options » Data Guard » Creating 2 Physical Standbys (Oracle 10g Linux)

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

Creating 2 Physical Standbys [message #417805]

Tue, 11 August 2009 10:41

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

Hi,

I have successfully created a standby database in the test environment and now would like to add another one to the configuration, would i just have to change the LOG_ARCHIVE_CONFIG parameter to include the new standby eg

LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,STAN1,STAN2)'

and add a new LOG_ARCHIVE_DEST_n parameter.

Thanks

Report message to a moderator

Re: Creating 2 Physical Standbys [message #417806 is a reply to message #417805]

Tue, 11 August 2009 10:45

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

What is s your Question ??

Babu

Report message to a moderator

Re: Creating 2 Physical Standbys [message #417809 is a reply to message #417806]

Tue, 11 August 2009 10:50

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

would i just have to change the LOG_ARCHIVE_CONFIG parameter to include the new standby eg

LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,STAN1,STAN2)'

and add a new LOG_ARCHIVE_DEST_n parameter.

Call it a question or guidance i just want to know if the changes i have above would have to be made to the primary parameter file or if more changes have to be made. If you could provide a step by step process that would be helpful.

Thanks

Report message to a moderator

Re: Creating 2 Physical Standbys [message #417837 is a reply to message #417809]

Tue, 11 August 2009 13:35

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Yes. You can

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10823/scenarios.htm

Report message to a moderator

Re: Creating 2 Physical Standbys [message #417864 is a reply to message #417805]

Tue, 11 August 2009 22:26

willgsm
Messages: 5
Registered: August 2009
Location: Hanoi, Vietnam

Junior Member

Can you have detail create data guard for 11G?

Report message to a moderator

Re: Creating 2 Physical Standbys [message #417866 is a reply to message #417864]

Tue, 11 August 2009 22:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

willgsm wrote on Tue, 11 August 2009 20:26

Can you have detail create data guard for 11G?

do not cross/multi-post

http://www.orafaq.com/forum/m/417687/136107/#msg_417691

Report message to a moderator

Re: Creating 2 Physical Standbys [message #418006 is a reply to message #417866]

Wed, 12 August 2009 08:13

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

In 11g; also same method.

Are trying in RAC Environment??

Report message to a moderator

Re: Creating 2 Physical Standbys [message #418076 is a reply to message #418006]

Wed, 12 August 2009 20:56

willgsm
Messages: 5
Registered: August 2009
Location: Hanoi, Vietnam

Junior Member

gentlebabu wrote on Wed, 12 August 2009 08:13

In 11g; also same method.

Are trying in RAC Environment??

No. I want to find detail documents and examples to create data guard for oracle 11g.

Report message to a moderator

Re: Creating 2 Physical Standbys [message #418080 is a reply to message #417805]

Wed, 12 August 2009 21:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I want to find detail documents and examples to create data guard for oracle 11g.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/toc.htm

Report message to a moderator

Re: Creating 2 Physical Standbys [message #418199 is a reply to message #417805]

Thu, 13 August 2009 07:35

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

Can you offer some help with DB_FILE_NAME_CONVERT parameter. I know if i have 1 physical and 1 standby it looks like this

DB_FILE_NAME_CONVERT= '/dbfiles/STAN1','/dbfiles/PRIM'

but what does it look like if i have to add STAN2

Thanks

Report message to a moderator

Re: Creating 2 Physical Standbys [message #418207 is a reply to message #418199]

Thu, 13 August 2009 07:57

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

DB_FILE_NAME_CONVERT=
'/arch1/boston/','/arch1/chicago/','/arch2/boston/','/arch2/chicago/'
LOG_FILE_NAME_CONVERT=
'/arch1/boston/','/arch1/chicago/','/arch2/boston/','/arch2/chicago/'

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10823/create_ps.htm

Before asking quesiton; please read oracle document. 99% of answer available in oracle document.

thanks

Report message to a moderator

Re: Creating 2 Physical Standbys [message #418219 is a reply to message #418207]

Thu, 13 August 2009 08:38

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

I realize thats how its done with a primary and one standby but what occurs when a second standby is added. how does this affect the parameter.

Report message to a moderator

Previous Topic:	switching over to a standby with a 24 hours apply delay
Next Topic:	Upgrading Physical Standby Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 02:10:27 CST 2025