Oracle11g Dataguard錯誤ORA-02097:ORA-16053:

mengzhaoliang發表於2010-12-28

在配置Dataguard時,執行命令發生下面的錯誤:
SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/flash_recovery_area/HYOMS/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=hyoms01';
alter system set log_archive_dest_1='location=/u01/app/oracle/flash_recovery_area/HYOMS/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=hyoms01'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16053: DB_UNIQUE_NAME hyoms01 is not in the Data Guard Configuration

這是因為剛執行的alter system set db_unique_name='hyoms01' scope=spfile;還沒有資料庫識別到
需要重新啟動資料庫可以解決。
SQL> select * from V$DATAGUARD_CONFIG ;

DB_UNIQUE_NAME
------------------------------
hyoms
hyoms01
hyoms02
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup

SQL> select * from V$DATAGUARD_CONFIG ;

DB_UNIQUE_NAME
------------------------------
hyoms01
hyoms02
SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/flash_recovery_area/HYOMS/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=hyoms01';
System altered.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12778571/viewspace-682706/,如需轉載,請註明出處,否則將追究法律責任。

相關文章