Re: How to check archived log files ?

The short answer is that if ARCH manages to write the archived files, they are clear of corruption. ARCH doesn't just do an O/S-style copy, but an intelligent read of the logs, and an intelligent write of the archives. It's its own policeman as far as detecting corruption is concerned.

The slightly longer answer is that you can run log miner (assuming an 8i or above database). In 8i, if the analysis of a log encounters corruption, it bombs out with spectacular errors (in 9i, it can keep going, but you'll still know it encountered corruption).

If you've got an Oracle 8 database, log miner can be run from an 8i database against archives produced by Oracle 8. But if you're on Oracle 7, forget it. Incidentally, when you post, version numbers are helpful -there are rather a lot of them out there now!

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"Gerald Hein" <gerald.hein_at_epost.de> wrote in message
news:3BBC997C.7020803_at_epost.de...


> Hi,

>

> There is a tool dbverify ('dbv') which could be used to check datafiles

> for corrupted blocks.

>

> Is there also a tool to check archived log files for corrupted entries ?

>

> Which possibilities exist to ensure the archived log files are not

> corrupted ?

>

> Thanks,

> Gerald

>