| switchover from physical standby to primary fails [message #454985] |
Sun, 09 May 2010 06:22  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
hi,
i have a db's in maximum protection mode and i am trying to perform a switchover of physical standby database to primary role. but it failed., the steps followed is as follows. everything is fine with old primary site and the it is now in mounted state. When I went through the log file, I got the error message as "ORA-16072: a minimum of one standby database destination is required". can any one pls help me how to get with it.
the standby_archive_dest is as follows.
old primary database
SQL> alter system switch logfile;
SQL> alter system archive log current;
old standby database
Disconnect the managed recovery mode in Standby database.
SQL> recover managed standby database cancel;
Media recovery complete.
SQL> recover standby database;
AUTO
SQL> exit
old primary database
SQL> show parameter standby_archive;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string %ORACLE_HOME%\RDBMS
old standby database
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string C:\Oracle9i\admin\standby1\arc
h\
standby_file_management string AUTO
old primary database
------------------------
SQL>select switchover_status from v$database;
SWITCHOVER_STATUS
------------------
SESSIONS ACTIVE
SQL>alter database commit to switchover to physical standby with session shutdown;
Database altered
SQL>shutdown immediate
SQL>startup nomount
SQL>alter database mount standby database;
SQL>alter system set log_archive_dest_state_2=defer;
old standby database
--------------
SQL>select switchover_status from v$database;
SWITCHOVER_STATUS
------------------
SESSIONS ACTIVE
SQL>alter database commit to switchover to primary with session shutdown;
SQL>shutdown immediate
SQL>startup
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
Database mounted.
ORA-03113: end-of-file on communication channel
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
