oracle -- 設定archive mode

一.修改參數檔
log_archive_start=true
log_archive_dest=E:\oracle\product\10.2.0\oradata\arch
log_archive_format=arch_%s%t%r.arc
二.正常關閉資料庫
conn / as sysdba
immdiate database
三. 啓動archive mode
conn / as sysdba
startup mound
alter database archivelog
alter database open
四. 取得archive log list
archive log list
五. 關閉archive
alter database noarchivelog