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

DGfailover operation .txt

Reserve database operation

Since it is failover, it is understood that the main library can no longer be used properly at this time. Just switch to pridb for the backup library.

1. Stop MRP (turn off active application)

Alter database recover managed standby database cancel

two。 Confirm that the standby library is ready to switch to the main library.

Set lines 200

Select database_role,db_unique_name,open_mode,protection_mode,protection_level,switchover_status from v$database

The query results are ready for to primary or sessions active to indicate that the repository is ready. If the query result is not these two values, confirm whether the log application of the slave database is still active.

3. Restart and start MRP to complete the redo application (manual application). If there is a gap,finish, it will fail. At the end of execution, the protection mode becomes maximum performance

-- prepare the database and stop the redo apply

Alter database recover managed standby database finish

-- the standby database forcibly stops the redo apply

Alter database recover managed standby database finish force

If the above sql execution fails, you can directly execute the following sql

Alter database activate physical standby database

But this may result in some data loss. After executing the above sql statement, skip to step 5 to open the database.

4. Convert standbydb to primary db

Alter database commit to switchover to primary with session shutdown

5. Open the new main library

Alter database open

Note: if you previously opened it as read-only, you must restart the database instance

Shutdown immediate

Startup

=

PS:failover will break the dataguard mode and need to reconfigure dataguard

Alter database register physical logfile 'filespec1'

Https://blog.csdn.net/zhengwei125/article/details/50675720

Http://blog.itpub.net/26506993/viewspace-1850722/

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.