Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Standby Dabatase

Re: Oracle Standby Dabatase

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 01 Jul 1999 08:46:20 -0700
Message-ID: <377B8D4C.64973FF7@us.oracle.com>


Ajay

Depends on what you mean by "online standby database". Are you referring to the standby database functionality where a copy of the database is kept on another machine in recovery mode, with archived redo logs being shipped to the other machine and applied? If so, the standby is kept mounted but not open, so it's not really online. Prior to 8i, if you opened the standby it was no longer of any use as a standby. In 8i, you can open the standby in query only mode, then return it to the mounted state.

If you want the "standby" to be online (i.e. people can access it), then you need to look at another approach to copying the data between the two databases such as replication.

HTH. Pete

ajay wrote:

> Hi all, How do I have on-line satnd by database on Windows NT? Thanks
> in advance. ajay

--
Regards

Pete


Received on Thu Jul 01 1999 - 10:46:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US