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 , , ,

Using THE CLOUD(TM) For Off-Site Backup Media Storage

Recently, a client of mine asked me an excellent question about whether they could use AWS as an off-site storage location for their backup media files.

As I may have previously suggested, I have quite a long list of reasons why I think that running important databases from the cloud is a terrible idea, though if a client does really want to pursue this route, I will naturally oblige and make it work as best as I can.

This particular client’s suggestion, however – which, surprisingly, isn’t something that I’d heard made before – was to move at-rest backup media files to Amazon’s S3 storage instead of putting them on tape and shipping them off-site.

I asked around and did some digging but I couldn’t find anyone who was using THE CLOUD(TM) in this manner. Others are migrating their live database to THE CLOUD(TM) – or, at least, attempting to and becoming very frustrated with it – while others have stood up standby databases in AWS as a “DR-of-last-resort”.

Continue reading

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: