Caused by: java.sql.SQLException: ORA-01555: 快照过旧: 回退段号 11 (名称为 "_SYSSMU11$") 过小
INFO | jvm 1 | 2013/08/21 12:52:32 | ORA-02063: 紧接着 line (起自 DB_ONLINE)
INFO | jvm 1 | 2013/08/21 12:52:32 |
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
INFO | jvm 1 | 2013/08/21 12:52:32 | at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
INFO | jvm 1 | 2013/08/21 12:52:32 | at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440)
INFO | jvm 1 | 2013/08/21 12:52:32 | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
INFO | jvm 1 | 2013/08/21 12:52:32 | ORA-02063: 紧接着 line (起自 DB_ONLINE)
INFO | jvm 1 | 2013/08/21 12:52:32 |
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
INFO | jvm 1 | 2013/08/21 12:52:32 | at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
INFO | jvm 1 | 2013/08/21 12:52:32 | at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
INFO | jvm 1 | 2013/08/21 12:52:32 | at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440)
INFO | jvm 1 | 2013/08/21 12:52:32 | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
应用中突然曝出上述错误,应该是undo段设置太小,或者保留时间过短。
修改undo保留时间为3小时。
ALTER SYSTEM SET undo_retention=10800 SCOPE=BOTH;