Skip to Main Content

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!

Adding datafiles in dataguard environment

Ken INov 17 2012 — edited Nov 17 2012
Hi gurus,

I have one doubt regarding adding data file to a table space which is in data guard environment.

My oracle database is install in oracle 10gR2 on 64bit windows server.I have one primary database and physical DR database.
I am going to add data file in primary database.All my data files reside in the directory ' C:/oradata/data file/$Month_Name'

Now to add new data file i have to create new directory under C:/oradata/data file/ named November and add data file in the November directory.

1. Will addition of new folder named November will automatically reflect in DR database also. or do i need to go to DR and add the same directory and then add the data file in primary database.

2.When i am adding data file to primary database,will it effect to DR database?Or the DR database will automatically sync?

Please provide me step by step procedure.

can anyone provide me steps to follow up,so that both primary and DR will be in sync?

Thanks,
Meena

Edited by: 949632 on Nov 16, 2012 10:46 PM

Edited by: 949632 on Nov 16, 2012 10:47 PM
This post has been answered by Shivananda Rao on Nov 17 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2012
Added on Nov 17 2012
8 comments
4,404 views