Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add a datafile to standby database.

user286179Aug 10 2011 — edited Aug 11 2011

Hi,

My database version is 11gR2 with ASM and 4 node cluster ( both primary and stand by). Though we set STANDBY_FILE_MANAGEMENT to auto , due to some ASM issue , newly added datafile was not added to stand by database.

Can someone suggest me a procedure , now to add the datafile to stand by database , after it was added to primary database.

I was reading the link http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/manage_ps.htm ( section 8.4.1.2 Adding a Tablespace and a Datafile When STANDBY_FILE_MANAGEMENT Is Set to MANUAL). This is for new tablespace addition). But i need just for datafile.

Can someone suggeste me the procedure.

Thanks
Naveen

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2011

Added on Aug 10 2011

#data-guard, #performance-availability

2 comments

1,944 views