Home » Server Options » Data Guard » switchover from physical standby to primary fails (Oracle 9.2.0.1.0, windows)
switchover from physical standby to primary fails [message #454985] Sun, 09 May 2010 06:22 Go to next message
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

Re: switchover from physical standby to primary fails [message #454987 is a reply to message #454985] Sun, 09 May 2010 07:41 Go to previous message
Michel Cadot
Messages: 67137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Search in alert.log ans trace files fr information.

Regards
Michel
Previous Topic: [Logical Standby] Which table/SQL caused paging-out
Next Topic: VALID_FOR in Dataguard
Goto Forum:
  


Current Time: Sat May 30 11:23:02 CDT 2020