Using ASM on command line

Posted By Sagar Patil

From the OS command prompt, type asmcmd, which brings up the ASM command-line prompt:

export ORACLE_HOME=$ASM_HOME ; export ORACLE_SID=+ASM1

[oracle@wygora01 asm]$ asmcmd
ASMCMD> du .
Used_MB Mirror_used_MB
5151 5151

ASMCMD> asmcmd -p
commands:
——–
cd
du
find
help
ls
lsct
lsdg
mkalias
mkdir
pwd
rm
rmalias

ASMCMD> ls -l
State Type Rebal Unbal Name
MOUNTED EXTERN N N BACKUP/
MOUNTED EXTERN N N DATA/

ASMCMD> cd BACKUP/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
Y WYGPROD/

ASMCMD> cd WYGPROD/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N 1_10_647361523.dbf => +BACKUP/WYGPROD/ARCHIVELOG/2008_02_25/thread_1_seq_10.288.647631003
N 1_11_647361523.dbf => +BACKUP/WYGPROD/ARCHIVELOG/2008_02_26/thread_1_seq_11.292.647666319

……………….

Y ARCHIVELOG/
Y BACKUPSET/
Y CONTROLFILE/
Y DATAFILE/
Y ONLINELOG/
Y PARAMETERFILE/
N spfilewygprod.ora => +BACKUP/WYGPROD/PARAMETERFILE/spfile.261.647361669

More details availble at http://www.oracle.com/technology/oramag/oracle/06-mar/o26asm.html

Leave a Reply

You must be logged in to post a comment.

Top of Page

Top menu