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:
good keep it up. help every body .
Post a Comment