oracle asm 状态,Oracle10gr2rac+ASM修改为归档状态

Oracle 10g r2 rac数据库修改归档到ASM1，asm上创建相关空间目录 export ORACLE_SID=+ASM1asmcmdmkdir arch1 arch2ASMCMDgt; p

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

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网