OraFAQ Forum: Data Guard » Standby Database

Home » Server Options » Data Guard » Standby Database

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

Standby Database [message #64540]

Mon, 07 February 2005 01:00

devika
Messages: 21
Registered: November 2004

Junior Member

I was able to create a stabdby database successfully(i.e archive log files were transfered from the primary to the standby successfully).
However my problem is, how do we reflect any of the structural changes that we make to the primary in the standby as well automatically
for eg.. I create a new tablespace and a few tables affiliated with that particular tablespace. Now I need to automatically reflect these changes in the Standby Database.
Can someone kindly provide me with the step by step explanation to accomplish this
any inputs will be greatly appreciated.

Report message to a moderator

Re: Standby Database [message #64541 is a reply to message #64540]

Mon, 07 February 2005 01:07

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

Oracle will manage it automatically if you set STANDBY_FILE_MANAGEMENT to AUTO. The default is MANUAL.

From the Oracle Reference Guide:

"When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database."

Best regards.

Frank

Report message to a moderator

Re: Standby Database [message #110783 is a reply to message #64541]

Thu, 10 March 2005 05:42

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi Frank,

is there any special version from Oracle needed to use this Parameter ? Will it be possible from 9.2.x or is this a feature in 10g ?

Thanks
Uwe

Report message to a moderator

Re: Standby Database [message #115907 is a reply to message #64540]

Fri, 15 April 2005 02:46

Satheesh Babu.S
Messages: 35
Registered: July 2004

Member

Hi, it is available in 92x.

Thanks and Regards,
Satheesh Babu.S
Bangalore.

Report message to a moderator

Previous Topic:	standby alternative... is it possible?
Next Topic:	dataguard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 06 05:38:20 CDT 2025