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: