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_at_hotpop.com Cc: oracle-l_at_freelists.org 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_at_hotpop.com> 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_at_gmail.com>

  Oracle8i & 9i Certified DBA from China

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