I have inherited an Oracle 11g DB running on Windows. The first order of business is taking care of an HD space issue which is caused by over 2000 archive file (.001 files). As I understand it, these are made by Oracle and are managed using a utility called RMAN.

Using RMAN, I have discovered none of these files have been "applied" to the DB and they can't be because a bunch of them are missing. I'm not sure what to do now. The DB is healthy atm but if there is a problem, recovery is not an option as things stand.

Now if I had a problem like this in MSSQL I could flip the recovery mode to SIMPLE and then back to FULL and it would clear all the old transaction log files and restart everything. Is there a way to do something with Oracle that would give me the same effect?

  • You should be able to use RMAN to take a new backup (and establish a new baseline), then delete obsolete archivelogs.
    – pmdba
    May 18 at 0:25


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.