Recovery Scenarios - Help !!

From: Prem Khanna J <premj_at_rediffmail.com>
Date: 29 Nov 2004 05:39:59 -0000
Message-ID: <20041129053959.11734.qmail@webmail30.rediffmail.com>

Friends,
I have got some questions regarding recovery. Let us assume i have full backup of the database with all archived logs.It's oracle 9.2.0.4/Aix5L.

Case 1

---

I have lost my undo tablespace during a batch job which does lot of update.

• What will be the status of my batch job now ?
• How will my transaction be rolled back if the undo tablespace is lost ?

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 ?
  • i can drop/create new temp tablespace, but which process takes care of rolling back the transaction and when it happens ? is it PMON that does the job ?

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

I have posted all these questions after RTFM and referring some books.Can someone throw some light on this ?

Thanks in advance.

Prem.

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

Received on Sun Nov 28 2004 - 23:35:03 CST