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

This article introduces the relevant knowledge of "what daily maintenance does standby database have". In the operation of actual cases, many people will encounter such a dilemma. Then let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Stop Standby

Select process, status from vastly managed standby;-- check whether the repository is in the application log for recovery

Alter database recover managed standby database cancel

Shutdown immediate

two。 Switch to read-only mode

-switch from shutdown mode to read-only mode

Startup nomount

Alter database mount standby database

Alter database open read only

-switch from application log mode to read-only mode-

Alter database recover managed standby database cancel;-cancel log application

Alter database open read only

3. Switch back to the managed recovery model

Startup nomount

Alter database mount standby database

Alter database recover managed standby database disconnect from session;-start the log application

Alter database recover managed standby database using current logfile disconnect from session

4. Switch roles between main library and standby database

4.1 switch from main library to standby library

Alter database commit to switchover to physical standby

When the alter database commit to switchover to physical standby with session shutdown;-- main library has a session connection

Shutdown immediate

Startup nomount

Alter database mount standby database

Alter database recover managed standby database disconnect from session

4.2 switch from library to main library

Alter database commit to switchover to primary

Shutdown immediate

Startup

Alter system switch logfile

5. The standby database automatically uses the logs sent from the main database for recovery.

Alter database recover automatic standby database

6. Change the protection mode

Alter database set standby database to maximize protection

Alter database set standby database to maximize availability

Alter database set standby database to maximize performancen

7. Cancel the automatic recovery model

Alter database recover managed standby database cancel

Alter database recover managed standby database finish

Alter database recover managed standby database finish force

This is the end of the content of "what is the daily maintenance of standby database"? thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.