Oracle 10gR2 RAC+ASM 归档设置示例

从Oracle 10gR2开始,对于RAC数据库设置归档模式非常方便,只需要在其中任何一个节点上操作,剩余节点instance关闭即可,下面是一个Oracle 10.2.0.2
版本2个节点的RAC数据库打开归档模式的示例,归档存放在FRA磁盘组下的demo目录下

第一步:规划目录

实例1的归档路径：+FRA/demo/arch1
实例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>

第二步：关闭实例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

在节点1上确认实例2已经关闭
[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     
第三步：设置归档参数
在实例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
第四步：打开归档模式
继续在实例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>
好了,到这里就按照我预先的规划把这个2个节点的RAC数据库打开到归档模式下了,归档文件存放在FRA磁盘组中.

第五步：打开剩余实例

[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>
第六步：测试验证
[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>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23898243/viewspace-710065/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23898243/viewspace-710065/