Hi<\/p>\n
I wanted share one useful script which I wrote few minutes ago ( part of my big project )\u00a0 \ud83d\ude42<\/p>\n
You know we do Oracle Restore and we need few things. One of the most important thing is to restore\u00a0 control file.<\/p>\n
You need to find it<\/p>\n
Write name into the restore command<\/p>\n
Start restore<\/p>\n
Repeat it for every restore ( \u0131t was kind boring for me \ud83d\ude42\u00a0 )<\/p>\n
<\/p>\n
Thats why I wrote this<\/p>\n
ssh <hostnameoftheproduction> ‘export lastlog=$(find \/u01\/app\/oracle\/diag\/rdbms\/exaprod\/PROD1\/trace\/rman_PROD_ARCH_* -type f | xargs grep -l “c-” | xargs ls -rt | tail -n 1) ; grep “c-” $lastlog | cut -f2 -d’=’ |cut -f1 -d” “‘ > \/tmp\/controlfile<\/p>\n
export controlfile=$(cat \/tmp\/controlfile)<\/p>\n
echo $controlfile<\/p>\n
<\/p>\n
You Need to change ;<\/p>\n
RMAN Backup Log= \/u01\/app\/oracle\/diag\/rdbms\/exaprod\/PROD1\/trace\/rman_PROD_*2019*<\/p>\n
hostnameoftheproduction<\/p>\n
<\/p>\n
Now we know control file and we have variable, lets make this command more useful with the below script<\/p>\n
<\/p>\n
echo “” > restore.rman
\necho “set dbid=18578182” >> restore.rman
\necho “run {” >> restore.rman
\necho “ALLOCATE CHANNEL chtape1 TYPE ‘SBT_TAPE’ PARMS=’SBT_LIBRARY=\/usr\/openv\/netbackup\/bin\/libobk.so64′;” >> restore.rman
\necho “SEND ‘NB_ORA_CLIENT=tristexadbadm01,NB_ORA_POLICY=tristexadbadm01_rman_PROD,NB_ORA_SERV=tristbckp’;” >> restore.rman
\necho “restore controlfile from ‘$controlfile’;” >> restore.rman
\necho “alter database mount;” >> restore.rman
\necho “SQL “alter database flashback off”;” >> restore.rman
\necho “}” >> restore.rman<\/p>\n
rman TARGET \/ CATALOG rman\/<password>@CATDB
\n@restore.rman<\/p>\n
<\/p>\n
You Need to change ;<\/p>\n
hostnames and backup server name in the restore.rman script<\/p>\n
<\/p>\n
This script is usefull for DBAs who has to do restore too much… Told be truth you have to improve this script more to do whole restore database which I am working on it \ud83d\ude42<\/p>\n
<\/p>\n
I hope you like it. Please don’t hesitate to ask any script you want.<\/p>\n
<\/p>\n
https:\/\/ittutorial.org\/oracle-database-19c-tutorials-for-beginners\/<\/p>\n","protected":false},"excerpt":{"rendered":"
Hi I wanted share one useful script which I wrote few minutes ago ( part of my big project )\u00a0 \ud83d\ude42 You know we do Oracle Restore and we need few things. One of the most important thing is to restore\u00a0 control file. You need to find it Write name into the restore command Start …<\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,1994,5042],"tags":[6433,6428,2028,425,959,1120,1327,6427,6429,1478,6431,6430,1551,6432],"class_list":["post-11443","post","type-post","status-publish","format-standard","","category-linux","category-oracle","category-rman","tag-bash","tag-control","tag-control-file","tag-controlfile","tag-linux","tag-oracle","tag-oracle-rman","tag-restore","tag-restore-control-file","tag-rman","tag-rman-restore","tag-script","tag-shell","tag-shell-script"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/11443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=11443"}],"version-history":[{"count":7,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/11443\/revisions"}],"predecessor-version":[{"id":12847,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/11443\/revisions\/12847"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=11443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=11443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=11443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}