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