tag:blogger.com,1999:blog-3890970057024318255.post1328590632323946321..comments2024-03-15T08:36:23.954+03:00Comments on Database Administration Tips: Ready RMAN Backup Script To Schedule from CrontabMahmmoud ADELhttp://www.blogger.com/profile/15299387537990081025noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-3890970057024318255.post-90750683122700035982020-10-16T08:52:02.613+03:002020-10-16T08:52:02.613+03:00Hi Mahmmoud , Thanks for the feedback . you dont n...Hi Mahmmoud , Thanks for the feedback . you dont need to make any fixed parameters for tape , its just a parameter if its tape backup let the user define the channel | env parameters manually like $ORACLE_SID , $ORACLE_HOME ... etc<br /><br /><br />and how about the incremental backup option ?<br /><br /><br />thanks for your support.<br /><br />Regards,<br />SamOraDetectorhttps://www.blogger.com/profile/04299695474976693763noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-43994280248338634142020-10-08T08:50:15.868+03:002020-10-08T08:50:15.868+03:00Hi Sam,
Honestly I would like to make the script c...Hi Sam,<br />Honestly I would like to make the script compatible with tape backup but this is very difficult to accomplish, because every Media Management software has it own unique parameters that need to be passed to the script. e.g. here are the parameters that are need for one Media Management software "HPDP"<br />parms 'SBT_LIBRARY=xxxx<br />send channel 'ch1' 'OB2BARTYPE=xxxx';<br />send channel 'ch1' 'OB2APPNAME=xxxx'<br />send channel 'ch1' 'OB2BARLIST=xxxx;<br /><br />It's almost impossible for me to speculate the right parameters for each Media Management software, because they are a lot, moreover many of these parameters values are being changed based on how the Media Management software (either Server or Client) been set up; each environment has its own specific settings.<br /><br />I believe it's better to leave the user to change the channel parameters himself in case he/she wants to back up to a tape.Mahmmoud ADELhttps://www.blogger.com/profile/15299387537990081025noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-15505934491979773662020-10-06T00:26:55.493+03:002020-10-06T00:26:55.493+03:00is it possible to include incremental / tape suppo...is it possible to include incremental / tape support in the script ?OraDetectorhttps://www.blogger.com/profile/04299695474976693763noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-7587250432334163142020-09-23T20:24:21.824+03:002020-09-23T20:24:21.824+03:00it would be perfect if yu include incremental stra...it would be perfect if yu include incremental strategy and sbt supportOraDetectorhttps://www.blogger.com/profile/04299695474976693763noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-91325671742124249882020-08-02T17:57:50.598+03:002020-08-02T17:57:50.598+03:00This depends on how much time the backup will take...This depends on how much time the backup will take, backup storage cost/license and how critical the DB is and it's Service Level Agreement (SLA).<br /><br />In general, For the DBs that take less than 2 hours to fully backup, I prefer to have a daily Incremental 0 backup and archivelog backup every 1-4 hours (depends on the SLA's).<br /><br />For the DBs that takes longer than 2 hours for a full backup I prefer the following:<br />- Incremental 0 backup once a week.<br />- Incremental 1 backup every day.<br />- Archivelogs backup every 4 hours.<br /><br />I always prefer keeping the archivelogs on disk for at least 24 hours, UNDO RETENTION from 6 to 24 hours and keep FLASHBACK ON as possible.Mahmmoud ADELhttps://www.blogger.com/profile/15299387537990081025noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-24707296260183706352020-07-31T23:45:11.689+03:002020-07-31T23:45:11.689+03:00Mahmmoud can you describe good rman backup strateg...Mahmmoud can you describe good rman backup strategies for large databases?Anonymousnoreply@blogger.com