| Crash Recovery [message #62668] |
Sun, 08 August 2004 21:58 |
ora
Messages: 47
Registered: June 2002
|
Member |
|
|
Hi,
I am using oracle 9i with automatic undo management and undo ts contain only one data file which became unaccessible then i mount the db change the mode of undo to manual, drop the datafile and open the db and it is up.
But the point is, is that db is consistent bcz since i had dropped the datafile so in crash recovery how oracle apllied the rollback segments after rolling forward. Means wht abt that running transactions which were there at the time of abnormal shutdown.
Plz put some light on it.
Ora
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
