这是因为刚执行的alter system set db_unique_name=
在配置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_来源gaodai#ma#com搞@代~码$网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.
转载请注明原文链接：Oracle 11g Dataguard错误ORA-02097:ORA-16053:
