You CAN do this, and it is no longer a standby database. Before 10G, you
would subsequently need to recreate the standby database from scratch. With
10G, if you have flashback enabled, then you can open the database in
read-write, do whatever you need to, then flashback the database to a point
in time BEFORE you opened it, set it back to standby and it will resync
itself through the redo logs from the source database.

Its pretty neat, but give it a go on a test database first to make sure you
know what needs to be done.

John.

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

-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.

Oracle LazyDBA home page