how to changing the RAC 10g Database Archiving Mode-优快云博客

本文介绍如何将RAC10g数据库从非归档模式切换到归档模式，包括设置归档位置参数、关闭并挂载数据库、启用归档模式等步骤。同时解答了关于归档格式参数设置及是否只需挂载一个实例的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

=== ODM Answer ===

Que:
how to changing the RAC 10g Database Archiving Mode?

Ans:
The following steps need to be taken to enable archive logging in a RAC database environment:

--1. set your log_archive_dest1 parameters to a shared location
SQL> conn / as sysdba
SQL> alter system set log_archive_dest_1='location=<ASM_DISKGROUP_NAME>' ;

--2. shutdown immediate all database instances
$ srvctl stop database -d <db_unique_name>

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

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

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

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

--7. verify archiving is enabled by means of:
sql> archive log list;

=== ODM Answer ===

There's two questions:
1.Needn't set the parameter LOG_ARCHIVE_FORMAT?
==>LOG_ARCHIVE_FORMAT has the default value, so we need not set it, but if you want to change the archived log format, you can set this init parameter.

2.In the third step,is it just start mount one instance?
==>yes, change database to archivelog mode, which need in the mount status. This is the same with standalone database.