Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database
  • Upgarde DB to
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management

  • We have moved to kindly check http://onlineAppsDBA.comin future
    Backup & Recovery in Oracle Apps Database
    Tuesday, September 12, 2006
    Register for R12 upgrade
    Based on lots of request from readers of this blog I am posting on Backup & Recovery of Oracle Apps 11i database & application tier.

    I'll discuss on How to troubleshoot load balancer in oracle Apps after Backup & Recover.

    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)

    How to backup a file/directory ?
    This 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)
    cp filename filename.bak
    If you want to backup directory you can use
    cp -R dir dir.bak
    If directory is quite big lets assume APPL_TOP which is around 11GB you can tar (zip) utility in linux.
    tar -cvf dir.tar dir ( Where -c is compress , v is verbose, f is file )
    to restore backed up directory use -x extract option like
    tar -xvf dir.tar

    How to backup a table ?
    If you are a DBA you will find this bit silly but you can use create table as assume you want to backup table FND_USERS to table FND_USERS_BAK , you can use
    SQL> create table FND_USERS_BAK as select * from FND_USERS;
    Though you can use imp/exp feature of database as well to backup a atble.

    What are two main backup categories for Database ?
    Broadly you have Cold Backup & Hot backup option with database.

    Cold backup : is database backup which you take when database is down
    Hotbackup : 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.

    Advantages of Cold backup :
    Easy to implement, No need to convert database in to archive.
    Disadvantage of Cold Backup :
    Services are not available during backup, not acceptable in production

    Advantages of Hot backup :
    Users can access database & application during backup
    Disadvantages of Hot Backup :
    Difficult to implement initially, extra space for archive logs

    For Cold Backup of Database & Applications :
    --Shut down application tier services using
    --Shutdown database listener & database
    --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
    --Once backup is over start database & db listener
    --Start Application Tier

    For Hot backup of Database & Applications :
    --Make sure database is in Archive log mode ( How to check & how to convert coming tomorrow)
    --Put tablespaces in to begin backup Mode
    --Create backup control file
    -- Copy datafiles , log file, control files
    --Put tablespaces into end backup Mode
    -- Copy oracle software & middle tier software as mentioned in cold backup mode
    Backup done

    How to put tablespaces into begin or end backup mode
    Wait for tomorrow's post ...

    If you want to check Oracle Apps DBA Interview Questions check at ( Around 15 pages & 90 questions)

    *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 .

    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 2:30 PM  
    • At 4:54 PM, Blogger Herod T said…

      use RMAN instead of hot backups.

      Much simplier and less complicated and easier to restore with more features.

    • At 4:58 PM, Blogger Atul Kumar said…

      Hi Herod,
      Thanks a lot for your valuable suggestion. Would you like to share RMAN setup with Other Budding Apps DBA's ?

      If you can spare some time , I can give Team Member rights & you can update configuring RMAN .

      Atul Kumar

    • At 2:37 PM, Blogger Irfan said…

      RMAN may help with small and Middle size databases. I cast my vote for BCV. Good, reliable, fast and used by many.

      Though hot cloning using BCV is a trick on the applications side.

      Irfan Momin

    • At 3:53 PM, Blogger Atul Kumar said…

      Hi Irfan,
      Thanks a lot for sharing your views on Backup.
      By BCV you mean Business Continuity Volumens ? As lot of guys going in favour of RMAN , I will update on RMAN or if some one want to update on this post about RMAN mail me at and I 'll give access to you on this site .


    • At 9:07 PM, Blogger Prakash said…


      Would like to know what need to do in order to do BCV backup of RAC (2-node) database on Solaris.


      Prakash Patel

    • At 9:08 PM, Blogger Prakash said…


      Woild like to know what need to take care on implementation of BCV backup of RAC (2-node) database on Solaris server.


      Prakash Patel

    • At 7:58 AM, Anonymous Anonymous said…

      I'm new to oracle, what is redo logs and why there are 3 controlfiles in database? I mean is it possible to create more than 3 ctlfiles? Thanks

    • At 6:17 AM, Blogger Shahrukh said…

      hi Atul

      I am working on R12 on DUAL nodes and upgrade to 12.0.2, i need to configure RMAN, but i need the proper scripts which can be ideal for Production environment, and secondly please let me know that how can we use RMAN backups with SAN as Storage?

      Shahrukh Yasin

    • At 9:06 AM, Blogger Amruta said…

      Can any one let me know the meaning of the following???

      Cloning with RMAN:-
      "If you are doing a hot cloning of your instance you can use RMAN do to the database cloning and then run adcfgxlone with the DBTeckStack option, as part of your Oracle Applications cloning"
      especially what is "hot cloning" and DBTechStack option??

    • At 10:50 AM, Blogger lalit said…

      Hi Atul,

      Can you please tell me how can iu take the automatic backup in the pracle applications.

      Please provide me any script regarding this.


    • At 7:59 PM, Anonymous backup system said…

      Thanks for all the useful information!!

    • At 8:17 PM, Anonymous System Backup said…

      which way is the shortest and quickest way to back up?

    • At 6:58 AM, Anonymous Data recovery said…

      Its really a great post about backup & recovery in oracle apps database.

      Data recovery is the process of recovering lost data that cannot be accessed normally from storage devices like hard disk drives, CD's, DVD's and storage tapes.

    Post a Comment
    << Home
    About Me

    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Only search this Blog
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Add On

    Add to Technorati Favorites



    Add to Google


    Add to My AOL


    Subscribe in Bloglines


    Subscribe in NewsGator Online

    Powered by

    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Copyright © 2006 All rights reserved Presented by Atul Kumar