Oracle 的生産庫都是啟動在歸檔模式下,RAC下歸檔非歸檔的切換和單執行個體也是一樣的,都是在MOUNT模式下執行ALTER DATABASE ARCHIVELOG/NOARCHIVELOG;指令。 不同的是:RAC環境下所有執行個體都必須處于非OPEN狀态,然後在任意一個處于MOUNT狀态的執行個體執行ALTER DATABASE指令,操作成功後,再正常啟動其它執行個體即可。
注意:RAC資料庫由于擁有多個執行個體,要注意每個執行個體相關初始化參數:LOG_ARCHIVE_DEST_n的設定,務必需要確定該參數設定的路徑合法有效,歸檔也能順利進行。
切換示例:
[oracle@raw1 dbs]$ export ORACLE_SID=raw1
[oracle@raw1 dbs]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 19 16:17:43 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 21
Current log sequence 22
SQL>
SQL> select inst_id,instance_name,version,archiver,status from gv$instance;
INST_ID INSTANCE_NAME VERSION ARCHIVE STATUS
---------- ---------------- ----------------- -------------- ------------
1 raw1 10.2.0.1.0 STOPPED OPEN
2 raw2 10.2.0.1.0 STOPPED OPEN
修改歸檔的預設路徑:
SQL> alter system set log_archive_dest_1='location=/u01/raw1arch' sid='raw1';
System altered.
SQL> alter system set log_archive_dest_1='location=/u01/raw2arch' sid='raw2';
SQL> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string location=/u01/raw2arch
... ....
log_archive_dest_state_1 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
切換歸檔模式:
注意事項: 所有節點都必須處于mount狀态。 在其中一個節點修改模式,然後在其他節點正常啟動即可。
SQL> startup mount;
ORACLE instance started.
Total System Global Area 184549376 bytes
Fixed Size 1218412 bytes
Variable Size 113248404 bytes
Database Buffers 67108864 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/raw2arch
Oldest online log sequence 14
Next log sequence to archive 15
Current log sequence 15
啟動另一個節點,檢視狀态:
Archive destination /u01/raw1arch
Oldest online log sequence 21
Next log sequence to archive 22
至此,現在RAC 已經切換到歸檔模式了。
二. 切換成非歸檔
在一台主機上執行:
SQL>ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
在兩台主機上執行:
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database noarchivelog;
SQL>ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE;
SQL>STARTUP
轉:http://blog.csdn.net/tianlesoftware/article/details/5501184
本文轉自 張沖andy 部落格園部落格,原文連結: http://www.cnblogs.com/andy6/p/5766716.html ,如需轉載請自行聯系原作者