{"id":47,"date":"2006-09-12T09:30:00","date_gmt":"2006-09-12T13:30:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=47"},"modified":"2008-12-17T16:46:55","modified_gmt":"2008-12-17T20:46:55","slug":"backup-recovery-in-oracle-apps-database","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/","title":{"rendered":"Backup & Recovery in Oracle Apps Database"},"content":{"rendered":"

Based on lots of request from readers of this blog I am posting on Backup & Recovery of Oracle Apps 11i database & application tier.<\/p>\n

I’ll discuss on How to troubleshoot load balancer in oracle Apps after Backup & Recover.<\/span><\/p>\n

You might have read in Oracle Documentation lot of time to backup your system before applying patch or before database Upgrade or changing any file or table. Today you will see how to take backup of table, file, database or applications (I am covering only basic things on backup<\/span>)<\/p>\n

How to backup a file\/directory ?<\/strong>
\nThis is most common & very basic thing in taking backup, backup is snapshot of any file at a particular time . In order to take backup of file\/directory so that it can be recovered at later stage (In case of any issues)
\ncp filename filename<\/filename><\/filename>.bak <\/strong>
\nIf you want to backup directory you can use
\ncp -R dir dir.bak<\/strong>
\nIf directory is quite big lets assume APPL_TOP which is around 11GB you can tar (zip) utility in linux.
\ntar -cvf dir.tar dir <\/strong>( Where -c is compress , v is verbose, f is file )
\nto restore backed up directory use -x extract option like
\ntar -xvf dir.tar <\/strong><\/p>\n

How to backup a table ?<\/strong>
\nIf you are a DBA you will find this bit silly but you can use create table as<\/strong> assume you want to backup table FND_USERS to table FND_USERS_BAK , you can use
\nSQL> create table FND_USERS_BAK as select * from FND_USERS;
\nThough you can use imp\/exp feature of database as well to backup a atble.<\/p>\n

What are two main backup categories for Database ?<\/strong>
\nBroadly you have Cold Backup<\/strong> & Hot backup<\/strong> option with database.<\/p>\n

Cold backup<\/strong> : is database backup which you take when database is down
\nHotbackup <\/strong>: is database backup during which database is available to user . For Hotbackup database should be in archive log mode. Tablespaces should be in begin backup mode while copying data files.<\/p>\n

Advantages of Cold backup : <\/strong>
\nEasy to implement, No need to convert database in to archive.
\nDisadvantage of Cold Backup :<\/strong>
\nServices are not available during backup, not acceptable in production<\/p>\n

Advantages of Hot backup :<\/strong>
\nUsers can access database & application during backup
\nDisadvantages of Hot Backup :<\/strong>
\nDifficult to implement initially, extra space for archive logs<\/p>\n

For Cold Backup of Database & Applications :<\/strong>
\n–Shut down application tier services using adstpall.sh
\n–Shutdown database listener & database
\n–Copy file system (middle Tier & Database tier including software & datafiles to tape or harddisk ). You can zip or tar as well to reduce size of backup as mentioned above via tar -cvf<\/strong>
\n–Once backup is over start database & db listener
\n–Start Application Tier<\/p>\n

For Hot backup of Database & Applications :<\/strong>
\n–Make sure database is in Archive log mode ( How to check & how to convert coming tomorrow<\/span>)
\n–Put tablespaces in to begin backup Mode
\n–Create backup control file
\n— Copy datafiles , log file, control files
\n–Put tablespaces into end backup Mode
\n— Copy oracle software & middle tier software as mentioned in cold backup mode
\nBackup done<\/p>\n

How to put tablespaces into begin or end backup mode <\/strong>
\nWait for tomorrow’s post<\/span> …<\/strong><\/p>\n

If you want to check Oracle Apps DBA Interview Questions check at<\/strong><\/p>\n

http:\/\/teachmeoracle.com\/interview.html<\/a> ( Around 15 pages & 90 questions)<\/strong><\/p>\n

*Those who posted interview questions to me, wait for some time as I am very busy right into project. I’ll try to respond you before end of this week .<\/span><\/p>\n

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

Based on lots of request from readers of this blog I am posting on Backup & Recovery of Oracle Apps […]<\/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":[1],"tags":[],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nBackup & Recovery in Oracle Apps Database -<\/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\/12\/backup-recovery-in-oracle-apps-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup & Recovery in Oracle Apps Database -\" \/>\n<meta property=\"og:description\" content=\"Based on lots of request from readers of this blog I am posting on Backup & Recovery of Oracle Apps […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/\" \/>\n<meta property=\"article:published_time\" content=\"2006-09-12T13:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-12-17T20:46:55+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\/12\/backup-recovery-in-oracle-apps-database\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/\",\"name\":\"Backup & Recovery in Oracle Apps Database -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2006-09-12T13:30:00+00:00\",\"dateModified\":\"2008-12-17T20:46:55+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup & Recovery in Oracle Apps Database\"}]},{\"@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":"Backup & Recovery in Oracle Apps Database -","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\/12\/backup-recovery-in-oracle-apps-database\/","og_locale":"en_US","og_type":"article","og_title":"Backup & Recovery in Oracle Apps Database -","og_description":"Based on lots of request from readers of this blog I am posting on Backup & Recovery of Oracle Apps […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/","article_published_time":"2006-09-12T13:30:00+00:00","article_modified_time":"2008-12-17T20:46:55+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\/12\/backup-recovery-in-oracle-apps-database\/","url":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/","name":"Backup & Recovery in Oracle Apps Database -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2006-09-12T13:30:00+00:00","dateModified":"2008-12-17T20:46:55+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/09\/12\/backup-recovery-in-oracle-apps-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Backup & Recovery in Oracle Apps Database"}]},{"@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\/47","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=47"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/47\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}