-
SVRMGR> SELECT STATUS FROM DBA_ROLLBACK_SEGS
2> WHERE SEGMENT_NAME = 'rbs01';
STATUS
----------------
0 rows selected.
-
Check Note:28812.1.
It might solve the problem.
P.S.: IMHO you should not have run that ABORT statement
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
I've read the the doc on Metalink. I think I am just going to restore all the database files from my backup tape, which is going to take forever. Hope and pray that the database comes back up.
Alter database using backup controlfile until cancel;
And see what happens?
What do you think?
-
Originally posted by charlton
I've read the the doc on Metalink. I think I am just going to restore all the database files from my backup tape, which is going to take forever. Hope and pray that the database comes back up.
Alter database using backup controlfile until cancel;
And see what happens?
What do you think?
That's one way to go ahead. I would have set event = "10015 trace name context forever, level 10" in order to see what object Oracle is trying to apply the undo to, i.e, why it needs the RBS(s). Then droping the object(s) will help reuse the RBS(s) because the undo will be released. But it depends on what objects we are taling about.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|