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