Problem with RMAN script. [message #352914] |
Fri, 10 October 2008 04:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mirha494
Messages: 4 Registered: October 2008
|
Junior Member |
|
|
Hello all.
I recently found a cool script for my Oracle environment. The script works as is should but the script has two limitations that I can't solve by my self.
First of all, the backup files created by this script tend to be pretty big. I've read about how to compress backup files and also implemented some of these thoughts in this script. However, nothing seems to help, and I don't know really how to move further.
Seconds thing I need help with is to figure out how to remove older backups. This script stores all backups on the disk with today's date. However, I want the script to remove the all other backups after it's done with todays backup. So, the only backup that should be stored is todays backup (this sounds little fuzzy, I know)
I hope that someone could actually help me out with this cause I am not so good at oracle at all.
I attached the script.
[Updated on: Fri, 10 October 2008 05:35] Report message to a moderator
|
|
|
Re: Problem with RMAN script. [message #352925 is a reply to message #352914] |
Fri, 10 October 2008 04:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | The script works as is should but the script has two limitations that I can't solve by my self.
|
If you don't post it we can't help neither.
Quote: | However, nothing seems to help,
|
What does this mean? Figures? Same remark as above.
Quote: | Seconds thing I need help with is to figure out how to remove older backups...
|
If you use FRA and retention policy you have nothing to do Oracle will do it automatically.
Remember that documentation is your FIRST point of knowledge: Database Backup and Recovery Advanced User's Guide
Regards
Michel
[Updated on: Fri, 10 October 2008 04:45] Report message to a moderator
|
|
|
|
|
|
|
Re: Problem with RMAN script. [message #352989 is a reply to message #352984] |
Fri, 10 October 2008 07:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mirha494
Messages: 4 Registered: October 2008
|
Junior Member |
|
|
Yes, I've tried Google but honestly I don't know really what to look for. Are you telling me that there is a script that I can use or some other function that I can embed in the attached script file?
|
|
|
|
|