-
Help on backup strategy
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|