oracle asm 状态,Oracle 10g r2 rac + ASM 修改为归档状态

Oracle 10g r2 rac数据库修改归档到ASM

1，asm上创建相关空间目录

export ORACLE_SID=+ASM1

asmcmd

mkdir arch1 arch2

ASMCMD> pwd

+DATA/RACDB/archive

ASMCMD> ls

arch1/

arch2/

ASMCMD>

2，mount状态下，在一个节点修改

[oracle@rac1 software]$ export ORACLE_SID=racdb1

[oracle@rac1 software]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 30 10:21:41 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area  209715200 bytes

Fixed Size                  1218556 bytes

Variable Size             100665348 bytes

Database Buffers          104857600 bytes

Redo Buffers                2973696 bytes

Database mounted.

SQL> archive log list

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /u01/app/oracle/product/10.2.0/db_1/dbs/arch

Oldest online log sequence     14

Current log sequence           15

SQL> alter system set log_archive_dest_1='LOCATION=+DATA/RACDB/archive/arch1' sid='racdb1';

System altered.

SQL> alter system set log_archive_dest_1='LOCATION=+DATA/RACDB/archive/arch2' sid='racdb2';

System altered.

SQL> show parameter cluster_database

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

cluster_database                     boolean     TRUE

cluster_database_instances           integer     2

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            +DATA/racdb/archive/arch1

Oldest online log sequence     14

Next log sequence to archive   15

Current log sequence           15

SQL> exit

3,启动另一个节点

[oracle@rac1 software]$ crs_start ora.racdb.racdb2.inst

Attempting to start `ora.racdb.racdb2.inst` on member `rac2`

Start of `ora.racdb.racdb2.inst` on member `rac2` succeeded.

4，验证是否成功

node2执行

SQL> alter system archive log current;

System altered.

[oracle@rac2 ~]$ export ORACLE_SID=+ASM2

[oracle@rac2 ~]$ asmcmd

ASMCMD> ls

DATA/

ASMCMD> cd +DATA/racdb/archive/arch2

ASMCMD> ls

2_7_738946915.dbf