Solved

DataGuard | How to Make Standby as an Independent DB?

Posted on 2011-09-14
2
399 Views
Last Modified: 2012-05-12
I had a primary database and two physical standby databases in a Data Guard configuration.

I already disconnected one of the standby from the DG configuration using the following...


-- on priamry
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;

--standby
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Shutdown immediate;

What are the next steps to make this  as a single fully operational DB?


Thanks,
~sve
0
Comment
Question by:sventhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 500 total points
ID: 36538033
The only remaining step would be to activate it.

If I remember correctly you need to do:

STARTUP MOUNT
ALTER DATABASE ACTIVATE STANDBY DATABASE;
ALTER DATABASE OPEN;

From there it should be a separate database.  Be aware, that once you do this you cannot go back to a standby without totally recreating the standby.
0
 
LVL 18

Author Comment

by:sventhan
ID: 36538046
Thanks John!

I'll try this and let you know.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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 video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

728 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