Switchover standby Manually

Switchover Stimulation

On primary

1)To check error

select dest_name,status,error from v$archive_dest where dest_name='LOG_ARCHIVE_DEST_2';

2)Current status

select message from v$dataguard_status;

3)To switch to standby

SELECT PROGRAM, TYPE FROM V$SESSION WHERE TYPE=’USER’;

alter database commit to switchover to standby with session shutdown;

shut down immediate;

alter database mount standby database;

4)To verify

alter database recover managed standby database disconnect from session;

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE

--------- -------------------- ----------------

ORCL      MOUNTED              PHYSICAL STANDBY

SQL> show parameter db_unique

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_unique_name                       string      orcl

On stand by

1)to convert to primary

alter database commit to switchover to primary;

2)Bounce and open the database

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area  217157632 bytes

Fixed Size                  2211928 bytes

Variable Size             159387560 bytes

Database Buffers           50331648 bytes

Redo Buffers                5226496 bytes

Database mounted.

Database opened.

3)To verify

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE

--------- -------------------- ----------------

ORCL      READ WRITE           PRIMARY

SQL> show parameter db_unique

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_unique_name                       string      stby

Note:

If standby in dgmgrl showing error

Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

Then start the real time apply on standby.