{"id":48,"date":"2006-09-14T05:12:00","date_gmt":"2006-09-14T09:12:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=48"},"modified":"2008-06-25T14:57:25","modified_gmt":"2008-06-25T18:57:25","slug":"hot-backup-scripts-for-database-backup-and-apps-backup","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/","title":{"rendered":"Hot Backup Scripts for database backup and apps backup"},"content":{"rendered":"

Yesterday I discussed about backup Overview & cold backup if you have not gone though it you can read it from<\/p>\n

http:\/\/becomeappsdba.blogspot.com\/2006\/09\/backup-recovery-in-oracle-apps.html<\/a><\/p>\n

Yesterday I mentioned that I am going to post about hot backup scripts , here it comes<\/p>\n

Enable Archive Log<\/strong>
\nFirst check if your database is in Archive mode
\nSQL> archive log list
\nDatabase log mode Archive Mode
\nAutomatic archival Enabled
\nIf you see Automatic archival is enabled that means database is in archive mode . If not then<\/p>\n

SQL>SHUTDOWN<\/span>
\nSQL>STARTUP MOUNT<\/span>
\nSQL>ALTER DATABASE ARCHIVELOG;<\/span>
\nSQL>ALTER DATABASE OPEN;<\/span>
\nSQL>alter system set LOG_ARCHIVE_DEST_1 =’LOCATION=\/your\/archive\/location\/arch’ scope=spfile;<\/span>
\nSQL>shutdown immediate<\/span>
\nSQL>Startup<\/span>
\nSteps are for database 10g , These commands may vary according to your database version.<\/span>
\nAfter that for Hotbackup
\nChange tablespace mode to begin backup like
\nalter tablespace tablespace_name<\/em> begin backup; <\/strong>you have to do this for all tablesapces in your database except temporary tablespace (This can be tedious work if you are doing it manually so here is script to do so )<\/p>\n

SQL>set head off<\/span>
\nSQL>spool beginbackup.sql<\/span>
\nSQL>select ‘alter tablespace ‘ tablespace_name ‘ begin backup;’ from dba_tablespaces;<\/span>
\nSQL>spool off<\/span>
\n<\/span>
\nThis will create file beginbackup.sql with entry for all tablespaces, remove any unnecessary lines & then execute this script into SQL like
\nSQL>@beginbackup.sql (Once you execute this script this will put all tablespaces in to begin backup mode)<\/p>\n

Now create backup of your control file in Human Readable format like
\nalter database backup controlfile to trace as ‘\/some\/path’<\/strong>; you can reuse it by removing comment at beginning & replace them with connect \/ as sysdba<\/strong><\/p>\n

Then
\n1. Copy all your datafiles, redo logs and control file from your database server to backup location.
\nafter datafiles are copied don’t forget to end backup for all tablespace <\/strong>here is the scripts
\nSQL>set head off
\nSQL>spool endbackup.sql
\nSQL>select ‘alter tablespace ‘ tablespace_name ‘ end backup;’ from dba_tablespaces;
\nSQL>spool off<\/p>\n

This will create file endbackup.sql with entry for all tablespaces, remove any unnecessary lines & then execute this script into SQL like
\nSQL>@endbackup.sql (Once you execute this script this will put all tablespaces in to end backup mode)<\/p>\n

This completes your datafiles backup<\/strong> but<\/strong> you still have to backup database software & oracle Applications Middle Tier<\/p>\n

2. Copy database software $ORACLE_HOME from server to backup location
\n3. Copy Apps Middle tier all TOPs (APPL_TOP, COMMON_TOP, ORA_TOP)<\/p>\n

TIP:<\/strong> Sometime if you copy application tier while apache is Up , you copy httpd.pid or httpd_pls.pid <\/strong>from $IAS_ORACLE_HOME\/Apache\/Apache\/logs\/httpd.pid and if in restored Instance Apache doesn’t start & complain about httpd.pid or httpd_pls.pid already exists , you can simply delete these two files from restored Instance & start Apache Web Server.<\/span><\/p>\n

Please note I am not in town for another 4 days so I’ll not be able to Upadte this Site till Tuesday. Thanks in Advance for your patience.<\/span><\/p>\n

http:\/\/teachMeOracle.com\/forum<\/p>\n","protected":false},"excerpt":{"rendered":"

Yesterday I discussed about backup Overview & cold backup if you have not gone though it you can read it […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[424],"tags":[],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"\nHot Backup Scripts for database backup and apps backup -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hot Backup Scripts for database backup and apps backup -\" \/>\n<meta property=\"og:description\" content=\"Yesterday I discussed about backup Overview & cold backup if you have not gone though it you can read it […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/\" \/>\n<meta property=\"article:published_time\" content=\"2006-09-14T09:12:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-06-25T18:57:25+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/\",\"name\":\"Hot Backup Scripts for database backup and apps backup -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2006-09-14T09:12:00+00:00\",\"dateModified\":\"2008-06-25T18:57:25+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hot Backup Scripts for database backup and apps backup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hot Backup Scripts for database backup and apps backup -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/","og_locale":"en_US","og_type":"article","og_title":"Hot Backup Scripts for database backup and apps backup -","og_description":"Yesterday I discussed about backup Overview & cold backup if you have not gone though it you can read it […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/","article_published_time":"2006-09-14T09:12:00+00:00","article_modified_time":"2008-06-25T18:57:25+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/","url":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/","name":"Hot Backup Scripts for database backup and apps backup -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2006-09-14T09:12:00+00:00","dateModified":"2008-06-25T18:57:25+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/14\/hot-backup-scripts-for-database-backup-and-apps-backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Hot Backup Scripts for database backup and apps backup"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}