urgent wanna do a startup force

[hrishy]

Shutdown abort does not cause data loss, unless your talking about uncommitted transactions.

a friend of mine made this statement .is he right or wrong

[pando]

do you refer my post?
shutdown abort = instance failure and in instance failures oracle does instance recovery automatically so you loose only uncomitted data

[hrishy]

yaeh thanks a lot pando that clears my confusion being a dba for almost 2 years its only now i realised that shutdown abort si only instance failure .tahnks a lot for your info.but one last question does this mean that a

"media recovery may never be required" if i do a shut down abort.

[pando]

never unless your instance failure is caused by a power cut and your disk fries

[hrishy]

hey tahnks a lot pando you cleared hell lot of confusion of mine .