Re: How to turn on Archive redo log mode for 10g

Hi,
Thanks for the info, so the archive log will start automatically every instance 
start?

regards,

Sin
  ----- Original Message ----- 
  From: Leyi Zhang 
  To: all_about_oracle@xxxxxxxxxx 
  Cc: oracle-l@xxxxxxxxxxxxx 
  Sent: Thursday, May 26, 2005 11:38 AM
  Subject: Re: How to turn on Archive redo log mode for 10g


  use log_archive_dest_n parameter. 
  log_archive_start is obsoleted in 10g. remove this parameter from your spfile 
or pfile.


  On 5/26/05, Oracle < all_about_oracle@xxxxxxxxxx> wrote:
    Hi,

    Do you guys know how to turn on Archive redo log mode for 10g, 

    I alter my database already, here is my pfile created from my spfile.

    I have this error
    ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or
    LOG_ARCHIVE
    _DUPLEX_DEST

    *.db_name='Ora10g' 

    *.db_recovery_file_dest='C:\MyOracle\product\flash_recovery_area'

    *.db_recovery_file_dest_size=2147483648

    *.dispatchers='(PROTOCOL=TCP) (SERVICE=Ora10gXDB)'

    *.log_archive_dest='C:\MyOracle\oradata\Ora10g\archive' 

    *.log_archive_start=TRUE

    *.undo_management='AUTO'

    *.undo_tablespace='UNDOTBS1'

    *.utl_file_dir='C:\MyOracle\oradata\utl'



    Thanks and Regards,

    Sin



    --
    http://www.freelists.org/webpage/oracle-l




  -- 
  Kamus <kamusis@xxxxxxxxx>

  Oracle8i & 9i Certified DBA from China 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: