10g dataguard creating standby controlfile.
edited Jul 17, 2009 12:57AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered
When I read the manul, it says the standby controlfile creating is like below.
SQL>STARTUP MOUNT;
SQL>ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/stdby.ctl';
SQL>ALTER DATABASE OPEN;
My question is do I have to create a standby controlfile when the db is in mount mode? if the db is opened, will standby controlfile work?
Also, the other question is related to above.
If db is opened, then I will be able to create standby without shuttting down primary db, is there a procedure for doing that?
Thanks
0