Oracle归档参数设置问题

参数:
db_recovery_file_dest
log_archivelog_dest
log_archivelog_dest_n

参数不同同时设置,否则会报错:
SQL> alter system set db_recovery_file_dest='/oradata/flashback_query';
alter system set db_recovery_file_dest='/oradata/flashback_query'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST


SQL> show parameter log_archive 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string
log_archive_dest                     string      /oradata/admin/orcl/archive

修改方法是先将已设置的参数清空(alter system set ...='')
然后即可修改另一个参数。

具体就不说了,下面这篇文章讲的很详细,也引用了很多官方说明:
http://blog.csdn.net/tianlesoftware/article/details/5782655


请使用浏览器的分享功能分享到微信等