Home » RDBMS Server » Backup & Recovery » Need help with rman backup script (10.2.0.4, win 2008)
Need help with rman backup script [message #575858] Mon, 28 January 2013 09:22 Go to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
Hi,

Could you please tell me how to arrange the maintainance steps in Rman Script. I read in few rman articles, that we should not include CROSSCHECK command in rman backup scripts.

Do we need to create seperate script to run commands like

CROSSCHECK BACKUP,
DELETE NOPROMPT OBSOLETE,
DELETE EXPIRED BACKUP

Please suggest best practices when writing backup scripts.
Re: Need help with rman backup script [message #575860 is a reply to message #575858] Mon, 28 January 2013 09:30 Go to previous messageGo to next message
John Watson
Messages: 4609
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I read in few rman articles, that we should not include CROSSCHECK command in rman backup scripts.
Which articles? I have never read that.
Re: Need help with rman backup script [message #575864 is a reply to message #575860] Mon, 28 January 2013 09:51 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
http://www.slideshare.net/yvelikanov/10-problems-with-your-rman-backup-script

http://shahiddba.blogspot.com/2012/04/point-to-be-considered-with-rman-backup.html

Re: Need help with rman backup script [message #575865 is a reply to message #575864] Mon, 28 January 2013 10:36 Go to previous messageGo to next message
John Watson
Messages: 4609
Registered: January 2010
Location: Global Village
Senior Member
The comment from Yuri Velikanov is silly: no-one said you have to delete files found to be expired, that is just his idea. I would report on them, which he forgets to do. The comment from Shahid Ahmed is worse: no justification at all.

I sure as hell want to know about missing backups, and that means crosschecking regularly. Up to you.

Re: Need help with rman backup script [message #575866 is a reply to message #575865] Mon, 28 January 2013 10:39 Go to previous message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
Thanks for the answer,
Previous Topic: RMAN Incrementally Updated Backups
Next Topic: recover database until cancel
Goto Forum:
  


Current Time: Tue Sep 30 00:57:29 CDT 2014

Total time taken to generate the page: 0.06930 seconds