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: removal of standby database

Re: removal of standby database

From: <stevedhoward_at_gmail.com>
Date: 19 Apr 2006 10:34:44 -0700
Message-ID: <1145468084.303828.94790@i40g2000cwc.googlegroups.com> 





Before you do that, if you don't care about the standby database being
completely up to date with the primary (or even just close to up to
date), just issue the follwing when the primary is in a mounted state:



alter database set standby to maximize performance;
alter database open;



This will allow the standby to one log behind the primary, or even
completely ignored if you also disable log_archive_dest_state_3.



Regards,



Steve
Received on Wed Apr 19 2006 - 12:34:44 CDT












Original text of this message













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