DBA Tools

How to keep given gigabytes of archive log files with Perl

    When managing a lot of databases, finding a good policy to manage the archive log files is very important to make the work easy. Usually archive log files are placed on dedicate volumns, purge by space will help...

Posted on November 26, 2008 7:57 PM

Find archive log file by given sequence with perl

    I am writing some DBA scripts with perl, one of them is the archive log file related. I have to implement this feature for more works. The first version is implemented by UNIX find command. # # Get...

Posted on November 26, 2008 7:47 PM

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