数据库open报错ORA-01555: snapshot too old
时间:2022-03-10 17:51
原文博客链接地址:
今天正在东莞蜜月的时候,一个学生说他管理的测试库出问题了,无法open,我们先来看看是什么问题:
SQL> create spfile from pfile=‘/tmp/1.ora‘; File created. SQL> startup mount ORACLE instance started. Total System Global Area 4275781632 bytes Fixed Size 2260088 bytes Variable Size 989856648 bytes Database Buffers 3271557120 bytes Redo Buffers 12107776 bytes Database mounted. SQL> alter database open; Database altered. SQL> |
处理完成之后alert log不再抛出任何错误。
数据库open报错ORA-01555: snapshot too old,布布扣,bubuko.com