Useful environment variable for asmcmd debugging


$ export DBI_TRACE=1

ASMCMD> ls -l data
<- prepare('/* ASMCMD */ select to_char(current_date, 'J') "JULIAN_DATE" from dual')= ( DBI::st=HASH(0x1ed2c48) ) [1 items] at asmcmdshare.pm line 3256
<- execute= ( '0E0' ) [1 items] at asmcmdshare.pm line 3461
<- fetchrow_hashref= ( HASH(0x1f3fa68)1keys ) [1 items] row1 at asmcmdshare.pm line 3282
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3303
<- DESTROY(DBI::st=HASH(0xa24e00))= ( undef ) [1 items] at asmcmdbase.pm line 1130
<- prepare('/* ASMCMD */ select group_number, state from v$asm_diskgroup_stat where name='DATA'')= ( DBI::st=HASH(0x1ecc8b0) ) [1 items] at asmcmdshare.pm line 3256
<- execute= ( '0E0' ) [1 items] at asmcmdshare.pm line 3461
<- fetchrow_hashref= ( HASH(0x1ecc6b8)2keys ) [1 items] row1 at asmcmdshare.pm line 3282
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3303
<- DESTROY(DBI::st=HASH(0x1f3f5d0))= ( undef ) [1 items] at asmcmdshare.pm line 1744
<- prepare('/* ASMCMD */ select name,
group_number,
file_number,
reference_index,
parent_index,
alias_directory,
system_created
from v$asm_alias where group_number=1 and parent_index=16777216')= ( DBI::st=HASH(0x1ecc598) ) [1 items] at asmcmdshare.pm line 3256
<- execute= ( '0E0' ) [1 items] at asmcmdshare.pm line 3461
<- fetchrow_hashref= ( HASH(0x1ec81f8)7keys ) [1 items] row1 at asmcmdshare.pm line 3282
<- fetchrow_hashref= ( undef ) [1 items] row3 at asmcmdshare.pm line 3282
<- finish= ( 1 ) [1 items] at asmcmdshare.pm line 3303
<- DESTROY(DBI::st=HASH(0x1ecc8c8))= ( undef ) [1 items] at asmcmdbase.pm line 2311
Type Redund Striped Time Sys Name
Y CLONE1H/
N CLONE1H.backup/
N test/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s