OraFAQ Forum: Data Guard » Alter tablespace with dataguard

Home » Server Options » Data Guard » Alter tablespace with dataguard

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

Alter tablespace with dataguard [message #215175]

Fri, 19 January 2007 09:38

fnguy
Messages: 39
Registered: January 2006

Member

I need to add space to two files in a tablespace. Max. protection mode, I think. Ora 9.2.0.6

Will this change be replicated to the physical standby?

Thanks.

Report message to a moderator

Re: Alter tablespace with dataguard [message #215201 is a reply to message #215175]

Fri, 19 January 2007 12:10

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Ensure that you have STANDBY_FILE_MANAGEMENT set to AUTO and the change will propogate to the standby.

Report message to a moderator

Re: Alter tablespace with dataguard [message #215203 is a reply to message #215201]

Fri, 19 January 2007 12:22

fnguy
Messages: 39
Registered: January 2006

Member

I checked both the initprod and the initstandy.ora files and it's not in either. What's the default?

Report message to a moderator

Re: Alter tablespace with dataguard [message #215210 is a reply to message #215203]

Fri, 19 January 2007 13:36

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Default is MANUAL.

Report message to a moderator

Previous Topic:	Standby DB1 node is up
Next Topic:	Skip Tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 06 11:24:05 CDT 2023