|
Answer» You must use the DECRYPT option before viewing data in the Trail data. List few useful Logdump commands to view and search data stored in OGG trail files. Below are few logdump commands used on a DAILY basis for displaying or analyzing data stored in a trail file. $ ./logdump – to connect to the logdump prompt logdump> open /u01/app/oracle/dirdat/et000001 – to open a trail file in logdump logdump> fileheader on – to view the trail file header logdump> ghdr on – to view the record header with data logdump> DETAIL on – to view COLUMN information logdump> detail data – to display HEX and ASCII data values to the column list logdump> reclen 200 – to control how much record data is displayed logdump> pos 0 – To go to the first record logdump> next (or simply n) – to move from one record to another in sequence logdump> count – counting records in a trail You must use the DECRYPT option before viewing data in the Trail data. List few useful Logdump commands to view and search data stored in OGG trail files. Below are few logdump commands used on a daily basis for displaying or analyzing data stored in a trail file. $ ./logdump – to connect to the logdump prompt logdump> open /u01/app/oracle/dirdat/et000001 – to open a trail file in logdump logdump> fileheader on – to view the trail file header logdump> ghdr on – to view the record header with data logdump> detail on – to view column information logdump> detail data – to display HEX and ASCII data values to the column list logdump> reclen 200 – to control how much record data is displayed logdump> pos 0 – To go to the first record logdump> next (or simply n) – to move from one record to another in sequence logdump> count – counting records in a trail
|