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
**********************************************************************


Oracle LazyDBA home page