ORACLE RAC 设置归档

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

请使用浏览器的分享功能分享到微信等