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 Failsafe and Autoarchivelog mode

Re: Oracle Failsafe and Autoarchivelog mode

From: Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com>
Date: Mon, 20 Jan 2003 22:39:46 GMT
Message-ID: <SU_W9.25532$536.1636873@news2.telusplanet.net> 





James Chappell wrote:



> I've got a 8.1.7 Oracle database associated with OFS. At the moment it

> is running in Noarchivelog mode.

> 

> How do I switch it to Archivelog mode? I am unable to use svrmgrl to

> shutdown and start up the database.

> 

> Thanks in advance, chaps.

> 

>  



from sqlplus as system or sys type "alter database archivelog"



change your init.ora params log_archive_start, log_archive_dest and 
log_archive_format



shutdown and restart the database



hth
Received on Mon Jan 20 2003 - 16:39:46 CST












Original text of this message













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