The Oracle10gr2rac database is modified and archived to ASM1, and the related Space Directory exportORACLE_SID + ASM1asmcmdmkdirarch1arch2ASMCMDgt; p is created on asm.
Oracle 10g r2 rac database modification archive to ASM1, asm create related Space Directory export ORACLE_SID = + ASM1asmcmdmkdir arch1 arch2ASMCMDgt; p
Oracle 10g r2 rac database modification archive to ASM
1. Create related space directories on asm
Export ORACLE_SID = + ASM1
Asmcmd
Mkdir arch1 arch2
ASMCMD> pwd
+ DATA/RACDB/archive
ASMCMD> ls
Arch1/
Arch2/
ASMCMD>
2. modify a node in the mount status
[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,200 5, 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. Start another node
[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. Check whether the verification is successful.
Node2 execution
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