Home » Server Options » Data Guard » Create Logical Standby coexisting with Physical Standby database (Oracle 9, Solaris 9)
Create Logical Standby coexisting with Physical Standby database [message #425178] Wed, 07 October 2009 23:14 Go to next message
sidiq
Messages: 3
Registered: October 2009
Junior Member
Hai ...

I Need create logical Standby database from my primary database and we already have Physical Standby database.

Could any one give where i get the Document step to create this logical standby with consider that i already have Physical Standby database and give some info any "pits-fall" than could happen when we create two standby database.

Thanks U Very Much

Re: Create Logical Standby coexisting with Physical Standby database [message #425187 is a reply to message #425178] Wed, 07 October 2009 23:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ls.htm#1073769

Regards
Michel
Re: Create Logical Standby coexisting with Physical Standby database [message #425209 is a reply to message #425187] Thu, 08 October 2009 01:19 Go to previous messageGo to next message
sidiq
Messages: 3
Registered: October 2009
Junior Member
Thanks Michel

Actualy i already read this document , but my problem what will happen to my Physical Standby ,if i reconfigure parameter on my primary database to enable my logical Standby database ?

regars

Sidiq
Re: Create Logical Standby coexisting with Physical Standby database [message #425218 is a reply to message #425209] Thu, 08 October 2009 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but my problem what will happen to my Physical Standby

Nothing, just add the new configuration parameters.

Regards
Michel
Re: Create Logical Standby coexisting with Physical Standby database [message #425232 is a reply to message #425178] Thu, 08 October 2009 03:12 Go to previous messageGo to next message
sidiq
Messages: 3
Registered: October 2009
Junior Member
ok thanks ...

do you have any experince on switch over from primary database to Physical Standby , there are any problem with my logical Standby database if i do switch over.

my points are my primary database that source of my logaical Standby database will became Physical Standby database and my physical stanby database will became Primary database after switch over.

its will be changing source in automatically for my logical standby database if i do switch over.


Regards

Sidiq
Re: Create Logical Standby coexisting with Physical Standby database [message #429624 is a reply to message #425232] Wed, 04 November 2009 15:15 Go to previous message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
sidiq wrote on Thu, 08 October 2009 13:42
there are any problem with my logical Standby database if i do switch over.



If your logical standby db not participate in SWITHCOVER activity then there will be no problem ocurred. Your logical standby db automatically become source of new primary db.

Regards,
Vish
Previous Topic: Physical standby missing datafile
Next Topic: Delete the datafile from Standby
Goto Forum:
  


Current Time: Thu Mar 28 17:01:54 CDT 2024