Re: Finding transactions in the redo logs

On Thu, 20 May 1999 14:25:06 +0200, Eduard Erhart <eduard_erhart_at_at.ibm.com> wrote:

> Hi!
>Any tip how to find out, what transactions are stored in the online redo
>logs?
>

There are two commands to dump the redo logs:

1. Dump the file header of a redo log

  svrmgrl <<!
  connect internal;
  alter session set events 'immediate trace name redohdr level 10';   exit;
  !

2) Dump the content of a redo log:

2.1) Full Dump

  svrmgrl <<!
  connect internal;
  alter system dump logfile '$REDO_FILE_NAME';   exit;
  !

  (please replace $REDO_FILE_NAME with the appropriate name)

2.2) Partial Dump

  syntax ::= ALTER SYSTEM DUMP LOGFILE 'filename' option {option} ";"

  filename ::= the name of the logfile (online or offline log file)   option ::= RBA MIN seqno "." blockno |     RBA MAX seqno "." blockno |
    DBA MIN fileno "." blockno |
    DBA MAX fileno "." blockno |
    TIME MIN value |
    TIME MAX value |
    LAYER value |
    OPCODE value.

The dump files can be found in $UDUMP (user dump directory)

I hope this info fit your needs...
Fred Stojentin    Received on Thu May 20 1999 - 08:50:25 CDT