Thursday, January 17, 2013

ORACLE - ARCHIVE LOG & NOARCHIVE LOG

How to setup archivelog and noarchivelog database ?

Set archive log file location and format at spfile:
alter system set log_archive_format ='arch_%t_%s_%r.arc' scope=spfile;
alter system set log_archive_dest_1 ='location=/ArchLog/oracle/JDB/arch'scope=spfile;

or
alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST';

Startup database with mount option:
shutdown immediate;
startup mount;
alter database archivelog ; or [alter database noarchivelog ;]
alter database open ;


Verification:
1) archive log list;
2) show parameter log_archive
3) select log_mode from v$database;
LOG_MODE
-------------------------
NOARCHIVELOG

No comments:

Post a Comment