1.设置归档路径

方式1

alter system set log_archive_dest_1='location=/u03/archivelog' scope=spfile sid='node1'

alter system set log_archive_dest_1='location=/u03/archivelog' scope=spfile sid='node2'

方式ASM

alter system set db_recovery_file_dest='+dgrecover' scope=spfile;

alter system set db_recovery_file_dest_size =200g scope=spfile;

方式ocfs

alter system set log_archive_dest_1='location=/orac/arch' scope=spfile;

2.停止数据库：srvctl stop database -d dbname

3.在其中一个节点上面启动一个实例：startup mount, alter database archivelog,

4.查看更改：archive log list

5.封闭数据库：shutdown immediate

6,启动数据库：srvctl start database -d dbname

ITPub博客

ORACLE RAC 设置归档