DBA Tools

lslog -- read basic information form archived log file

    How to get the first SCN, next SCN, first time, next time of archived log? the first way should be check rows from V$LOG_HISTORY or V$ARCHIVED_LOG, but these view just keep information of few latest archived logs, it...

Posted on October 10, 2007 11:08 AM

MyLOG, an offline Oracle log miner to extract the redo SQLs

    I spent some time in researching the Oracle log file format. Previous research was done about two years ago for Oracle 9i. Fortunately I did get something for these days research. And wrote a tool called "MyLOG" (8i/9i,10g/11g)...

Posted on September 21, 2007 2:11 PM

Tools can be used to copy archived log to remote host

    Standby is a good way for disaster recovery, usually we create at least two standbys for each production database, one is locally with minimum time delay to the primary, and another is remotely in different city with 8...

Posted on September 20, 2007 3:49 PM