【Oracle ERP Note 】Is you database is running in archive log mode ?

以 sqlplus，在 SQL> 環境下達指令 archive log list  即可確認 DB 的啟動是否是 Archive Log Mode。

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/proddb/proddata/archive
Oldest online log sequence     2355
Next log sequence to archive   2356
Current log sequence           2356
SQL>


Reference

此解決方法完全參考 [1]

1. https://support.ca.com/cadocs/0/CA%20ARCserve%20%20Backup%20r16-ENU/Bookshelf_Files/HTML/oraclewn/index.htm?toc.htm?ow_check_archivelog_mode.htm