Oracle archlog 啟用/關閉

Oracle archlog 啟用/關閉

立即關閉 Oracle
shutdown immediate;

目前 archlog 模式
SELECT LOG_MODE FROM V$DATABASE;

關閉 archlog

01. Connect as sysdba
sqlplus “/as sysdba”

02.Confirm connected database
SQL> show parameter db_name;

03.Check current log_mode i.e. (Archivelog or Noarchivelog) of database (Before change) {output should be ARCHIVELOG}.
SQL> select log_mode from v$database;

04.Check current archive status
SQL> archive log list;

05.Shutdown database
SQL>shutdown immediate;

06.Start database again with Mount option
SQL>startup mount;

07.Change database to Noarchivelog mode
SQL>alter database noarchivelog ;

08.Open database
SQL>alter database open ;

09.Stop automatic archive process
SQL>alter system archive log stop ;

10.Check current log_mode i.e. (archivelog or noarchivelog) of database (After change) {output should be NOARCHIVELOG}.
SQL> select log_mode from v$database;

啟用 archlog

01.Shutdown database
SQL>shutdown immediate;

02.Start database again with Mount option
SQL>startup mount;

03.
archive log start;

alter system archive log start;

#alter system set log_archive_start=true scope=spfile;

03.Change database to Archivelog mode
SQL>alter database archivelog;

04.Check current log_mode i.e. (archivelog or noarchivelog) of database (After change) {output should be NOARCHIVELOG}.
SQL> select log_mode from v$database;

05.Show archlog list 有產生
archive log list;

05.切換 logfile
alter system switch logfile;