Adding datafiles in dataguard environment
Ken INov 17 2012 — edited Nov 17 2012Hi 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