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!

Standby Database Datafiles

kirkladbAug 3 2012 — edited Aug 3 2012

Question: I have a primary and standby database. Right now all the datafiles on both primary and standby are in the same location, unfortunately space can only be added to my primary database. My question is, can you still maintain a standby database if the physical location of the datafiles are not on the same mount point? i.e.:

Primary datafile: /u01/app/oracle/user_data01.dbf --> Standby datafile: /u03/app/oracle/user_data01.dbf

I know I have to turn standby file management to MANUAL to make such a change but can I turn it back to AUTO once I have completed moving this file? Thanks guys

This post has been answered by damorgan on Aug 3 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2012

Added on Aug 3 2012

#data-guard, #performance-availability

4 comments

330 views