Is it possible to decrypt a redo log?
Date: 1997/03/21
Message-ID: <3332FD0A.6CC9_at_teleport.com>#1/1
I'd really appreciate some help on the practicality of trying to glean
information from archived redo logs (Oracle v7.2.2). We have a vendor
package that runs on Oracle/AIX. On the last cycle, it did something
unpleasant with our payroll, and nobody (least of all the vendor!) can
offer an explanation. We restored a cold backup from a prior night and
reran data entry and batch processing - this time it worked fine.
Naturally, my management (definitely members of the pointy-haired
Dilbert variety), are demanding that I somehow "reconstruct" the
sequence of events during the bad run by "reading" the archived redo
logs from that time period. Now I'm a mainframe DBA, with Oracle as my
fourth DBMS to support and all I can remember from my one week of
training was that the redo logs contained parsed SQL that was suitable
for high-speed processing by Oracle in a recovery situation. The manulas
are suitably cryptic and keep darting from volume to volume.Is there a
reasonable way to "cherchez la bug" through redo logs, or should I tell
management to take a flying leap and apply for one of the many Oracle
DBA jobs advertised in this newsgroup?
thanks in advance,
"Pissed in Portland"
Received on Fri Mar 21 1997 - 00:00:00 CET