Recovery Scenarios - Help !!
- From: "Prem Khanna J" <premj@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: 29 Nov 2004 05:39:59 -0000
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
