Monday, October 20, 2008

How to run Oracle 9i database in Archive Mode

Steps:
1) Create pfile if the database is started from spfile.
create pfile from spfile;
This will create pfile in the %ORACLE_HOME%/database/pfileSID.ora
or
create pfile='pathname' from spfile;

2) Shutdown the database
shutdown immediate

3) add parameters
log_archive_start=true
log_archive_format='SID%D%T%S.ARC'
log_archive_dest='%ORACLE_BASE%\oradata\archive'

4) Start up the database in mount stage
startup mount;

5) Activate the database to archiving mode
alter database archivelog;

6) Verify the activation
archive log list;

7) Open the database for use
alter database open;

8) Generate the archive log manually
alter system archive log current;

This turns the database in archive log mode.

1 comment:

Anonymous said...

good keep it up. help every body .