Can I delete archived redo log file?


I have read the Oracle backup/recovery docs for a long time
but still a lot of things are difficult to understand.

When experimenting with Oracle databases I noticed that the total
size of all archived redo log files grows quite quickly and eats
considerable storage space. Therefore I was thinking, that it should
be possible to delete these files periodically, after database backups
are performed. I wonder whether this is indeed done in practice by
experienced DBA's? If yes, how do they find out which files can safely
be deleted? How does the common strategy for handling the archived
redo logs look like?

Is there anywhere a backup/recovery tutorial for *beginners* (on
the web)? The Oracle documentation is from my POV not ideal to
start learning about these techniques.



Ans:
Redo logs are the lifeblood of any backup strategy and must be backed up (I
do it to tape).
Once this has been done and you have verified the integrity of the tape you
can as you thought delete the files. Redo logs do eat up large amounts of
space and if you fill the disk they are stored on Oracle will hang until
you free up space.
 
 
Hosted by www.Geocities.ws

1