ORA-16698

admin

19.12,在配置dg broker得时候报错ORA-16698

1. [oracle@vm2 ~]$ dgmgrl
   
2. DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Aug 9 21:39:32 2021
   
3. Version 19.12.0.0.0
   
4. 
   
5. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. Welcome to DGMGRL, type "help" for information.
   
8. DGMGRL> sys@ora19
   
9. Unrecognized command "sys", try "help"
   
10. DGMGRL> connect sys@ora19
    
11. Password:
    
12. Connected to "ora19"
    
13. Connected as SYSDBA.
    
14. DGMGRL> create configuration 'dgcfg' as primary database is ora19 connect identifier is ora19;
    
15. Configuration "dgcfg" created with primary database "ora19"
    
16. DGMGRL> add database ora19b as connect identifier is ora19b maintained as physical;   
    
17. Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
    
18. 
    
19. Failed.
    

复制代码

1. [oracle@vm1 ~]$ oerr ora 16698
   
2. 16698, 00000, "member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set"
   
3. // *Cause:  One or more LOG_ARCHIVE_DEST_n initialization parameters that
   
4. //          contain a SERVICE attribute for another member in the
   
5. //          configuration were set on the new member when attempting to add a
   
6. //          standby database or far sync instance to the configuration.
   
7. // *Action: Clear all LOG_ARCHIVE_DEST_n initialization parameters that
   
8. //          contain a SERVICE attribute for another member in the configuration
   
9. //          on the new member to be added.
   

复制代码

主备库都置空log_archive_dest_n参数，重启实例

1. SYS@ora19> alter system reset log_archive_dest_1;
   
2. 
   
3. System altered.
   
4. 
   
5. SYS@ora19> alter system reset log_archive_dest_2;
   
6. 
   
7. System altered.
   
8. 
   
9. SYS@ora19> shutdown immediate
   
10. Database closed.
    
11. Database dismounted.
    
12. ORACLE instance shut down.
    
13. SYS@ora19> startup
    
14. ORACLE instance started.
    

复制代码

配置成功

1. [oracle@vm2 ~]$ dgmgrl
   
2. DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Aug 9 21:52:41 2021
   
3. Version 19.12.0.0.0
   
4. 
   
5. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. Welcome to DGMGRL, type "help" for information.
   
8. DGMGRL> connect sys@ora19
   
9. Password:
   
10. Connected to "ora19"
    
11. Connected as SYSDBA.
    
12. DGMGRL> create configuration 'dgcfg' as primary database is ora19 connect identifier is ora19;
    
13. Error: ORA-16504: The Oracle Data Guard broker configuration already exists.
    
14. 
    
15. Failed.
    
16. DGMGRL> add database ora19b as connect identifier is ora19b maintained as physical;
    
17. Database "ora19b" added
    

复制代码