oracle ora 16179,切换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;

存在空间，所以造成更改归档目录失败