09/05/2020

Name: dbInternals
Telephone: +

dbInternals dbInternals
/
2020
/
September
/
05

The Importance of DBA_ROLLBACK_SEGS – Recovery

September 5, 2020 Backup Recovery

OK, I have successfully opened my database. I am in a lot better position than I was I was a few days ago. But what about my priceless Dilbert collection? It is not like I could just go to dilbert.com and download them again, could I? SQL> select count(*) from dilbert; ORA-00604: error occurred at Read More »

The Importance of DBA_ROLLBACK_SEGS – 3 of 4

September 4, 2020 Backup Recovery

Does anyone notice a pattern here with the post titles? Anyway, I was loading my priceless collection of Dilbert strips into my database when it crashed and burned: Trying to restart the database, my undo tablespace is gone: SQL> startup ORACLE instance started. Total System Global Area 2499805184 bytes Fixed Size 2927480 bytes Variable Size Read More »