DataGuard常规操作命令

1、关闭DataGuard顺序

(1)、取消备库开始应用日志

SQL> alter database recover managed standby database cancel;

Database altered.

(2)、关闭备库

shutdown immediate;

(3)、关闭主库

shutdown immediate;

2、开启DataGuard顺序

最大性能模式:先开启主库还是先开启备库,是没有关系的;

最大可用模式:先开启备库再开启主库,如果启动顺序相反,主库仍然能启动,但会在主库的alert.log文件中出现错误警告信息;

...
LGWR: Error 1034 verifying archivelog destination LOG_ARCHIVE_DEST_2 LGWR: Continuing... Tue Jan 23 09:36:29 2007 Errors in file /opt/oracle/admin/devdb/bdump/test_lgwr_30979.trc: ORA-01034: ORACLE not available LGWR: Error 1034 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'test_stb_186'
...

最大保护模式:先启动备库,再启动主库,如果顺序相反,主库实例会自动中断,数据库无法启动,并会在alert.log文件中留下如下信息.

...
LGWR: Error 1034 verifying archivelog destination LOG_ARCHIVE_DEST_2
LGWR: Continuing...
Tue Jan 23 09:34:03 2007
Errors in file /opt/oracle/admin/devdb/bdump/test_lgwr_30812.trc:
ORA-01034: ORACLE not available
LGWR: Error 1034 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'test_stb_186'
LGWR: Minimum of 1 applicable standby database required
Tue Jan 23 09:34:07 2007
Errors in file /opt/oracle/admin/devdb/bdump/test_lgwr_30812.trc:
ORA-16072: a minimum of one standby database destination is required
LGWR: terminating instance due to error 16072
Instance terminated by LGWR, pid = 30812
...

综上所述,在启动顺序上,DataGuard中主、备库最好都遵从先开启备库,再开启主库的原则;

开启步骤:

  ->开启备库监听

  ->开启备库

  ->开启主库监听

  ->开启主库

3、查看主库与备库的保护模式

主库:

SQL> select name,database_role,protection_mode from v$database;

NAME      DATABASE_ROLE    PROTECTION_MODE
--------- ---------------- --------------------
ORCL      PRIMARY          MAXIMUM PERFORMANCE

备库: 

SQL> select name,database_role,protection_mode from v$database;

NAME      DATABASE_ROLE    PROTECTION_MODE
--------- ---------------- --------------------
ORCL      PHYSICAL STANDBY MAXIMUM PERFORMANCE

 参考文章

原文地址:https://www.cnblogs.com/arcer/p/3584470.html