I have lot of archive log files in the production database.I am not running using RMAN.Can i delete all the archive logs except for the last week.Will this deletion will have any effect if there is recovery.can anyone adivce me on this.
Originally posted by castlerock Hi ,
we are taking hot backup(control file,datafiles) to tape drive. We are not backing up the archive log files.
Backing up archive log files must be a part of any hotbackup. You can look for some scripts on this site to include archive log backup in your hotbackup script.
Think of moving to RMAN if your DB version is > 8.X
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"