ORA-16072: a minimum of one standby database destination is required
来源:互联网 发布:ps3 淘宝 编辑:程序博客网 时间:2024/04/30 16:19
看看当前保护模式
SQL> select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL standby maximize protection maximize protection
切换成maximize availability也需要类似的步骤,不再演示。
注:在10gR2的data guard中,按照上述步骤切换保护模式的时候却不成功。主库完成切换语句后再open就报错:ORA-03113: end-of-file on communication channel。
看alert文件,报错ORA-16072: a minimum of one standby database destination is required。但实际上备库的standby logfile都已经建好了,解决方法如下:
解决方法:
将主备库的flashback打开:
启动到mount
SQL> select FLASHBACK_ON from v$database;
FLASHBACK_ON
------------------------------------
NO
SQL> alter database flashback on;
数据库已更改。
然后再切换到最大可用或者最大保护模式就ok了,切换前注意备库已经处于mount状态,并且主库原有的归档日志都已经全部复制到备库对应的归档目录下了,否则传送方式由arch改成lgwr后这些差异日志就无法自动传过去了。
***************
将主库切换到maximize availability正常open,但是如果切换到Maximum protection就直接报错ORA-03113: end-of-file on communication channel,检查归档日志主备库都已经同步了,FLASHBACK_ON也已经是yes,但是就是不能open主数据库。
IXDBA.NET技术社区
后来查看资料发现 Maximum protection模式必须满足以下条件
Redo Archival Process: LGWR
Network Tranmission mode: SYNC
Disk Write Option: AFFIRM
Standby Redo Logs: Yes
standby database type: Physical Only
但是我的主库参数设置为:
*.LOG_ARCHIVE_DEST_2= 'SERVICE=STANDBY VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY LGWR SYNC REOPEN=10'
缺少了AFFIRM参数:增加后,如下
*.LOG_ARCHIVE_DEST_2= 'SERVICE=STANDBY VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY LGWR SYNC AFFIRM REOPEN=10'
这样,切换到Maximum protection就ok了。
在最大保护模式下,直接关闭备库是不行的,如果在备库上关闭数据库,会有如下提示:
SQL> shutdown immediate
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
SQL>
看来在最大保护模式下,备库是不允许关闭的,此时首先关闭主库,然后备库就可以顺利关闭了。
- ORA-16072: a minimum of one standby database destination is required
- ORA-16072: a minimum of one standby database destination is required
- ORA-16072: a minimum of one standby database destination is required
- ORA-16072: a minimum of one standby database destination is required
- ORA-16003: standby database is restricted to read-only access
- Database '' is in warm standby. A warm-standby database is read-only.
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- iPhone/iPod Touch: application executable is missing a required architecture. At least one of the fo
- Client instance is standby database instead of primary
- Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)
- ORA-01103: database name 'test' in control file is not 'standby'
- ORA-16047: DGID mismatch between destination setting and standby
- ORA-16047: DGID mismatch between destination setting and standby
- ORA-16146: STANDBY DESTINATION C…
- ORA-10458: standby database requires recovery
- ORA-10458: standby database requires recovery
- ORA-10458: standby database requires recovery
- eclipse调试全解
- 关于Android的ListView的Item选中
- getopt的使用
- PCB元件封装库命名规则简介
- 关于for语句
- ORA-16072: a minimum of one standby database destination is required
- 查询与删除重复记录的方法
- C#.Net Socket网络通讯编程
- 单片机unsigned char code/unsigned char idata变量
- 从头学习Drupal--基本概念
- 不知CSDN怎么搞的,别人编辑的文章恢复到我这里来了
- zoj 2704 Brackets
- Android系统简单研究后的缺陷总结
- SamSun R508 Geforce9200 GM for Windows2003驱动程序安装方法