Shulou(Shulou.com)06/01 Report--

1. State detection before handover

[total] the main database queries whether the standby database has been synchronized.

SELECT DB_UNIQUE_NAME, PROTECTION_MODE, SYNCHRONIZATION_STATUS, SYNCHRONIZED FROM V$ARCHIVE_DEST_STATUS

Check that the data has been transmitted in place

SELECT CLIENT_PROCESS, PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY

Check the SEQUENCE#, of the LGWR line, and then on the main library, run

SELECT THREAD#, SEQUENCE#, STATUS FROM V$LOG

Check to see if the corresponding SEQUENCE#, is consistent with the repository.

Check whether the data has been applied to the standby database

SELECT CLIENT_PROCESS, PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY

Check the MPR0 line. If it is not APPLYING_LOG, it indicates that there is a problem and it is not suitable to switch.

Total, score, score means, check the total first, if the status of the total check is not good, then check to see if there are any running jobs, RMAN backups, etc., if so, stop. two。 Switching operation

Open alert log for monitoring

RAC and so on are reduced to one instance.

View database switching status

SELECT SWITCHOVER_STATUS FROM V$DATABASE

If the status is TO STANDBY, it means that you can switch.

View the current session of the database

SELECT PROGRAM, TYPE FROM V$SESSION WHERE TYPE='USER'

Perform handover

ALTER DATABASE COMMIT TO SWTICHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN

Open the main library

ALTER DATABASE OPEN

Restart and synchronize on the standby library

SHUTDOWN IMMEDIATE

STARTUP MOUNT

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.