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