Category Archives: RMAN

Oracle Interactive Quick Reference

Remember those enormous posters of Oracle’s data dictionary views you used to see in DBA shops?

Here’s the Oracle 12c Interactive Quick Reference – more interactive and less need for pulp.

The Oracle 11g Interactive Quick Reference can be downloaded from here.

 

 

Tagged , , ,

DBA, DMA, DBMA, other?

Quite some time ago, I read a fascinating article, co-written by easily the best Oracle instructor I ever had the pleasure of being taught by in Joel Goodman, which talked about the skills required to be a “DBA 2.0”.

They even mentioned Exadata needing its own “version”, though they suggested it would be “DBA 2.1”. I’m not sure Exadata had made it out into the wild at this point.

The article was written five or six years ago and was tremendously prescient. With the data industry at such a fascinating crossroads with Big Data, engineered systems and extreme performance, how will the DBA role change to keep up with the demands of the ever-increasing volume and mission-critical exploitation (hopefully the beneficial kind) of enterprise data?

Continue reading

Tagged , , , , , , , ,

Calling FLASHBACK DATABASE from RMAN

Recently, I discovered a cool tweak that I really should have known about before now, given the number of times I’ve performed FLASHBACK DATABASE in the past.

You are probably aware that in order to FLASHBACK DATABASE, not only do you need the Flashback logs, but the corresponding archive logs must also be accessible.

Continue reading

Tagged , ,
%d bloggers like this: