Archive Log Mode

檢查 Archive Log Mode 狀態

關閉時：

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2178
Current log sequence           2180

SQL> select log_mode, open_mode, name from v$database;

LOG_MODE     OPEN_MODE  NAME
------------ ---------- ---------
NOARCHIVELOG READ WRITE WIN 

開啟時：

第一次啟用 Archive Log