Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Steps to Refresh test enviornment from Prod

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    Steps to Refresh test enviornment from Prod

    Please guide us about the steps to refresh Test Env(Dual node) from Prod Env (Multinode architecture)? Please list it once.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    The exact steps would depend on the configuration of the Production and Test environment.

    A) You need to consider your Production - Is it 2 node 1 node DB and 1 node Apps , or is it 1 node db and 1 node apps , or is it 2 node db and 2 node Apps.
    Is the test environment server architecture the same as the Prod Architecture.


    On the Source Database node execute the source Database steps as given in the thread relating to Cloning Steps.
    On the Target Database node execute the Target Applications steps as given in the thread relating to Cloning Steps.
    We need to consider If its RAC to Non RAC , or RAC to RAC

    On the Source Applications node execute the source Applications steps as given in the thread relating to Cloning Steps.
    On the Target Applications node execute the Target Applications steps as given in the thread relating to Cloning Steps.

    B) Also need to see if its Multi Node Applications Tier to Single Node Applications Tier or Multi.
    Does the source have a Shared APPL_TOP or a distributed one.
    If its Multi to Single and Distributed APPL_TOP on source , you would also need to merge the APPL_TOPs

    For Cloning/Post Clone 11i / R12 :
    =========================
    Clone-ie-Refresh-Oracle-Applications-11i-R12
    Post-Refresh-Clone-Checks-Procedures-for-11i-R12

+ Reply to Thread

Similar Threads

  1. How to test SMTP and IMAP for the Workflow Notification Mailer
    By Hemant in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 07-04-2012, 12:43 AM
  2. Steps to Rename RAC instance name
    By devesh_ocp in forum RAC Concepts and Administration
    Replies: 0
    Last Post: 04-26-2012, 11:11 AM
  3. Test/Development Database Refresh From Production Procedure
    By devesh_ocp in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 04-25-2012, 10:23 AM
  4. Materialized Views,Complete and Fast Refresh in 11g Oracle Database
    By ajaychandi in forum Database Performance Management,Database Links,Materialized Views
    Replies: 0
    Last Post: 01-12-2012, 11:03 PM
  5. What are the Set up Steps for AP and GL
    By ajaysingh in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 1
    Last Post: 10-25-2011, 07:25 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics