How To Enable Archive Logging In RAC Environment [ID 1186764.1]

最新推荐文章于 2020-08-07 10:57:35 发布

czmmiao

最新推荐文章于 2020-08-07 10:57:35 发布

阅读量157

点赞数

分类专栏： RAC/DG/OGG 文章标签：数据库

本文链接：https://blog.csdn.net/czmmiao/article/details/84662545

版权

RAC/DG/OGG 专栏收录该内容

64 篇文章 0 订阅

订阅专栏

How To Enable Archive Logging In RAC Environment [ID 1186764.1]
修改时间:2011-6-2类型:HOWTO状态:PUBLISHED优先级:3注释 (0)
In this Document
  Goal
  Solution
  References

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2 - Release: 10.1 to 11.2
Information in this document applies to any platform.
Goal
How to enable database archivelog in RAC configuration?

Solution
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 <db_unique_name>

-- startup database in mount mode
$ srvctl start database -d <db_unique_name> -o mount

-- enable archvive logging
$ sqlplus / as sysdba
sql> alter database archivelog;
sql> exit;

-- stop database
$ srvctl stop database -d <db_unique_name>

-- restart all database instances
$ srvctl start database -d <db_unique_name>

-- verify archiving is enabled 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).

To disable archive logging, follow the same steps but use the NOARCHIVELOG 
clause of the ALTER DATABASE statement.--这儿如果从归档切换回非归档，按照同样的步骤设置为NOARCHIVELOG即可

References

NOTE:235158.1 - How To Enable/Disable Archive Log Mode in Real Application Cluster Environment
NOTE:274302.1 - ARCHIVELOG mode in Oracle 10g and 11g