If your primary database get failed, then just run following command on
standby database and shutdown the database and reopen it.

SQL> Alter database activate standby database;

Above command open the database and run as live database.

Regards
Mahesh Pandey
----- Original Message -----
From: "Lala " <oracledba-ezmlmshield-x91645408.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, April 30, 2007 9:15 PM
Subject: Standby Database


> What will happen in the case of Primary Database failure and I want to
make
> the standby as Primary.
>
> Thanks
> ----- Original Message -----
> From: "Michael Peel "
> <oracledba-ezmlmshield-x30333092.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Monday, April 30, 2007 9:02 PM
> Subject: RE: Solaris And Linux ?
>
>
> > But surely the whole idea of a standby is that it is a copy of the
primary
> > database. If you modify any data then it wouldn't be a standby.
> >
> > You can open in read only mode to query, but I don't think you can open
in
> > read/write. It would defeat the object.
> >
> > Michael Peel
> >
> > -----Original Message-----
> > From: Lala [mailto:oracledba-ezmlmshield-x47160240.[Email address
> protected]
> > Sent: 30 April 2007 16:07
> > To: LazyDBA Discussion
> > Subject: Re: Solaris And Linux ?
> >
> > Hello,
> >
> > Can some one provide any hints on opening a standby database in
READ-WRITE
> > mode ?
> >
> > It tell me that it can be only opened with READ ONLY mode as it has used
> > standby database.
> >
> > Thanks
> >
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > To post a dba job: http://jobs.lazydba.com
> > To Subscribe : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
> > **********************************************************************
> > This e-mail is confidential and may be privileged.
> > It may only be read, copied and used by the intended recipient.
> > If you have received it in error please contact the sender immediately
> > by return e-mail. Please then delete the e-mail and any copies of it
> > and do not use or disclose its contents to any person.
> > **********************************************************************
> > Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
> >
> > AccuRead Limited Registered Number: 3076187 England
> > GSL UK Limited Registered Number: 3333860 England
> > Global Solutions Limited Registered Number: 3189802 England
> > **********************************************************************
> >
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > To post a dba job: http://jobs.lazydba.com
> > To Subscribe : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System for
DCM Shriram Consolidated Ltd. For more information please contact
[Email address protected] or visit http://www.messagelabs.com/email
> ______________________________________________________________________




Confidentiality Notice

The information contained in this communication and any accompanying document(s) is confidential and/or privileged material of DCM Shriram Consolidated Limited & group companies. This information is intended only for the person or entity to which it is addressed. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is unlawful and prohibited. If you have received this message in error and / or are not the intended recipient, please notify immediately the sender or DCM Shriram Consolidated Limited at [Email address protected] and permanently delete the original message. The views expressed in this e-mail message (including any attachments) are those of the individual sender except where the sender expressly, and with authority, states them to be the views of DCM Shriram Consolidated Limited and the same shall be subject to the terms and conditions in governing contract in writing, if any.

Oracle LazyDBA home page