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
    Hot Backup Scripts for database backup and apps backup
    Thursday, September 14, 2006
    Register for R12 upgrade
    Yesterday I discussed about backup Overview & cold backup if you have not gone though it you can read it from

    Yesterday I mentioned that I am going to post about hot backup scripts , here it comes

    Enable Archive Log
    First check if your database is in Archive mode
    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    If you see Automatic archival is enabled that means database is in archive mode . If not then

    SQL>alter system set LOG_ARCHIVE_DEST_1 ='LOCATION=/your/archive/location/arch' scope=spfile;
    SQL>shutdown immediate
    Steps are for database 10g , These commands may vary according to your database version.
    After that for Hotbackup
    Change tablespace mode to begin backup like
    alter tablespace tablespace_name begin backup; 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 )

    SQL>set head off
    SQL>spool beginbackup.sql
    SQL>select 'alter tablespace ' tablespace_name ' begin backup;' from dba_tablespaces;
    SQL>spool off

    This will create file beginbackup.sql with entry for all tablespaces, remove any unnecessary lines & then execute this script into SQL like
    SQL>@beginbackup.sql (Once you execute this script this will put all tablespaces in to begin backup mode)

    Now create backup of your control file in Human Readable format like
    alter database backup controlfile to trace as '/some/path'; you can reuse it by removing comment at beginning & replace them with connect / as sysdba

    1. Copy all your datafiles, redo logs and control file from your database server to backup location.
    after datafiles are copied don't forget to end backup for all tablespace here is the scripts
    SQL>set head off
    SQL>spool endbackup.sql
    SQL>select 'alter tablespace ' tablespace_name ' end backup;' from dba_tablespaces;
    SQL>spool off

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

    This completes your datafiles backup but you still have to backup database software & oracle Applications Middle Tier

    2. Copy database software $ORACLE_HOME from server to backup location
    3. Copy Apps Middle tier all TOPs (APPL_TOP, COMMON_TOP, ORA_TOP)

    TIP: Sometime if you copy application tier while apache is Up , you copy or from $IAS_ORACLE_HOME/Apache/Apache/logs/ and if in restored Instance Apache doesn't start & complain about or already exists , you can simply delete these two files from restored Instance & start Apache Web Server.

    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.

    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 @ 10:12 AM  
    • At 7:46 AM, Anonymous Anonymous said…

      Just want to say Atul u r the best teacher.I'm learning alot from u. God bless ya!!

    • At 2:50 PM, Anonymous Anonymous said…

      Hi Atul

      We do not backup the redologs in hot backup.We backup the archives that are produced during the hot backup.
      Also i did not understand why u want a human readable format of the controlfile? Instead you need to backup your controlfiles with .ctl extension, that is the correct procedure.


    • At 11:22 PM, Blogger Jenrry Renaldi said…

      I try to generate script for begin and end backup, is most efficient:

      set head off;
      spool beginbackup.sql;
      select 'alter tablespace ' || tablespace_name || ' begin backup;' from DBA_TABLESPACES where tablespace_name <> 'TEMP';
      spool out;


      set head off;
      spool beginbackup.sql;
      select 'alter tablespace ' || tablespace_name || ' end backup;' from DBA_TABLESPACES where tablespace_name <> 'TEMP';
      spool out;

      but not understand the part for:
      1. Copy all your datafiles, redo logs and control files .....

      "this copy is a normal os copy: cp *.dbf /u02/hot_backup/oradata"????

      I need your help..

    • At 7:36 AM, Blogger Atul Kumar said…

      Yes it is normal o.s. copy. Make sure you are backing up archives as well generated during this process.

    • At 2:35 PM, Blogger Jenrry Renaldi said…

      Thanks Athul, Your help resolve my big problem. I interest in your criteria about this:

      Is mos efficient create multiples schema 's in oracle database for best manage and monitoring the db and efficient backup and restore process... or

      Install oracle standard for a 5 standard tablespaces.

      I 'm show a presentation for my boss, he propose install oracle standard install, but i not...

      I need your opinion respect to.


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

      what do you mean by multiple schemas here ??

      If you are talking about OATM , OATM in my opinion is better to manage.

    • At 4:32 PM, Blogger Jenrry Renaldi said…

      My English is not good, i from Dominican Republic, speak Spanish...

      I ; m refer to distinct schemas, is a distinct users or (applications) for group your object in the database.

      My work place is a Telecommunication company (ISP as residential telephonic services)

      In Development ambient existing multiples Tablespaces: monitor, commissioning, billing, etc., .., .., .,

      My boss said to production database not take a equal schema, but i not accord with her..

      I write a propose for this to my boss.


    • At 8:35 PM, Anonymous sweta said…

      hi Atul,
      Till now my client was taking oracle application 11i nightly cold backps on tapes. Now we are implementing rman hot backups. But my question is related to applications part . How should i plan for the application backup
      1. Should i take the application file system backup of production every day?
      2.should i bring down the application every night for the file system backup (like currently doing for cold backup)
      3. Shall i take the file system backup every day with out shutting down the application services

      Please guide me what would be your best suggestion for this

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


      1. Should i take the application file system backup of production every day?

      Yes if you want to protect your CM log and output files as these are the only files which you might be interesed in rest others don't change (other log file you should not be interested in , in case of disk failure)

      2.should i bring down the application every night for the file system backup (like currently doing for cold backup)

      Not required , if you hit any issue during apache start after recovery move *.pid file from $IAS_ORACLE_HOME/Apache/Apache/logs

      3. Shall i take the file system backup every day with out shutting down the application services

      Check point 1

      We have moved to so in future kindly contact me on On Line Apps DBA site .

      Forward this site to your friends.

    • At 10:01 AM, Anonymous Anonymous said…

      Hi Atul
      How to copy from one location to another in Windows environment?
      I used COPY command.. but it shows error..
      Pls give the full syntax of those command..


    • At 6:52 AM, Anonymous Anonymous said…

      when we are take hot backup that time datafiles get freezed on same time if my database users doing more transaction on database that time how all data is going in to datafiles.shall we do export of same time.

    • At 6:57 AM, Anonymous nidhi said…

      we cann't put all files in begin backup mode simultaneously.bcause if this is a big database means in terabytes so many archives will generate simultaneously, we can't save t many archives. so we put only single tablespace in backupmode at one time.
      Assume that your database has two tablespaces, USERS and TOOLS. To back up the files for these two tablespaces, first put the tablespace in backup mode by using the ALTER statement as follows:
      SQL>alter tablespace USERS begin backup;After the tablespace is in Backup mode, you can use the SELECT statement to list the data files for the USERS tablespace, and the copy (cp) command to copy the files to the backup location. Assume that the USERS tablespace has two data files—users01.dbf and users02.dbf.
      SQL>select file_name from dba_data_files
      where tablespace_name='USERS';
      $cp /u01/oracle/users01.dbf /u10/backup
      $cp /u01/oracle/users01.dbf /u10/backupThe following command ends the backup process and puts the tablespace back in normal mode.
      SQL>alter tablespace USERS end backup;You have to repeat this process for all tablespaces. You can get the list of tablespaces by using the following SQL statement:
      SQL>select tablespace_name from dba_tablespaces;

    • At 2:26 PM, Anonymous Anonymous said…

      I need your help, I am new dba and need help on backingup archivelog database to tape using.
      How do I do that?

    • At 11:13 AM, Anonymous Anonymous said…

      Atul I have gone through your script. Why do you make a script if you want entaire tablespaces in begin backup mode mode. I think if you want you can go ahead with alter database begin backup nad copy the files one by one.

      Yaa As nidhi said there will be a lot of I/O s and will cause performance issue.

      #### Think about this.

      Please put tablespace in backup mode and copy the datafiles (OS Level) and place the tablespace in end backup. and jump for other tablespace and carry on this till you complete all the tablespaces.

      Nagaraj Chidella

    • At 4:44 PM, Anonymous Anonymous said…

      hi there,

      Is there any way to make this automatic everynight? WE have requirement to create Oracle APps Database from Hot backup every night for reporting purpose. NO Full Application cloning is required, just DB part.

      Thanks a lot in advance.

    • At 11:21 AM, Anonymous chandu said…

      hi atul,
      i have problem in creating a catalog in rman backup, I did created a tablespace
      for catalog and also user but when i issue the command "rman catalog=rman/rman@orcl" it says cant open catalog=rman/rman@orcl.
      plz help me

    • At 7:59 AM, Anonymous Anonymous said…

      wht should be set in parameter file if we go the hotbackup

    • At 10:13 AM, Blogger Braj Kishore said…

      Hi! I think, for 10g Database

      alter database begin backup;

      copy files

      alter database end backup;

      will do the thing.

    • At 6:55 AM, Blogger sudhakar said…

      Hi Atul,

      Can you please explain about the Logical backup of the database with commands?

      Oracle Apps DBA consultant

    • At 8:51 AM, Blogger Vishweshwara said…

      how to take the hotbackup of APPL_TOP, COMMON_TOP, ORA_TOP

    • At 6:11 AM, Anonymous Ravi.K said…

      i think no need to tacke temporary tablespace backup,if we take backup controlfile to trace in hot backup or cold backup.we can create temporary tablespace after opening the database,at the time of recovery it may not ask for temporary tablespace recovery.bcz in controlfile temporary tablespace will add after database opend only.

    • At 6:39 PM, Anonymous Anonymous said…

      HI Atul;

      Your posts are quite informative and helpful;

      I need a confirmation from you on the this backup mode cloning option; IS THIS FOR R12 or 11i?
      Or is it applicable in both areas?


    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