ORA-16072: a minimum of one standby database destination is required
来源:互联网 发布:cc攻击的端口怎么防御 编辑:程序博客网 时间:2024/05/01 03:23
原文地址:http://blog.itpub.net/7836221/viewspace-766599/
修改DG參數:
SQL> alter system set log_archive_config='';
關閉資料庫後,重新啟動:
SQL> startup pfile='$ORACLE_HOME/dbs/hua.ora';
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022112 bytes
Variable Size 956302624 bytes
Database Buffers 1157627904 bytes
Redo Buffers 31531008 bytes
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
同時,檢查alert.log裡有以下錯誤:
Errors in file /u01/app/oracle/admin/icssfcdb/bdump/icssfcdb_lgwr_7882.trc:
ORA-16072: a minimum of one standby database destination is required
mount狀態下,檢查相關參數狀態:
[oracle@icssfcdb bdump]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 16 14:39:21 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount pfile='$ORACLE_HOME/dbs/hua.ora';
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022112 bytes
Variable Size 956302624 bytes
Database Buffers 1157627904 bytes
Redo Buffers 31531008 bytes
Database mounted.
SQL> select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY MAXIMUM AVAILABILITY UNPROTECTED
修改為maximize performance模式,然後啟動OK。
SQL> alter database set standby to maximize performance;
Database altered.
SQL> alter database open;
Database altered.
SQL> select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='$ORACLE_HOME/dbs/hua.ora';
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022112 bytes
Variable Size 956302624 bytes
Database Buffers 1157627904 bytes
Redo Buffers 31531008 bytes
Database mounted.
Database opened.
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开发第一个Servlet
- 获取文件中的所有文件的方法
- KOOCAN非正常电影排行榜之这个丧尸不太冷
- Java_代码执行ping命令
- 云客Drupal8源码分析之Session进阶
- ORA-16072: a minimum of one standby database destination is required
- BeanListHandler演示
- 解决PopupWindow遮住输入法
- 隐马尔科夫模型详解
- Cobertura 统计多模块maven项目测试覆盖率
- HTML第六章上机题5--------聚美优品彩妆热卖产品类表
- CSS 多类选择器
- OBS源码阅读笔记--将声音设置和场景挂钩
- makefile的使用