ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-16072: a minimum of one standby database destination is required

ORA-16072: a minimum of one standby database destination is required

原创 Linux操作系统 作者:ginni_hua 时间:2013-07-18 10:49:39 0 删除 编辑

修改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>

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7836221/viewspace-766599/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-03-20

  • 博文量
    172
  • 访问量
    361645