今天做数据库恢复的时候报错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/