In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.