Oracle databases often encounter ORA-01555 totals when using the open process

In the process of database open, select CTime, Mtime, stime from obj$ where obj# =: 1 Statement report ORA-01555 error, database not normal open

In general, a rollback segment is reported, but here Ora-01555:snapshot too old:rollback segment number 0 with name "system" too small reported directly to system (systems rollback segment), which belongs to the Rare cases

Fri June 26 11:47:31 2015
Smon:enabling Cache Recovery
Fri June 26 11:47:31 2015
ORA-01555 caused by SQL statement below (SQL Id:4krwuz0ctqxdt, scn:0x0b41.37629378):
Fri June 26 11:47:31 2015
Select CTime, Mtime, stime from obj$ where obj# =: 1
Fri June 26 11:47:31 2015
Errors in FILE/ORABIN/ADMIN/DOOCRM/UDUMP/DOOCRM_ORA_5046722.TRC:
Ora-00704:bootstrap Process Failure
Ora-00704:bootstrap Process Failure
Ora-00604:error occurred at recursive SQL level 1
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 = 5046722
ORA-1092 signalled during:alter database open resetlogs ...
In the process of database open, select Increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#= : 1 statement escalated ORA-01555, resulting in database open failure

In the database open process, select/*+ Rule */Name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,decode (Inst#,0,null, inst#), the ts#,spare1 from undo$ where US#=:1 statement caused the database open to fail.

Arc0:becoming the ' no SRL ' arch
Sun June 16:08:22 2015
arc1:becoming the heartbeat ARCH
Sun June 28 16:0 8:22 2015
smon:enabling Cache recovery
Sun June 16:08:22 2015
ORA-01555 caused by SQL statement below (SQL Id:7bd391hat42zk, Query duration=0 sec, scn:0x0d27.0a1ce29d):
Sun June 16:08:22 2015
Select/*+ Rule */name,f Ile#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,decode (inst#,0,null,inst#), ts#,spare1 from undo$ where us# =:1
Sun June 16:08:22 2015
Errors in FILE/ORACLE/APP/ORACLE/ADMIN/IBSSCRM/UDUMP/XXXX_ORA_30212428.TRC:
Ora-00604:error occurred at recursive SQL level 1
ora-01555:snapshot too old:rollback segment number 0 with name "S Ystem "too small
Error 604 happened during DB Open, shutting down database
User:terminating instance to Error 604
Instance terminated by USER, PID = 30212428
ORA-1092 signalled database open ...

This type of problem occurs, typically because the object SCN on a base table such as obj$,seq$,undo$ is larger than the current SCN of the database or because transactions on these tables are not committed, and in both cases, the database needs to be recorded in the rollback segment of the corresponding undo, while the corresponding rollback segment exception ( Or because the redo does not roll back normally, causing the above object or rollback segment to be abnormal, a similar situation occurs, typically in this case, you can navigate to block by 10046, and then the cause of the failure uses bbed to modify the SCN or bbed commit the transaction to resolve such problems.

Contact: Mobile Phone (13429648788) QQ (107644445)
Link: http://www.xifenfei.com/5968.html