從Oracle 10gR2開(kāi)始,對(duì)于RAC數(shù)據(jù)庫(kù)設(shè)置歸檔模式非常方便,只需要在其中任何一個(gè)節(jié)點(diǎn)上操作,剩余節(jié)點(diǎn)instance關(guān)閉即可,下面是一個(gè)Oracle 10.2.0.2
版本2個(gè)節(jié)點(diǎn)的RAC數(shù)據(jù)庫(kù)打開(kāi)歸檔模式的示例,歸檔存放在FRA磁盤(pán)組下的demo目錄下
第一步:規(guī)劃目錄
實(shí)例1的歸檔路徑：+FRA/demo/arch1
實(shí)例2的歸檔路徑：+FRA/demo/arch2
[oracle@rac02] /home/oracle> export ORACLE_SID=+ASM2
[oracle@rac02] /home/oracle> asmcmd
ASMCMD> ls
DATA/
FRA/
ASMCMD> cd FRA
ASMCMD> mkdir demo
ASMCMD> cd demo
ASMCMD> mkdir arch1 arch2
ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
N arch1/
N arch2/
ASMCMD>
第二步：關(guān)閉實(shí)例2
[oracle@rac02] /home/oracle> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Oct 9 18:07:16 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
在節(jié)點(diǎn)1上確認(rèn)實(shí)例2已經(jīng)關(guān)閉
[oracle@rac01] /home/oracle> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.demo.db application ONLINE ONLINE rac02
ora....o1.inst application ONLINE ONLINE rac01
ora....o2.inst application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02
第三步：設(shè)置歸檔參數(shù)
在實(shí)例1上操作即可
[oracle@rac01] /home/oracle> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Oct 9 18:07:51 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> show parameter cluster_database
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string demo1
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 3
Current log sequence 4
SQL> alter system set log_archive_dest_1='LOCATION=+FRA/demo/arch1' sid='demo1';
System altered.
SQL> alter system set log_archive_dest_1='LOCATION=+FRA/demo/arch2' sid='demo2';
System altered.
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=+FRA/demo/arch1
log_archive_dest_10 string
第四步：打開(kāi)歸檔模式
繼續(xù)在實(shí)例1上操作
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 218103808 bytes
Fixed Size 1260032 bytes
Variable Size 75499008 bytes
Database Buffers 138412032 bytes
Redo Buffers 2932736 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA/demo/arch1
Oldest online log sequence 3
Next log sequence to archive 4
Current log sequence 4
SQL>
好了,到這里就按照我預(yù)先的規(guī)劃把這個(gè)2個(gè)節(jié)點(diǎn)的RAC數(shù)據(jù)庫(kù)打開(kāi)到歸檔模式下了,歸檔文件存放在FRA磁盤(pán)組中.
第五步：打開(kāi)剩余實(shí)例
[oracle@rac01] /home/oracle> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.demo.db application ONLINE ONLINE rac02
ora....o1.inst application ONLINE ONLINE rac01
ora....o2.inst application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02
[oracle@rac01] /home/oracle> srvctl start instance -d demo -i demo2
[oracle@rac01] /home/oracle> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.demo.db application ONLINE ONLINE rac02
ora....o1.inst application ONLINE ONLINE rac01
ora....o2.inst application ONLINE ONLINE rac02
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02
[oracle@rac01] /home/oracle>
第六步：測(cè)試驗(yàn)證
[oracle@rac01] /home/oracle> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Oct 9 18:26:51 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> alter system archive log current;
System altered.
SQL>
ASMCMD> pwd
+FRA/demo/arch1
ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
N 1_4_731958872.dbf => +FRA/demo/ARCHIVELOG/2010_10_09/thread_1_seq_4.256.731960815
ASMCMD> cd ..
ASMCMD> cd arch2
ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
N 2_2_731958872.dbf => +FRA/demo/ARCHIVELOG/2010_10_09/thread_2_seq_2.257.731960817
ASMCMD>
[oracle@rac02] /home/oracle> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Oct 9 18:34:17 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA/demo/arch2
Oldest online log sequence 2
Next log sequence to archive 3
Current log sequence 3
SQL>
|
