oracle 11g rac開啟歸檔日誌和閃回

標籤：oracle 11g rac開啟歸檔日誌和閃回

1.查看資料庫是否開啟閃回(查看兩個節點rac1和rac2是否開歸檔日誌)

SQL> archiveloglist

SP2-0734: unknown command beginning "archivelog..." - rest of line ignored.

SQL> archive log list

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     7

Current log sequence           8

SQL> 

2.在節點1(rac1)中設定只修改節點1的參數,不影響節點2.

SQL> alter system set cluster_database=false scope=spfile sid=‘racdb1‘;

System altered.

SQL> 

3.用srvctl命令關閉資料庫

[[email protected] ~]$ srvctl stop database -d racdb

本文出自 “一起走過的日子” 部落格，請務必保留此出處http://tongcheng.blog.51cto.com/6214144/1857477

oracle 11g rac開啟歸檔日誌和閃回