Hallo,
in der Vergangenheit war es oft notwendig das ich für „asmcmd“ einen Trace benötigte, um zu sehen welche Befehle oder Abfolge zu einem Problem führte. Deswegen hier ein kurzes Beispiel.
Normaler Aufruf für „asmcmd“
>asmcmd ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 61436 26135 0 26135 0 N DG_DATA/ MOUNTED EXTERN N 512 4096 1048576 61436 59433 0 59433 0 N DG_FRA/
Die Trace Option kann einfach mit einer Umgebungs Variable aktiviert werden.
>export DBI_TRACE=1 ... ASMCMD> lsdg <- prepare('/* ASMCMD */ select * from v$asm_diskgroup_stat')= DBI::st=HASH(0x186d6630) at asmcmdshare.pm line 2572 <- execute= '0E0' at asmcmdshare.pm line 2591 <- fetchrow_hashref= HASH(0x188600f0)17keys row1 at asmcmdshare.pm line 2617 <- fetchrow_hashref= undef row2 at asmcmdshare.pm line 2617 <- finish= 1 at asmcmdshare.pm line 2638 <- DESTROY(DBI::st=HASH(186d1678))= undef at asmcmdbase.pm line 2555 State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name <- prepare('/* ASMCMD */ select operation from v$asm_operation where group_number=1')= DBI::st=HASH(0x186d67c8) at asmcmdshare.pm line 2572 <- execute= '0E0' at asmcmdshare.pm line 2591 <- fetchrow_hashref= undef at asmcmdshare.pm line 2617 <- finish= 1 at asmcmdshare.pm line 2638 <- DESTROY(DBI::st=HASH(186d66a8))= undef at asmcmdbase.pm line 2688 MOUNTED EXTERN N 512 4096 1048576 61436 26135 0 26135 0 N DG_DATA/ <- prepare('/* ASMCMD */ select operation from v$asm_operation where group_number=2')= DBI::st=HASH(0x1885fda8) at asmcmdshare.pm line 2572 <- execute= '0E0' at asmcmdshare.pm line 2591 <- fetchrow_hashref= undef at asmcmdshare.pm line 2617 <- finish= 1 at asmcmdshare.pm line 2638 <- DESTROY(DBI::st=HASH(1885fa30))= undef at asmcmdbase.pm line 2688 MOUNTED EXTERN N 512 4096 1048576 61436 59433 0 59433 0 N DG_FRA/
Der Trace kann auch einfach wieder deaktiviert werden
>export DBI_TRACE=0
Wie immer freue ich mich über Feedback