这是因为刚执行的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_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.