SQL> show parameter db_recover;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_recovery_file_dest string
/opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size big integer
20G
------------------------------------ ----------------------
VALUE
------------------------------
db_recovery_file_dest string
/opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size big integer
20G
修改db_recovery_file_dest_size大小为500G
alter system set db_recovery_file_dest_size=500G scope=spfile(需要重启DB生效)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26442936/viewspace-719348/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26442936/viewspace-719348/