Re[1] : Recovery Scenarios - Help !!

Hi Peter , thanx a lot for ur reply.
>>Case 1
>>------
>If you lose the undo tablespace the instance will crash, after the recovery of the undo tablespace
>(asuming that you hae a backup and can appliy archive and redologs) >when the database starts it
>will do instance recovery and rollback all uncommited transactions.

When UNDO tablespace is lost , where from does oracle get the information to rollback ? This is not very clear to me.

>>Case 2
>>------
>>I have lost my temp tablespace during a batch job which does lot of sort/update.
>>- What will be the status of my batch job and how do i recover by temp tablespace now ?

>This depends on the way you have written the batch program :
>1) If the batch program detects the problem and issues a rollback of the last uncommitted transaction and stops you don't
> have a problem :-)
>2) If the batch program just quits on error then Pmon will do the rollback of the uncommitted transaction.

So anyway , the transaction will be rolled back and i'm safe . am i right ?

>>Case 3
>>------
>>I have lost an un-archived online redo log file.The proper recovery procedure is :
>>- restore all datafiles from backup
>>- mount the database
>>- recover until cancel
>>- open resetlogs
>>
>>Without restoring datafiles from backup,Can i do this :
>>- mount the database
>>- recover until cancel
>>- open resetlogs

when i recover/resetlogs without restoring the datafiles from backup , the database will be inconsistent state ... am i right ?

Thanks and Regards,
Prem.

--
http://www.freelists.org/webpage/oracle-l