当前位置:首页 > 开发 > 数据库 > 正文

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

发表于: 2014-10-12   作者:czmmiao   来源:转载   浏览次数:
摘要: 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: Oracl
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

 

参考至:http://blog.csdn.net/dbcommando/article/details/7925861

如有错误,欢迎指正

邮箱:czmcj@163.com

 

 

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

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

编辑推荐
In this Document Goal Solution <p style="line-height: 13pt; margin: 3.55pt 514.75pt 0pt 10
Most of the time, hardware virtualization technology extensions should be enabled in motherbo
A common tough scenario is the application crash/hang in production environment. Production e
http://msdn.microsoft.com/en-us/library/ff798328.aspx How to: Enable ECMA Client Object Model
This weekend, I deleted Windows Vista and installed Windows Server 2008 x64 on my home machin
In Windows Vista and later, if you press <SHIFT> key and right-click on any folder, you
In Windows Vista and later, if you press <SHIFT> key and right-click on any folder, you
While Cocos2D is compatible with ARC, simply enabling ARC in the project’s Build Setting wil
提供有关当前环境和平台的信息以及操作它们的方法。 此类不能被继承。 using System; using System.
一. ASM Fast Disk Resync Overview 1) When we take a disk offline in case the disk is corrupte
版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号