Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How 12C RAC+DG+Broker modifies the path of the archive log.

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

I. description of the environment

12C RAC + DATAGUARD+ Broker

2. Modify the path of archive log

The following is a simulated production environment, the method is the same.

-- main library RAC

1. For Oracle users, modify the parameter file of the main library first.

Sqlplus / as sysdbaalter system set log_archive_dest_1='LOCATION=+datadg/arch VALID_FOR= (ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'

2. Oracle user executes to modify broker configuration parameters

DGMGRL > edit instance orcl1 on database orcl set property StandbyArchiveLocation='+datadg/arch';DGMGRL > edit instance orcl2 on database orcl set property StandbyArchiveLocation='+datadg/arch'

-- prepare a single instance of the database

1. Oracle users, and then modify the repository

Sqlplus / as sysdbaalter system set log_archive_dest_1='LOCATION=++datadg/arch VALID_FOR= (ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcldg'

2. Oracle user executes to modify broker configuration parameters

DGMGRL > edit database orcldg set property StandbyArchiveLocation='+datadg/arch'

Third, the error report encountered

Error 1:OERR: ORA-16582 "cannot change instance-specific property" (varies by version) Reference Note (document ID 172958.1) Error Text, Cause and Action from Message File/s for ORA-16582Versions 11.1,11.2, 12.1Error: ORA-16582 cannot change instance-specific property Cause: An attempt was made to change an instance-specific property for a database that had more than one instance. Action: Retry the command and identify a specific instance whose property value is to be changed. Solution: modify the archive path in RAC environment using edit instance xxx. Do not use edit database to report error 2: Warning: ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting Warning: ORA-16714: the value of property AlternateLocation is inconsistent with the database setting solution: modify the broker configuration at the same time.

4. Summary:

1. In an environment like RAC+DG+Broker, you need to note that some parameters need to be modified in the database as well as in broker.

2. it doesn't matter if we encounter problems, we can't encounter all kinds of problems, the key is to cultivate our own ability to solve problems.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report