oracle dataguard. need ur help gurus
582525Sep 14 2007 — edited Sep 19 2007gurus,
i do :
select switchover_status from v$database;
result is : session active
then,
i do :
alter database commit to switchover to physical standby with session shutdown;
database altered
but when, i query
select switchover_status from v$database;
it's still session active
so, i shutdown immediate on primary database
but when i wanted to startup mount the primary database
i got an error,
SQL> startup mount;
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-01666: controlfile is for a standby database
and my primary db still in nomount state
Gurus, what should i do
regards
abip
Message was edited by:
abip