一、oracle 10g/11g
1、修改归档日志存放路径:
SQL> alter system set log_archive_dest_10='location=/oracle/oracle10g/log/archive_log';
2、关闭数据库
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down.
3、启动数据mount状态:
SQL> startup mount;
4、修改数据库为归档模式:
SQL> alter database archivelog; Database altered.
5、打开数据库,查询:
SQL> alter database open;
修改日志文件命名格式:
SQL> alter system set log_archive_max_processes = 5;
SQL> alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;