| crash scenario [message #181312] |
Sat, 08 July 2006 09:18  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
i have a database oracle9i runing on windows 2000 server, in archive log mode,
suppose the instance crashed and on the way up we found out that the undo tablespace disk id down,
can i do complete recovery or in this case its a cancel based recovery ?
then recreate the undo tablespace ?
thanks
|
|
|
|
| Re: crash scenario [message #181353 is a reply to message #181312] |
Sun, 09 July 2006 02:05  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
|
Not sure what you mean by "disk id down". However, get the disk fixed/online and do a complete recovery. If you've lost the your UNDO files, restore them first and do a complete recovery.
|
|
|
|
| Re: crash scenario [message #181385 is a reply to message #181312] |
Sun, 09 July 2006 12:22 |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
sorry for the typo it was "disk iS down"
but if the instance crash , the data on the undo tablespace is needed on the way up, during rollback stage,
so if i restore a backup undo tablespace how can i get this data ?
so shall i go fir an imcomplete recovery ?
or is there any possible complete recovery ?
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
