ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" t
Hi All,
I did a RMAN RESTORE AND RECOVER DATABASE..
everything was going fine until it hit the error:
ORA-01555 caused by SQL statement below (SQL ID: 7bd391hat42zk, Query Duration=0 sec, SCN: 0x09e0.ec2c129a):
Sat May 21 19:31:06 2011
select /*+ rule */ name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1
Sat May 21 19:31:06 2011
Errors in file /u01/oracle/OraHome_1/admin/patriadb/udump/patriadb_ora_5553.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" too small
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 5553
ORA-1092 signalled during: alter database open...
any ideas?
what I have done:
1). Tried User managed recovery ( UNTIL CANCEL): didnt work
2). reset Incarnation key to latest: didnt work either.
I looked at this note: ORA-604 & ORA-1555 Rollback Segment 0 With Name "System" Too small [ID 862469.1]
but the db is not open so cannot run the sql's
anything else to try?