Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Restore from hot backup without undo tablespace
- Thread starter sem
- Start date
SantaMufasa
Technical User
Sem,
Yours is a very good question. My initial reaction is that Oracle needs the UNDO tablespace to apply recovery data. Oracle expects to apply REDO data to all tablespaces (including UNDO) from the ARCHIVE and ONLINE REDO log files.
Sem, can you afford the luxury of restoring your backup files and use your current UNDO tablespace file, then issuing a "RECOVER DATABASE" command as a test? If this is a real (versus test) recovery operation, you will be no worse off than you are presently.
Let us know your findings.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
@ 17:47 (08Feb05) UTC (aka "GMT" and "Zulu"),
@ 10:47 (08Feb05) Mountain Time
Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.
Yours is a very good question. My initial reaction is that Oracle needs the UNDO tablespace to apply recovery data. Oracle expects to apply REDO data to all tablespaces (including UNDO) from the ARCHIVE and ONLINE REDO log files.
Sem, can you afford the luxury of restoring your backup files and use your current UNDO tablespace file, then issuing a "RECOVER DATABASE" command as a test? If this is a real (versus test) recovery operation, you will be no worse off than you are presently.
Let us know your findings.
Mufasa(aka Dave of Sandy, Utah, USA)
@ 17:47 (08Feb05) UTC (aka "GMT" and "Zulu"),
@ 10:47 (08Feb05) Mountain Time
Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.
- Thread starter
- #3
Dave, I asked that because after RECOVER DATABASE I've got a warning about fuzzy backup, then ora-322, ora-312. Thus I'm still unable to open database. Do you know anything better than switching to undo_management=manual and recreating the file?
Regards, Dima
Regards, Dima
SantaMufasa
Technical User
Frankly, Sem, because of these types of "challenges" that UNDO tablespaces present, I do not use them. I find that manual rollback segments are perfectly satisfactory for my needs.
I have no personal experience with your scenario, so I would just be guessing. The problem I anticipate is even if you set your parameter to "undo_management=manual", if your database cannot open because it needs recovery, how can you create manual rollback segments?
Mufasa
(aka Dave of Sandy, Utah, USA)
@ 18:43 (08Feb05) UTC (aka "GMT" and "Zulu"),
@ 11:43 (08Feb05) Mountain Time
Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.
I have no personal experience with your scenario, so I would just be guessing. The problem I anticipate is even if you set your parameter to "undo_management=manual", if your database cannot open because it needs recovery, how can you create manual rollback segments?
Mufasa(aka Dave of Sandy, Utah, USA)
@ 18:43 (08Feb05) UTC (aka "GMT" and "Zulu"),
@ 11:43 (08Feb05) Mountain Time
Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.
- Status
Similar threads
- Locked
- Question