Hi,

I need to work on a backup strategy.

Scenario: My /arc partition contains datafiles and archive files. Sudden growth in the archive on a single day sometimes leads to the rapid filling of the partition, thus resulting in DB down state.

Backup being taken: export backup

Archive files retention: 3days

Query: 1> Do we require to keep the archive files if backup type is export?? Will this help in recovery anyway when we dont have a cold backup at all?
Well, the answer I think is: No
2> If the answer is No, then is it feasible to take RMAN backup for both datafiles and archive log files on everyday basis?
3> If the answer is yes, then after the RMAN backup is taken on everyday basis, we can include the option of archive log delete all, post the backup is taken, in the RMAN script.
Am I correct?
This way we will get rid of the /arc partition getting filled.

Please suggest if this is a good option to be adopted?

Thanks in advance