Database log mode Archive Mode
Automatic archival Enabled
Archive destination $ORACLE_HOME/dbs/arch
Oldest online log sequence 594
Next log sequence to archive 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string $ORACLE_HOME/dbs/arch
SQL> alter system set log_archive_dest_1='location=/data/oracle/log1/archive_log';
Linux:alter system set log_archive_dest_1='location=/u01/oracle/log/archive_log';
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data/oracle/log1/archive_log
Oldest online log sequence 26
Next log sequence to archive 28
将log_archive_log设置为默认值时,归档目录将会变为?/dbs/arch。
SQL> alter system set log_archive_dest_1='';
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination ?/dbs/arch
Oldest online log sequence 33
Next log sequence to archive 35
Current log sequence 35
SQL> shutdown immediate;
重启数据库后,归档目录变回为闪回恢复区:db_recovery_file_dest指定的目录。
startup mount;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /backup/
Oldest online log sequence 33
Next log sequence to archive 35
Current log sequence 35
总结:归档路径和这三个路径有关系: log_archive_dest_1 >db_recovery_file_dest_1 >$ORACLE_HOME/dbs/arch
优先级如上所示,原来你设置了log_archive_dest_1,然后你又把log_archive_dest_1设置成了默认值,那么归档位置就变成了?/dbs/arch
,但是重启后又会变成db_recovery_file_dest指定的路径。值得注意的是dg的standby库:他的归档路径
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29654823/viewspace-1472766/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29654823/viewspace-1472766/