Disabling ARCHIVELOG problem

Hi

We're running 8.1.7 on Solaris. In order to run a large batch job I've been asked to disable archive logging (I know - I don't agree either). When I tried to do so I got an error message:-

ORA-01143 cannot disable media recovery - file XXXX needs media recovery

The documentation suggests either recovering or dropping the tablespace.

Out of curiousity I went to recover datafile and was prompted for an archive log from 6/11/04 (presumably 11th June, otherwise we have a *real* problem). However our backup cycle only goes back 28 days, so we probably can't get this far back.

This is our production database and everything appears to be working correctly. We would be very reluctant to drop the tablespace.

We perform backups on a daily basis (mixed full and incremental) using RMAN and Veritas NetBackup.

Can anyone explain what causes the problem on an otherwise error-free system, and/or suggest a work round.

Chloe Crowder
The British Library Received on Tue Aug 31 2004 - 03:58:14 CDT