How to realize the switch of ORACLE DataGuard standby mode

This article introduces you how to achieve ORACLE DataGuard standby mode switching, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Prepare the library mode classification:

1. Automatic management mode

two。 Manual management mode (can do data file addition and renaming operations)

3. Read-only mode

View the current mode of the slave database:

Select * from dba_ojbects

If you can view: in read-only mode

If you can't view it: for administrative mode

To switch from administrative mode to read-only mode:

Alter database recover managed standby database cancel

Alter database open read only

To switch from read-only mode to administrative mode:

Alter database recover managed standby database disconnect from session

Administrative mode view:

Show parameter standby_file_management

AUTO: automatic

MANUAL: manual

Toggle:

Alter system set standby_file_management='MANAUAL'

Alter system set standby_file_management='AUTO'

On how to achieve ORACLE DataGuard standby mode switch to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.