RMAN

[jestrada101]

I have RMAN failing on 10g on doing an archive. Archive log is on, how can i disable this.

Thanks for any help.

 

[jestrada101]

My archive log is stuck, it ran out of space. How can I cancel the archive log and disable archive adn bring the db back up?

Thanks!
JE

 

[Thargy]

jestrada,

you don't want to disable archive log mode, just because you've run out of storage space.

RMAN does backups, and has nothing to do directly with the archive logs. However, if during your RMAN session you state

backup database plus archivelog;

then as the number of archive logs increases, so will the size of the corresponding RMAN backup. It is not required to backup archive logs, but it's generally a good idea to do so.

If the RMAN backup folder has gobbled up all the disk space, you should consider deleting some of your oldest RMAN backups, to free up space. Use the RMAN "delete obsolete" command for this.

If the archive logs are gobbling up all the disk space, you should consider deleting some of the oldest ones.

Try to locate something which is at or near its size limit. Increase the storage for the offending item, just so the database can resume functioning.

For future reference, you can use the "delete input" option in RMAN so that it will automatically remove backed up archived redo logs, which might help with your storage problems.

Regards

Tharg

Grinding away at things Oracular