Re: Question on Shutdown Immediate

Yoon Ha (yoon_ha_at_dayton.saic.com) wrote:
: If you do a SHUTDOWN IMMEDIATE on an instance, I know any uncommited
: transactions get rolled back. Now when the instance is brought back up,
: does the uncommited transactions get rolled forward, or do you have to do
: an instance recovery to have that done?

Neither. A rollback isn't a failure which requires recovery, so there's nothing to recover. You just need to resubmit the transaction.

Cheers,

--
| Dave Schweisguth                     CuraGen Corp., Bioinformatics Dept. |
| dcs_at_proton.chem.yale.edu             New Haven, Connecticut              |
| http://home.earthlink.net/~dschweisguth/         My opinions are my own. |
| For compliance with the NJ Right to Know Act: Contents partially unknown |