[askdba] Re: Convert Physical Standby into a standalone functional database
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Fri, 24 Sep 2004 15:18:11 +0100
AFAIK.. Here .. Long time But Taking a Bet..
1. User Atlter System to Change Log_archive_dest_n parameters that
Point to your Standby Database.
2. Bring the Standby Database Down.
3. Do a Recovery and Open the database .. U are Up and running.
Cheers
Ganesh R
On Fri, 24 Sep 2004 10:10:24 -0400, Rajesh Puneyani
<rajpuneyani@xxxxxxxxx> wrote:
> Hi Guys,
>
> I have a database configured to work as Physical standby (Oracle 9i,
> win2k). Now the requirement is that without affecting the Primary
> Production database, I need to convert Physical standby database into
> a functional database.
>
> I feel a bit nervous regarding what all parameters to change on both
> the databases to make it possible without bringing down Primary
> database.
>
> Can someone please help me in that.
>
> I appreciate.
> Thanks
>
>
Other related posts:
