In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >
Share
Shulou(Shulou.com)06/03 Report--
How To Enable/Disable Archive Logging In RAC Environment for 10.2 and higher version (document ID 1186764.1)
APPLIES TO:Oracle Database-Enterprise Edition-Version 10.2.0.1 and later
Information in this document applies to any platform.
GOAL
How to enable/disable database archivelog in RAC configuration?
SOLUTION
1. The following steps need to be taken to enable archive logging in a RAC database environment:
-- shutdown immediate all database instances
$srvctl stop database-d
-- startup database in mount mode
$srvctl start database-d-o mount
-- enable archive logging
$sqlplus / as sysdba
Sql > alter database archivelog
Sql > exit
-- stop database
$srvctl stop database-d
-- restart all database instances
$srvctl start database-d
-- verify archiving is enabled/disabled by means of:
Sql > archive log list
You might need to set your log_archive_dest (_ n) parameters to a shared location in each spfile, but the log_archive_start parameter does not need to be set anymore as of 10g (see Note 274302.1).
2. To disable archive logging, follow the same steps but use the NOARCHIVELOG clause of the ALTER DATABASE statement.
Please note, from 10.2 onwards, it is no longer required to modify cluster_database parameter to change archive log mode. Please refer to
Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide
What's New in Oracle Real Application Clusters Administration and Deployment?
"Changing the Archiving Mode
You no longer need to modify the CLUSTER_DATABASE parameter setting to change the archiving mode in Oracle RAC. You can change archive log mode as long as the database is mounted in the local instance and not open in any instances. "
REFERENCESNOTE:274302.1-ARCHIVELOG mode in Oracle 10g and 11g
NOTE:235158.1-How To Enable/Disable Archive Log Mode in Real Application Cluster Environment
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.