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

  • From: "Oracle" <all_about_oracle@xxxxxxxxxx>
  • To: "Leyi Zhang" <kamusis@xxxxxxxxx>
  • Date: Thu, 26 May 2005 12:26:01 +0800

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



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




  -- 
  Kamus <kamusis@xxxxxxxxx>

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

Other related posts: