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博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-1417796/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-1417796/