Creating a Physical Standby database from an another existing Physical Standby database

Posted on 2011-05-08
Last Modified: 2012-05-11
We've have a requirement to create a Standby Database for our Oracle 9i Primary Database. We already have one Physical Standby Database for our Primary DB. I would like to know whether this already existing Physical Standby DB can be used to create the new Standby DB because we cannot afford the Primary database downtime for so long(copying the files to Standby site) and we do not have sufficient disk space for RMAN backup too(for creating the Standby using RMAN backup).

 By creating the new Standby Database from an existing Standby Database I mean whether the database files from the latter one can be copied over to the new standby site.
Question by:makk2010
    LVL 7

    Accepted Solution


    >> we cannot afford the Primary database downtime for so long <<

    No need to stop your primary. Use the standby as source for you copy.
    Check this out to have the steps to follow :

    >> we do not have sufficient disk space for RMAN backup <<

    RMAN can copy to a distant host too ;)

    LVL 34

    Expert Comment

    Just to add...

    You do not need to do a special backup of the primary to create a standby database.  You can use your last hot backup.  Restore that as your starting point for you standby.  You will also need to restore the archive logs between the beginning of the backup and when logs start getting shipped.

    I have created a standby with a hot backup many times before.  It works perfectly and I believe it is documented in the manuals.  Even if use the documentation to create a "special" backup for creating the standby, all you are really doing is creating a hot backup.

    Author Comment

    I believe I can copy the existing Standby Database controlfile to the new Standby DB site. Am I right or I need to use the Primary DB controlfile ?
    LVL 7

    Expert Comment

    Up to you to test. Have no idea if it will work or not. I'm tempted to say it should come from the same db as your db copy.

    In the worst case, you still can create a new one from your primary (there's no impact on your primary when doing an 'alter db create controlfile...').

    LVL 34

    Assisted Solution

    Personally, I would recreate a control file from the primary.  No impact to it and no down time required.

    That being said, copying from the existing standby "should" work.

    Author Closing Comment

    Not entirely sure about controlfile restore

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now