 enabling archivelog mode in oracle 10g [message #184023] |
Mon, 24 July 2006 22:52  |
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?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
