Dataguard启停顺序
来源:互联网 发布:php empty和! 编辑:程序博客网 时间:2024/04/30 13:00
针对data guard采用不同的模式,主备库的启动顺序如下:
maxperformance(最大性能):主库,备库的启动和关闭顺序没有先后
max availability(最大可用):要先启动备库,再启动主库,如果启动顺序相反,主库仍然能启动,但会在主库的alert.log文件中出现如下出错提示:
Tue Jan 23 09:36:26 2007
alter database open
Tue Jan 23 09:36:26 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
LGWR: Primary database is in MAXIMUM AVAILABILITY mode
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
LNS0 started with pid=12
Tue Jan 23 09:36:29 2007
LGWR: Error 1034 verifying archivelogdestination 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_2standby host 'test_stb_186'
Thread 1 advanced to logsequence 73
Thread 1 opened at log sequence 73
Successful open of redo thread 1
Tue Jan 23 09:36:33 2007
ARC0: Evaluating archive
ARC0: Beginning to archive log 1 thread 1 sequence 72
Creating archive destination LOG_ARCHIVE_DEST_1:'/archive_log/archive/1_72.arc'
Tue Jan 23 09:36:33 2007
ARC1: Evaluating archive
ARC1: Unable to archive log 1 thread 1 sequence 72
Tue Jan 23 09:36:33 2007
SMON: enabling cache recovery
Tue Jan 23 09:36:33 2007
ARC0: Completed archiving
Tue Jan 23 09:36:33 2007
Successfully onlined Undo Tablespace 1.
Tue Jan 23 09:36:33 2007
SMON: enabling tx recovery
Tue Jan 23 09:36:33 2007
Database Characterset is US7ASCII
replication_dependency_tracking turned off (no async multimasterreplication found)
Completed: alter database open
maxprotection(最大保护):先启动备库,再启动主库,如果顺序相反,主库实例会自动中断,数据库无法启动,并会在alert.log文件中留下如下的信息:
Tue Jan 23 09:34:00 2007
alter database open
Tue Jan 23 09:34:00 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
LGWR: Primary database is in MAXIMUM PROTECTION mode
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
LNS0 started with pid=12
Tue Jan 23 09:34:03 2007
LGWR:Error 1034 verifying archivelog destinationLOG_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_2standby 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 isrequired
LGWR: terminating instance due to error 16072
Instance terminated by LGWR, pid = 30812
- Dataguard启停顺序
- CDH启停顺序
- was起停顺序
- Dataguard实战(11):RHEL4.5 安装 Oracle10G Dataguard 多个备库 - 主备库的起停和维护
- IBM Message Broker(IBM ESB产品)启停代理、控制管理器、队列的顺序
- dataguard常用命令及DG主备库开关顺序
- RAC停启
- mysql 启停
- weblogic启停脚本
- nginx启停
- 启停主从复制
- 应用启停脚本
- mysql启停服务
- 安全启停datanode
- RHCS启停
- Dataguard 重启方法
- DataGuard
- dataguard
- Nginx使用LDAP认证
- 利用回收站功能恢复表
- 关于ZFS文件系统
- 扩展欧几里得算法
- 银行卡密码的加密、MAC计算
- Dataguard启停顺序
- WARNING: REMOTE HOST IDENTIFICAT…
- linux/solaris下增加swap分区(全)
- rsync命令
- 修改Memory_max_target为0出错
- Solaris 常见问题问答
- 光纤跳线相关知识
- Solaris资源监控命令
- URAL 2018 The Debut Album(DP)