Shulou(Shulou.com)05/31 Report--

What this article shares to you is about the basic operating sentences of Oracle Dataguard, which the editor thinks is very practical, so I share it with you to learn. I hope you can get something after reading this article.

# # start the slave database

STARTUP MOUNT

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION

Or, if you use real-time synchronization, run the following

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE

# # closing slave database operation

Check to see if redo data is being applied, if there is a MRP0 or MRP

SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY

Close redo apply

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

Close the standby library

SHUTDOWN IMMEDIATE

# # status query

Main library:

Dynamic performance View:

V$archive_dest_status

The RECOVERY_MODE column indicates whether it is real-time Redo Data synchronization.

# # start synchronization

Front Desk

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE

Backstage

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT

Real time

LTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE

# # stop synchronization

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

# # Monitoring Redo synchronization

The main library or standby library is running

SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE,PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE

View fast-start failover

SELECT FS_FAILOVER_STATUS FSFO_STATUS, FS_FAILOVER_CURRENT_TARGET TARGET_STANDBY, FS_FAILOVER_THRESHOLD THRESHOLD, FS_FAILOVER_OBSERVER_PRESENT OBS_PRES FROM V$DATABASE

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.