Friday, June 22, 2007

ASM Instance Operational Procedure

Operational Procedure for ASM Instance

Startup Sequence
1. Start the ASM Instance
2. Start the ASM Enabled Database
3. Start the Listener for ASM Enabled Database

Source the Environment Variable ORACLE_HOME
Export ORACLE_SID=+ASM
Login as sys dba and issue STARTUP Command
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 17 19:41:49 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started

Total System Global Area 83886080 bytes
Fixed Size 1217836 bytes
Variable Size 57502420 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL>

Background Process:
$ ps -ef | grep -i asm
ora10g 4682 1 0 19:42 ? 00:00:00 asm_pmon_+ASM
ora10g 4684 1 0 19:42 ? 00:00:00 asm_psp0_+ASM
ora10g 4686 1 0 19:42 ? 00:00:00 asm_mman_+ASM
ora10g 4688 1 0 19:42 ? 00:00:00 asm_dbw0_+ASM
ora10g 4690 1 0 19:42 ? 00:00:00 asm_lgwr_+ASM
ora10g 4692 1 0 19:42 ? 00:00:00 asm_ckpt_+ASM
ora10g 4694 1 0 19:42 ? 00:00:00 asm_smon_+ASM
ora10g 4696 1 0 19:42 ? 00:00:00 asm_rbal_+ASM
ora10g 4698 1 0 19:42 ? 00:00:00 asm_gmon_+ASM
ora10g 4703 4651 0 19:50 pts/0 00:00:00 grep -i asm
$

Additional Processes:
RBAL - ReBalancer , its duty is to rebalance the activity for ASM Disk Groups

Starting the ASM Dependent Database

Export ORACLE_SID=ODB
Login as sys dba and issue STARTUP Command
$ export ORACLE_SID=ODB
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 17 19:59:23 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 71305460 bytes
Database Buffers 92274688 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>

Starting the Listener of the ASM Dependent Database
$ lsnrctl start ODB

Shutdown Operation is the reverse of the Startup
1. Stop the Listener
2. Stop the ASM Enabled Database
3. Stop the ASM Instance

Summary Startup and Shutdown of ASM Instances

ASM instance are started and stopped in a similar way to normal database instances.

The options for the STARTUP command are:
FORCE - Performs a SHUTDOWN ABORT before restarting the ASM instance.
MOUNT - Starts the ASM instance and mounts the disk groups specified by the ASM_DISKGROUPS parameter.
NOMOUNT - Starts the ASM instance without mounting any disk groups.
OPEN - This is not a valid option for an ASM instance.

The options for the SHUTDOWN command are:

NORMAL - The ASM instance waits for all connected ASM instances and SQL sessions to exit then shuts down.
IMMEDIATE - The ASM instance waits for any SQL transactions to complete then shuts down. It doesn't wait for sessions to exit.
TRANSACTIONAL - Same as IMMEDIATE.
ABORT - The ASM instance shuts down instantly.

Popular Posts