Switch Switchover using the Broker-role in the replicuard Environment

[OracleDataGuard] use the Broker-role conversion Switchover in the DataGuard environment. 1. Environment Introduction: DataGuard environment: Primary database: oracle10.2.

[Oracle transaction uard] Using Broker-role conversion in the transaction uard environment Switchover I. Environment Introduction Data Guard environment: Primary database: oracle10.2.

[Oracle trusted uard] switch Switchover using the Broker-role in a trusted uard Environment

I. Environment Introduction

Data Guard environment:

Primary Database: oracle10.2.0.5.0
OS: RedHat 4.4
Host Name: source
IP Address: 192.168.10.101
Database SID: source
DB_UNIQUE_NAME: source_pr

Standby Database: oracle10.2.0.5.0
OS: redhat 4.4
Host Name: target
IP Address: 192.168.10.102
Database SID: source
DB_UNIQUE_NAME: source_st


Ii. Restart uard


Note the Data Guard startup sequence:

Startup sequence: First standby, then primary;
Close sequence: first primary and then standby;

Start the instance to the mount status in the slave database:
SQL> startup nomount;
SQL> alter database mount standby database;
SQL> alter database recover managed standby database disconnect from session;
To cancel Restoration: alter database recover managed standby database cancel;

Start the listener in the slave database:
$ Lsnrctl start

Start the instance in the master database:
SQL> startup;

Start the listener in the master database:
$ Lsnrctl start

Verify whether the archive directory is valid in the master database:

SQL> select dest_name, status, error from v $ archive_dest;

If any error occurs, check the cause.

SQL> alter system switch logfile;
SQL> select max (sequence #) from v $ archived_log;

View database Modes
SQL> select dest_name, status, database_mode, recovery_mode, protection_mode from v $ archive_dest_status;
SQL> select status, database_mode from v $ archive_dest_status;
SQL> select OPEN_MODE, PROTECTION_MODE, ACTIVATION #, DATABASE_ROLE, SWITCHOVER #, SWITCHOVER_STATUS from v $ database;

,