Home » Server Options » Data Guard » switchover controlfile issue
switchover controlfile issue [message #74514] Wed, 22 December 2004 20:40
ramya
Messages: 87
Registered: August 2002
Member
hi
In my primary database one datafile was offline.When i created thestandby controlfile and mounted the datbase it becomes online,why its comming online.

for testing i take the datafile in standby database using alter database datafile 92 offline drop;
then i shutdown the database and created one more standby controlfile and mounted the database.Again this datafile becomes online.Then i made it offline using above command and started recovery.
My dought is if i do the switchover(oracle will do these things in controlfile) whether this will give a problem if i switchover standby to primary and primary to standby(whether this file will be online
again).Both database the now the file is in offline status.

This file created somebody mistakenly in DRSYS tablespace(using for intermedia).Shall i move these data from this tablespace to another tablespace and shall i drop this tablespace.Is there any problems
because i want to avoid these complications and erorrs later
with regards
ramya
Previous Topic: failover
Next Topic: data guard manager
Goto Forum:
  


Current Time: Fri Mar 29 03:31:00 CDT 2024