| Crash Recovery [message #62694] |
Mon, 09 August 2004 21:26  |
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
|
|
|
|
| Re: Crash Recovery [message #62698 is a reply to message #62694] |
Tue, 10 August 2004 02:26  |
Gorjan Todorovski
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
this is possible if there was not open transaction in the moment of
instance crash. Otherwise the DB would not open, the instance will
crash after mouting and before open.
-----
www.oracleclinic.com
|
|
|
|
| Re: Crash Recovery [message #62702 is a reply to message #62694] |
Tue, 10 August 2004 04:09 |
Gorjan Todorovski
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
If you have ora 9i or 10g and automatic undo management is set. You
can:
SYSTEM@hello > alter system set undo_tablespace=UNDOTBS1;
This will ensure usage of UNDOTBS1 tablespace.
If you have 8i, create rollback segment(s) in that tablespace, and make
sure that they are online.
Only SYS/SYSTEM users can use the SYSTEM rollback segment so if
there is no avaible rollback segment there will an error of the type that
you can not user system rollback segment.
-----
www.oracleclinic.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
