Home » RDBMS Server » Server Administration » enabling archivelog mode in oracle 10g
icon2.gif  enabling archivelog mode in oracle 10g [message #184023] Mon, 24 July 2006 22:52 Go to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Hai,
I have enabled my database in archive log mode as follows.

shutdown immediate;
--backup the entire database
--set initialization parameter file as 
  log_archive_start=true
  log_archive_format=arch_%t_%s_%r.arc
  log_archive_dest=e:\database\archive
startup mount;

database mounted.
ora-32004:obsolete and/or deprecated parameter specified.

alter database archivelog;

database altered.

alter database open;

archive log list;

database logmode              archive mode
automatic archival            enabled
archive destination           e:\database\archive
oldest online log sequence    6
next log sequence to archive  8
current log sequence          8

select log_mode from v$database;
log_mode
--------
archive log

shutdow immediate;
 --backedup the database
set oracle_sid=orcl
sqlplus/nolog
conn sys/pwd as sysdba
startup 
ora-32004:obsolete and/or deprecated parameter specified.


but whenever i start the database i'm getting this ora-32004 error.My database is 10.0.2.0 version.
What shall i do now? Shall i remove the log_archive_start=true in my pfile?Will it affect anything in the database? After removing this parameter will my database will be in automatic archive log mode or every time i have to enable the archive log mode manually?
Re: enabling archivelog mode in oracle 10g [message #184028 is a reply to message #184023] Mon, 24 July 2006 23:18 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
The log_archive_start parameter is deprecated in Oracle 10g. Unset it.
Re: enabling archivelog mode in oracle 10g [message #184030 is a reply to message #184028] Mon, 24 July 2006 23:23 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
will it affect anything in the database?do i need to enable it everytime or is it automatically enabled ?
Re: enabling archivelog mode in oracle 10g [message #184034 is a reply to message #184030] Mon, 24 July 2006 23:34 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Archiving is automatically started when the database is placed in ARCHIVELOG mode.
Re: enabling archivelog mode in oracle 10g [message #188434 is a reply to message #184023] Fri, 18 August 2006 09:53 Go to previous message
Ramakrishnan.r
Messages: 1
Registered: August 2006
Junior Member
For Enabling the Archive Log
Do the Following steps
1.Shutdown
2.Startup mount
3.Alter database archivelog
4.alter database open

After these steps ur db will be in archive log mode
Previous Topic: Arhive log file suddenly increased
Next Topic: Upgrade patch 9.2.0.1 to 9.2.0.5, could not login
Goto Forum:
  


Current Time: Wed Dec 07 14:22:27 CST 2016

Total time taken to generate the page: 0.10591 seconds