oracle设置自动归档,启用Oracle自动归档模式

1.创建保存备份的目录

mkdir /u01/Oracle/oradata/archive/archive

chown -R Oracle /u01/oracle/oradata/archive/archive

2. 切换到Oracle用户

sqlplus /nolog

connect /as sysdba

3. 设置归档日志 目标地址

查看数据库是否在归档模式

-

SQL> select log_mode from v$database;

LOG_MODE

------------------------

NOARCHIVELOG

SQL> show parameter 'log_archive_dest_1'

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_1                   string

log_archive_dest_10                  string

log_archive_dest_11                  string

log_archive_dest_12                  string

log_archive_dest_13                  string

log_archive_dest_14                  string

log_archive_dest_15                  string