[Last Call] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2011-05-08
Medium Priority
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
  • 2
  • 2
  • 2

Accepted Solution

Piloute earned 750 total points
ID: 35720002

>> 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 35

Expert Comment

ID: 35721261
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

ID: 35727441
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 ?
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.


Expert Comment

ID: 35728343
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 35

Assisted Solution

johnsone earned 750 total points
ID: 35728614
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

ID: 35768853
Not entirely sure about controlfile restore

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

830 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