Shutdown immediate not doing full rollback and starts rollback after restart
I ran a big multiplle tnxs and the used__ublk showed more than 800000 and when i issues shutdown immediate, the db went down after 4 mins and when i started the db and checked if the rollback is done, then i
saw that its still running.
i used this query to check:
select inst_id,state, undoblocksdone, undoblockstotal, undoblocksdone / undoblockstotal * 100 from
gv$fast_start_transactions
Ideally the shutdown immediate should wait for the whole rollback to complete.
Two sets of Steps which i performed and in both the ways i got the same result i.e shutdown immediate did not rollback the pending thx fully and i could see the STATE as recovering in
saw that its still running.
i used this query to check:
select inst_id,state, undoblocksdone, undoblockstotal, undoblocksdone / undoblockstotal * 100 from
gv$fast_start_transactions
Ideally the shutdown immediate should wait for the whole rollback to complete.
Two sets of Steps which i performed and in both the ways i got the same result i.e shutdown immediate did not rollback the pending thx fully and i could see the STATE as recovering in
0