<div>
Thanks John!<br />
<br />
I'll try this and let you know. 
</div>


Thanks John!

I'll try this and let you know.

<div>
<div class="content wysiwyg-content">
I had a primary database and two physical standby databases in a Data Guard configuration.<br />
<br />
I already disconnected one of the standby from the DG configuration using the following...<br />
<br />
<br />
-- on priamry<br />
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=D<wbr />EFER;<br />
<br />
--standby<br />
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;<br />
Shutdown immediate;<br />
<br />
What are the next steps to make this &nbsp;as a single fully operational DB?<br />
<br />
<br />
Thanks,<br />
~sve<br />

</div>
</div>


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


DataGuard | How to Make Standby as an Independent DB?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.