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

ORACLE RAC 設定歸檔

相關文章