Home » RDBMS Server » Server Administration » How to start database in archive log mode?
How to start database in archive log mode? [message #58354] Mon, 18 August 2003 06:14 Go to next message
rajmukesh
Messages: 14
Registered: March 2003
Junior Member
Hi,
I have installed Oracle 9i release2 enterprise edition software and created the database. Now how can I run this database in archive log mode?

Also the changes I have made in init.ora file are also not reflecting. Is it bcoz it is making use of spfile.
Tell me how to make changes in parameter file? I want to increase the No. of Processes,Cursors etc.
Re: How to start database in archive log mode? [message #58357 is a reply to message #58354] Mon, 18 August 2003 06:33 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. 
-- in initparamter file set
LOG_ARCHIVE_START=TRUE 
LOG_ARCHIVE_DEST=your_destination     
LOG_ARCHIVE_FORMAT=your_format 

2. clean shutdown the database

3.
-- startup using the initparameter file
-- dont disturb the spfile
-- issue 
startup mount pfile='your pfile';
alter database archivelog;
alter database open;
archive log list; 
archive log all; 

if all of the above goes good, it means everything is OK. you can see archived log files in LOG_ARCHIVE_DEST

4.
-- now since everything is ok, you should reflect these
-- changes to the spfile
-- issue
create spfile from pfile;

5.
-- do a clean shutdown
-- issue
startup
-- this will make use of the spfile by default
6.
-- check whether archive log mode is ON
-- issue
archive log list

Previous Topic: Speed Boosting of the Database Performance
Next Topic: A question about automating listener
Goto Forum:
  


Current Time: Fri Sep 20 06:59:07 CDT 2024