At a certain Bank someone unknown deleted a database file. In that situation the Standby on the same box would be ideal. Financial trading needs rapid failover. The same thing happened the next day ! (Double ouch) I think there was a string of redundancies at the time. On 03/02/2009, Maureen English <sxmte@xxxxxxxxxxxxxxxx> wrote: > I agree with the other comments regarding having a standby that is > planned for use as a failover on a different box. However, we've > been considering having a logical standby on the same box, where its > purpose would be simply a reporting database. > > - Maureen > > > Howard Latham wrote: >> Oracle 10g and 11g. >> >> REDHAT LInux >> >> I have just been told by a consultant that a standby on the same box >> as a primary is not recommended.(We also have a standby on another >> box) My feeling is that will speedup a rebuild should we ever have to >> switch over and switch back.Any views? >> >> >> > > -- Howard A. Latham -- //www.freelists.org/webpage/oracle-l