启用fast_recovery_area后再禁用
SYS@dev>ALTER SYSTEM SET db_recovery_file_dest_size=’0′ SCOPE=SPFILE;
System altered.
SYS@dev>startup
ORA-19803: Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 – 18446744073709551614)
虽然默认也是0,但重新指定为0后启动的时候报错
必须reset重置才行
SYS@dev>alter system reset db_recovery_file_dest scope=spfile;
System altered.
SYS@dev>alter system reset db_recovery_file_dest_size scope=spfile;
System altered.
还有一种方法就是create pfile,删除这2行启动参数,从pfile启动后再改成spfile.