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 10.2.0.1
  • Upgarde DB to 10.2.0.2
  • 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 11.5.10.2
  • 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
    IdM
  • 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 http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Dataguard for Business Continuity
    Sunday, November 26, 2006
    Register for R12 upgrade

    Today I am going to cover Dataguard which is used for business continuity for Oracle Applications 11i including fusion middleware (Using AS Guard). There are two types of standby databases Physical Standby Database & Logical Standby database. Since oracle applications currently support only physical standby database , I am going to cover only physical standby databases.

    Overview of Dataguard & Dataguard Broker
    Dataguard consist of one primary database & one or more standby database where primary & standby databases are connected by sqlnet (How to configure this check in coming posts). These primary & standby database can be monitored by command line (sql) as well from GUI (Graphical User Interface) Tool called as Dataguard broker.

    Important Services in Dataguard configuration
    Two very important services in dataguard configuration are Redo Transport Service & Log Apply Services. In order to keep standby database in synch with primary database ; redo transport service transfer(Pull/Push) redo logs from primary to standby database & Log apply service applies that redo logs to standby database.

    Switchover & Failover
    These are basically two kind of roles in dataguard Failover & Switchover; In Switchover Primary database becomes standby database & one of (If there are more than one standby) standby database becomes primary database for ex. during server maintenance. Failover is used in scenarion in which your primary database is not available and you want to convert role of one of standby database to primary database for ex. during primary database failure.

    Data Protection Mode
    Standby database in dataguard configuration can be configured in any of three protection mode which can be changed later as well depending on your requirement . These protection modes are Maximum Protection Mode , Maximum Availability Mode & Maximum Performance Mode.

    Maximum Protection Mode
    In maximum protection mode as name suggest no data loss will occur if primary database fails. This is achieved by oracle by ensuring that redo data must be written to both local online redo log location & standby redo log location before transaction commits. This standby redo log will ensure full data protection. For full protection mode atleast one standby database should have standby redo log and LGWR, SYNC, and AFFIRM attribute should be used with LOG_ARCHIVE_DEST_n parameter. (I am going to discuss about these parameters in next post)
    Here your primary database will shutdown if it is unable to write redo records to atleast one standby location.

    Maximum Availability Mode
    This is similar to Maximum protection mode except that it will not shutdown primary database if primary database is not able to write standby redo logs to atleast one standby location but in that case Maximum Availability will act in Maximum Performance Mode until fault is corrected and all gaps in redo logs are resolved. Once all gaps are resolved primary database will automatically goes into Maximum Availability Mode.

    Maximum Performance Mode
    This is default mode in which redo stream is written asynchronously with respect to the commitment of the transactions that create the redo data. You can use LGWR and ASYNC attribute or ARCH attribute in LOG_ARCHIVE_DEST_n

    You can check your database mode as

    SQL> select PROTECTION_LEVEL from v$database;
    PROTECTION_LEVEL
    ----------------------------
    MAXIMUM PERFORMANCE

    How to change protection modes..
    How many standby database Instance you can configure ...
    explanation on Log apply, log transport service , FAL Server/Client ....
    Step by step configuration of standby database using dataguard ..

    Coming soon...

    References
    http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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 @ 3:35 PM  
    18 Comments:
    • At 6:44 AM, Anonymous Anonymous said…

      Hi Atul,

      Could you please tell if i can configure Data gaurd set up on my machine alone(primary and stndby on single machine). I know Dataguard needs stndby DB at remote site, but for my learning purpose can i configure dataguard on same machine.

      Thanks,
      Anil

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

      Yes Anil,
      You can very well configure Dataguard on same machine for learning purpose but you need to take care of few things like db_file_convert (Exact syntax I'll take up in a day or two) so that standby database can create file accourding to new mount point.

      Atul

       
    • At 10:03 AM, Anonymous Anonymous said…

      Hi Atul ,

      FYI ONLY : Why Oracle Apps 11i does not support Logical Standby database ?

      Answer : BEcuase Oracle Apps 11i database lot of objects which are not supported by Logical standby database like functional indexes etc etc . Oracle has got plans to improve the logical standby concept in the new release as logical standby database can help in reporting env creation etc

      Thanks

      Vivek

       
    • At 10:28 AM, Blogger Atul Kumar said…

      Vivek,
      Thanks for sharing this with us all.
      I think another big plus with logical standby is that rolling upgrade (Instance available to use for updtes while database upgarde) is supported in logical standby which I suppose will take few more years in physical standby .

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

      Kevin for satndby important thing is software , you can install any type of database as long as software binaries match in primary & standby database .

      Once you bring standby control file, datafile & initialization file from primary to standby , your primary data, initialization & control file will be overwritten ....

       
    • At 10:05 AM, Anonymous Anonymous said…

      Might sound silly but i understand from ur post that data guards are of 2 types and its used for business continuity... but could you please explain what dataguard actually is?? may be by giving an example..

      Thanks

       
    • At 12:51 AM, Blogger Atul Kumar said…

      As mentioned above Dataguard is oracle standby database including two services redo log transport service & redo apply apply service used to keep standby siye in synch with primary site so that in case of any disaster to primary site you can open standby site and use it as primary.

      Atul

       
    • At 4:14 PM, Blogger Bittoo said…

      Hi Atul,
      Can you please guide me to install dataguard on the same machine running on Windows 2000. I am getting error "ORA-01102: cannot mount database in EXCLUSIVE mode"
      when i try to mount standby database.

       
    • At 8:39 PM, Blogger Atul Kumar said…

      Check Note 18676.1

       
    • At 3:48 PM, Blogger hank@ahm said…

      Atul,

      is there someway to setup Primary/Physical Standby without using DG/DGB?

      Thanks a lot,

      hank

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

      Nothing which I am aware of ...

       
    • At 7:06 PM, Anonymous Anonymous said…

      Hi Atul ,

      Did you do this on Oracle apps Env. Am planing to setup DR plan using DG for Oracle apps.

      Thank you
      Sree

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

      Yes, You can setup physical standby databas/dataguard with apps

       
    • At 2:54 PM, Anonymous Anonymous said…

      Hi
      i have a primary and standby setup for oracle 11i apps using oracle note.
      i have a few concerns :
      1)if i am applying 5 patches which are related to each other i feel i must copy all the applications and data ( via redo transfer ) each time after each patch is applied.looks like a tedius task.
      Can you highlight the disadvantages of Dataguard with 11i for DBA ?

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

      For patching on apps with dataguard, apply patch on primary database part will come during sync now you have to sync standyby middle tier file system (for c and g portion)

      Above is for apps patch.

      For Database patch apply it on both primary and standby database.

      For techstack patch - (iAS and Forms) I leave it to you to decide ;-)

       
    • At 11:51 AM, Anonymous gautam wansik said…

      Hi atul

      I am trying to Implement the physical standby for apps 11.5.10.2 from 2 node installation to 1 node.Database part is successfully working but application is not starting after switchover.
      please tell the setps.........

       
    • At 5:17 PM, Anonymous Anonymous said…

      can i configure oracle dataguard between 2 server (pri & standby) with both having same physical ip address? In order for both to share a same physical address, we will perform a Network Address translation between the 2 machine, such that pri server see secondary as another ip address (using NAT) and secondary server see primary as another ip address(using NAT) but both actually had the same physical ip address.please advice.thanks

       
    • At 10:26 AM, Blogger anil said…

      Hi All
      I am hving the 2+y of exp as oracle core dba 9i 10g. but currently in my company i hv put on SAP BA, but when famileared with SAP database, which is oracle. i get that. SAP is not using lost of the importent feature of oracle. it's just like as a simple 8i database. ither it's is 10g. which features are avilable with sap it can say like 8i. by the way..
      i want andvice from all of u guys that what shud i to do, ither i shuld go SAP or oracleAPPS,Fsuion, which on is batter as compare to today's and futer market point..

      thanks..

       
    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 @ onlineappsdba.com

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Search
    Only search this Blog
    Categories
  • 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
    Archives
    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
    Comments
    ADs
    Copyright © 2006 teachmeoracle.com All rights reserved Presented by Atul Kumar