Data Guard switchover Pre & Post Steps

Written by

dbapranjan

in

Pre-Steps for Data Guard Switchover:

Verify Managed Recovery: Ensure that Managed Recovery is running on the standby database. This ensures that the standby database is synchronized with the primary database.

Show lag for Data Guard configuration

DGMGRL> show configuration lag;

Show configuration for database role change
[This will be useful with multiple standby databases]

DGMGRL> show configuration when primary is TEST_SBY;

Validate database spfile (don’t use OS authentication)

DGMGRL> connect sys
Password:
Connected to "TEST_SBY"
Connected as SYSDBA.

DGMGRL>  validate database verbose TEST_SBY spfile;

Validate DGConnectIdentifier

DGMGRL> connect sys
Password:
Connected to "TEST_SBY"
Connected as SYSDBA.

VALIDATE DGConnectIdentifier <connect identfier>;

VALIDATE DGConnectIdentifier TEST;
VALIDATE DGConnectIdentifier TEST_SBY;

Validate static connect identifier

Confirm SPFILE Usage: Verify that the primary and standby databases are using the SPFILE (Server Parameter File). This ensures that the database configurations are consistent.

DGMGRL> connect sys
Password:
Connected to "TEST_SBY"
Connected as SYSDBA.

DGMGRL> validate static connect identifier for all;

Validate network configuration

DGMGRL> connect sys
Password:
Connected to "TEST_SBY"
Connected as SYSDBA.

DGMGRL> validate network configuration for all;

Validate Primary and Standby databases

DGMGRL> connect sys
Password:
Connected to "TEST_SBY"
Connected as SYSDBA.

DGMGRL> validate database "TEST"
DGMGRL> validate database "TEST_SBY"

Switchover Steps:

Connect to DGMGRL: Start the Data Guard Broker Command-Line Interface (DGMGRL) and connect to the primary database. Use the DGMGRL command to initiate the switchover process.

Perform Switchover

DGMGRL> connect sys
Password:
Connected to "TEST_SBY"
Connected as SYSDBA.

DGMGRL> SWITCHOVER TO "TEST_SBY"

Initiate Switchover: Use the DGMGRL command to initiate the switchover process. This command will change the roles between the primary and standby databases.

Monitor Switchover Progress: Monitor the switchover progress using DGMGRL or other monitoring tools. This allows you to track the status of the switchover and ensure that it completes successfully.

Post-Steps for Data Guard Switchover:

Verify Switchover Completion: Confirm that the switchover process has completed successfully. Use the v$database view to check the new database roles.

DGMGRL> show configuration lag
DGMGRL> show configuration

After Switchback check BCT

set lines 300
col STATUS for a10
col FILENAME for a80
select * from v$block_change_tracking;

More posts