Oracle uses the following parameters for undo tablespace.
UNDO_MANAGEMENT If AUTO, use automatic undo management. The default is MANUAL. UNDO_TABLESPACE An optional dynamic parameter specifying the name of an undo tablespace. This parameter should be used only when the database has multiple undo tablespaces and you want to direct the database instance to use a particular undo tablespace.
If the undo tablespace gets corrupted, the system will try to rebuild its own or will try to use another undo table in the database. Otherwise the instance will not start. Now create the undo tablespace for this instance and restart the instance. K. Rajkumar
1 comment:
Oracle uses the following parameters for undo tablespace.
UNDO_MANAGEMENT If AUTO, use automatic undo management. The default is MANUAL.
UNDO_TABLESPACE An optional dynamic parameter specifying the name of an undo tablespace. This parameter should be used only when the database has multiple undo tablespaces and you want to direct the database instance to use a particular undo tablespace.
If the undo tablespace gets corrupted, the system will try to rebuild its own or will try to use another undo table in the database. Otherwise the instance will not start. Now create the undo tablespace for this instance and restart the instance.
K. Rajkumar
Post a Comment