Creating a Physical Standby Database
(Doc ID 1475344.1)
Last updated on APRIL 26, 2021
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 126.96.36.199 [Release 10.1 to 12.1]
Oracle Net Services - Version 188.8.131.52 to 184.108.40.206 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
** checked for relevance '7-Jul-2015' **
This Document shows the various Possibilities to create a Physical Standby Database on Oracle Database 11.2.0.x.
It should be seen as an Addition and Clarification to the Documentation. You may also review
Oracle® Data Guard, Concepts and Administration, 11g Release 2 (11.2), E25608-0x
Chapter 3: Creating a Physical Standby Database
Appendix E: Creating a Standby Database with Recovery Manager
which is the Base for this Document. We take an Example Database and show the various Methods to create the Standby Database. Note that only the basic Concepts are shown. Further more complex Scenarios are possible as well, of course. Take a Look into the corresponding Documentation to get the deeper Insight.
Would you like to explore this Topic further with other Oracle Customers, Oracle Employees and Industry Experts ??
You can discuss this Note, show your Experiences or ask Questions about it directly right at the Bottom of this Note in the Discussion Thread about this Document.
If you want to discover Discussions about other Articles und Subjects or even post new Discussions you can access the My Oracle Support Community Page for High Availability Data Guard
This Document is intended for System Adminstrators planning to setup a Standby Database. Depending on the Needs and Prerequisites on the existing Environment you can choose any of the mentioned Ways to create the Standby Database and Data Guard Environment.
Note that this Note does not cover Setting up Log Transport and Log Apply Services in Detail - we take the basic default Setup here. The same is true for the RMAN Environment in Case where different Backup Types and Scenarios are possible. We just try to show the basic Concept here.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Prerequisites and Assumptions to get started|
|Preparing the Environment and Standby Instance|
|Create the Physical Standby Database|
|Creating a Standby Database via User Managed Backups|
|Creating a Standby Database using RMAN (Backup based)|
|Creating a Standby Database using RMAN without Backup (from active Database)|
|Post-Creation Steps to make the Data Guard Environment operational|
|Optional additional Steps|