drop datafile in dataguard
edited May 3, 2012 3:55PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hi,
Oracle 10.2.0.4
I have dataguard configuration with standby file management auto.
When I add a datafile, it is automatically added to standby database.
However,when I drop a datafile, it is dropped from primary database but it is not dropped from the standby database..
What is the reason for this?.
alter tablespace users drop datafile '/oracle/orclprod/users02.dbf' ;
and then force couple of log switch.
0