切换10g归档日志导致的ora-16179和ora-32017
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 2020224 bytes
Variable Size 88083584 bytes
Database Buffers 192937984 bytes
Redo Buffers 2170880 bytes
Database mounted.
SQL> alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION = /opt/oracle/ora_data/flash_recovery_area' scope=both;
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION = /opt/oracle/ora_data/flash_recovery_area' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
Fixed Size 2020224 bytes
Variable Size 88083584 bytes
Database Buffers 192937984 bytes
Redo Buffers 2170880 bytes
Database mounted.
SQL> alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION = /opt/oracle/ora_data/flash_recovery_area' scope=both;
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION = /opt/oracle/ora_data/flash_recovery_area' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
SQL> alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=/opt/oracle/ora_data/flash_recovery_area' scope=both;
System altered.
SQL> alter database open;
Database altered.
由于alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION = /opt/oracle/ora_data/flash_recovery_area' scope=both;
存在空间，所以造成更改归档目录失败
存在空间，所以造成更改归档目录失败
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14673072/viewspace-622268/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
重做日志损坏，故障处理
下一篇：
在线重做日志损坏，故障恢复
请登录后发表评论
登录
全部评论
