Home » RDBMS Server » Backup & Recovery » Problem with RMAN script. (Oracle 10 Express Version)
Problem with RMAN script. [message #352914] Fri, 10 October 2008 04:14 Go to next message
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 messageGo to next message
Michel Cadot
Messages: 64102
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 #352948 is a reply to message #352925] Fri, 10 October 2008 05:36 Go to previous messageGo to next message
mirha494
Messages: 4
Registered: October 2008
Junior Member
Sorry, have attached the script now.
Re: Problem with RMAN script. [message #352956 is a reply to message #352948] Fri, 10 October 2008 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Find a 10g script to use the new features.

Regards
Michel
Re: Problem with RMAN script. [message #352969 is a reply to message #352956] Fri, 10 October 2008 06:16 Go to previous messageGo to next message
mirha494
Messages: 4
Registered: October 2008
Junior Member
I would appreciate if you could paste the link here. Thank you.
Re: Problem with RMAN script. [message #352984 is a reply to message #352969] Fri, 10 October 2008 07:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try Google?

Regards
Michel
Re: Problem with RMAN script. [message #352989 is a reply to message #352984] Fri, 10 October 2008 07:20 Go to previous messageGo to next message
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?
Re: Problem with RMAN script. [message #353001 is a reply to message #352989] Fri, 10 October 2008 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&q=oracle+rman+10g+script&aq=f&oq=

Regards
Michel
Re: Problem with RMAN script. [message #353168 is a reply to message #352914] Sun, 12 October 2008 03:16 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Assuming you have flash recovery area enable and you take backup in it, Then
Set
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
which is default one.
Then issue,
RMAN> delete obsolete;

[Updated on: Sun, 12 October 2008 03:18]

Report message to a moderator

Previous Topic: Error while recovering a Datafile
Next Topic: Complete Recovery using OEM after a server crash
Goto Forum:
  


Current Time: Fri Dec 02 16:59:47 CST 2016

Total time taken to generate the page: 0.49168 seconds