Home » 故障处理 » 重置db_recovery_file_dest_size

重置db_recovery_file_dest_size

启用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.

Leave a comment