| Recovery Question: A Tablespace has been dropped [message #58949] |
Thu, 16 October 2003 22:13  |
Junior DBA
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
I am testing my backup and recovery strategy. The scenario is an index tablespace was dropped by accident. I can resotre and recover my database. However, I keep losing my temp tablespace after I open the database for service. I don't know if I miss something when I issue restore and recovery. Can anyone check my recover procedure.
Step 1: SHUTDOWN IMMEDIATE
Step 2: Check my alert log file
I found an index tablespace was dropped at 2003-10-17:11:02:53,
Step 3: Restore control and datafile from the closest backup.
Step 4: STARTUP MOUNT
Step 5: Recover Database
RECOVER DATABASE UNTIL TIME '2003-10-17:11:02:53' USING BACKUP CONTROLFILE;
Step 6: ALTER DATABASE OPEN RESETLOGS;
Thank for your time and assistance.
|
|
|
|
| Re: Recovery Question: A Tablespace has been dropped [message #58952 is a reply to message #58949] |
Fri, 17 October 2003 07:26  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
If only your Index tablespace was dropped, you dont have to restore your backup controlfile. It looks like you have created your temporary tablespace recently and hence your backup controlfile does not have this entry ? and is probably the reason you are not seeing your temp tablespace. You should have recovered using the current controlfile using recover tablespace or recover datafile.
You might have to recreate your temporary tablespace ( again what type of temp tablespace is this ? are you using tempfiles or normal datafiles ?) and then do a controlfile backup , which will act as your base for further recoveries..
-Thiru
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
