改变oracle 10g 归档日志dest

默认是存放在闪回恢复区里

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2
Next log sequence to archive   4
Current log sequence           4

下面做下修改：

SQL> alter system set log_archive_dest_7 = 'location=/app/oracle/archivelogfile';

System altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /app/oracle/archivelogfile
Oldest online log sequence     2
Next log sequence to archive   4
Current log sequence           4

SQL> alter system archive log current;

System altered.

[oracle@localhost archivelogfile]$ pwd
/app/oracle/archivelogfile
[oracle@localhost archivelogfile]$ ll
total 7312
-rw-r—– 1 oracle oinstall 7474176 Sep  2 11:25 1_4_792343813.dbf

如果想再把dest改为系统默认地址请看下面操作:

SQL> alter system set DB_RECOVERY_FILE_DEST='/app/oracle/flash_recovery_area';

System altered.

SQL> alter system set log_archive_dest_10='location=USE_DB_RECOVERY_FILE_DEST';

System altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     3
Next log sequence to archive   5
Current log sequence           5

SQL> alter system set log_archive_dest_state_7= defer;

System altered.

下面介绍下log_archive_dest_state_n 的几种状态:

对于每一个log_archive_dest_n参数,都有一个对应的log_archive_dest_state_n参数.log_archive_dest_state_n参数用来指定对应的log_archive_dest_n参数是否生效,拥有4个属性值

ENABLE:默认值,表示允许传输服务.

DEFER:该属性值指定对应的log_archive_dest_n参数有效,但暂不使用.

ALTERNATE:禁止传输,但如果其他相关的目的地址的连接通通失败,则它将变成enable.

RESET:功能与DEFER属性类似,不过如果传输目的地之前有过错误,它会清楚其他所有错误信息.