ホームページ >データベース >mysql チュートリアル >Oracle 11g Dataguard错误ORA-02097:ORA-16053:
Oracle 11g Dataguard错误ORA-02097:ORA-16053:
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBオリジナル
- 2016-06-07 17:03:522189ブラウズ
这是因为刚执行的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.
