ORA-01220故障

今天做数据库恢复的时候报错ORA-01220，查看错误提示发现是因为SORT_AREA_SIZE设置过小导致的。

ORA-01220 file based sort illegal before database is open

Cause: A query issued against a fixed table or view required a temporary segment for sorting before the database was open. Only in-memory sorts are supported before the database is open.
Action: Re-phrase the query to avoid a large sort, increase the values of the SORT_AREA_SIZE and/or SORT_AREA_RETAINED_SIZE initialization parameters to enable the sort to be done in memory.

查看参数文件，SORT_AREA_SIZE=65536，这个值对于采用veritas来恢复数据库来说是不够的，将该值设为当前的2倍即131072，再执行恢复脚本，运行正常。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14284241/viewspace-324117/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14284241/viewspace-324117/