1、现在系统中给归档日志建一个存储目录

[oracle@zhang\:/export/home/oracle]$mkdir /software/cold_backup/

2、查看一下数据库是否启用归档模式

idle>archive log list;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch

Oldest online log sequence 20

Current log sequence 22

可以发现自动归档处于disabled状态

3、指定归档日志的路径

idle>alter system set log_archive_dest='/software/cold_backup/';

System altered.

4、确保库不在open状态，更改日志模式为归档模式

idle>alter database archivelog;

Database altered.

5、查看数据库是否处于归档模式

idle>archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /software/cold_backup/

Oldest online log sequence 20

Next log sequence to archive 22

Current log sequence 22

可以看到数据库自动归档处于enabled状态

至此，打开数据库

ITPub博客

开启数据库归档模式