You are here

You are here:

Blog: Medium Images

Oracle Error ORA-376 encountered while recovering transaction (A, B) on object YYYY.

Posted by PDSERVICE December 07, 2015 0 comments

oerr ora 376
00376, 00000, "file %s cannot be read at this time"
// *Cause:  attempting to read from a file that is not readable. Most likely
//          the file is offline.
// *Action: Check the state of the file. Bring it online

More

ORA-1546: tablespace contains active rollback segment '<rbsname>'

Posted by PDSERVICE December 07, 2015 0 comments


The named tablespace contains an active rollback segment as named
in the error.

Actions:

1. Offline the named rollback segment:
eg: ALTER ROLLBACK SEGMENT  OFFLINE;

2. Re-attempt to offline the tablespace

More

ORA-1545 during DROP ROLLBACK SEGMENT <rbsname>

Posted by PDSERVICE December 07, 2015 0 comments

ORA-1545 may be signalled during a "DROP ROLLBACK SEGMENT" if the
rollback segment is currently online.
eg: SVRMGR> drop rollback segment rprbs;
drop rollback segment rprbs
*

More

DBA_ROLLBACK_SEGS entry of status "NEEDS RECOVERY" or "PARTLY AVAILABLE"

Posted by PDSERVICE December 07, 2015 0 comments

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DBA_ROLLBACK_SEGS entry of status "NEEDS RECOVERY"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The DBA_ROLLBACK_SEGS view shows a rollback segment as "NEEDS RECOVERY"
if Oracle cannot see the rollback segment header or if there is a problem...

More

Pages