切换10g归档日志导致的ora-16179和ora-32017

SQL> shutdown immediate
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

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博客 ” ，链接：http://blog.itpub.net/14673072/viewspace-622268/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14673072/viewspace-622268/