变更归档路径遇到的ORA-32017and ORA-16179

最新推荐文章于 2025-03-26 17:34:11 发布

原创最新推荐文章于 2025-03-26 17:34:11 发布 · 1.4k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#archive #system #sql #integer #string

ora-erro 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了Oracle数据库中归档模式的配置方法及查询归档状态的步骤。首先展示了如何通过SQL命令查看数据库是否处于归档模式及当前的归档设置。接着详细解释了更改归档路径的具体操作，并给出了正确的SQL命令示例。最后，提供了查询当前归档文件信息的方法。

1、查看数据库归档情况

SQL> archive log list

Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5295
Next log sequence to archive 5304
Current log sequence 5304
SQL> show parameter archive

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string

log_archive_dest_1 string

2、更改归档路径

SQL> alter system set log_archive_dest_1='/opt/app/oracle/arch' scope=both;
alter system set log_archive_dest_1='/opt/app/oracle/arch' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating BOTH
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with BOTH

添加关键字 location 即可

SQL> alter system set log_archive_dest_1='location=/opt/app/oracle/arch' scope=both;

System altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/app/oracle/arch
Oldest online log sequence 5295
Next log sequence to archive 5304
Current log sequence 5304

3、查看当前归档信息

SQL> select name,sequence#,first_change# from v$archived_log;