tag:blogger.com,1999:blog-3890970057024318255.post6427901651368406768..comments2024-03-15T08:36:23.954+03:00Comments on Database Administration Tips: RMAN Backup Shell Script for OracleMahmmoud ADELhttp://www.blogger.com/profile/15299387537990081025noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-3890970057024318255.post-66753795788702268802021-08-17T16:31:10.881+03:002021-08-17T16:31:10.881+03:00Please hash line# 118 in the script:
#ORACLE_HOME...Please hash line# 118 in the script:<br /><br />#ORACLE_HOME=`pwdx ${PMON_PID}|awk '{print $NF}'|sed -e 's/\/dbs//g'`Mahmmoud ADELhttps://www.blogger.com/profile/15299387537990081025noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-51422410865699795672021-08-17T10:54:25.146+03:002021-08-17T10:54:25.146+03:00pwdx show permission denied on oracle linux 7, any...pwdx show permission denied on oracle linux 7, any solution for this?Khalid Aboelmagdhttps://www.blogger.com/profile/10470316229049656791noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-16443289252531931942020-09-04T17:42:32.845+03:002020-09-04T17:42:32.845+03:00Thanks for your comment.
Actually I don't dev...Thanks for your comment.<br /><br />Actually I don't develop/share scripts that may cause wide change to the database, because it may cause damages if they get used wrongly, moreover, bugs can be there as well, as I cannot test the scripts on all sorts of environments. Thanks for your understanding.Mahmmoud ADELhttps://www.blogger.com/profile/15299387537990081025noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-41110150004873556862020-09-03T20:38:05.533+03:002020-09-03T20:38:05.533+03:00Thanks for sharing this insightful post. Do you ha...Thanks for sharing this insightful post. Do you happen to have a script to assist with the recovery from this backup?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-61379745513963725822019-12-31T13:08:19.896+03:002019-12-31T13:08:19.896+03:00Hi,
Thanks for your comment.
Actually I read the a...Hi,<br />Thanks for your comment.<br />Actually I read the article and it's totally true from the theory perspective but practically this is not the case; Nowadays DBAs are managing hundreds of databases when a backup fail the DBA should interact quickly (which is difficult to do so) before the backup window get passed because most probably the next full backup window will be after a day or a week! The thing will impact the DB recoverability. Moreover, it never happens (at least for me) to investigate a case where archivelogs got deleted using OS commands from the disk (before getting backed up) and I managed to restore them back! When archivelog files accidentally get deleted using OS command it's almost impossible to restore them back; so the life should go on and the backup should not miss its window. This is my humble opinion.Mahmmoud ADELhttps://www.blogger.com/profile/15299387537990081025noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-78733102397602475172019-12-30T17:53:18.846+03:002019-12-30T17:53:18.846+03:00I can see that in your script you are using "...I can see that in your script you are using "change archivelog all crosscheck" while it's not recommended, see this:<br />https://blog.dbi-services.com/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts/<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-59864744883868328662018-04-10T09:59:18.401+03:002018-04-10T09:59:18.401+03:00Fantastic Article ! Thanks for sharing this Lov...<a title="Fantastic Article !" href="https://www.beeyestravels.com/coimbatore-taxi.html" rel="nofollow">Fantastic Article !</a> <a title="Thanks for " href="https://www.beeyestravels.com/ooty-taxi.html" rel="nofollow">Thanks for </a> <a title="sharing " href="https://www.beeyestravels.com/ooty-travels.html" rel="nofollow">sharing </a> <a title="this " href="https://www.beeyestravels.com/coimbatore-airport-taxi.html" rel="nofollow">this </a> <a title="Lovely " href="https://www.beeyestravels.com/kodaikanal-taxi.html" rel="nofollow">Lovely </a> <a title="Post !!" href="https://www.beeyestravels.com/munnar-taxi-service.html" rel="nofollow">Post !!</a>Anonymoushttps://www.blogger.com/profile/00850850069874704675noreply@blogger.com