Nuances of Oracle Managed Files (OMF) and RMAN

Originally posted on “Databases at CERN” blog

Oracle Managed Files (OMF) have many advantages, but the fact that such files could coexist in the same database with manually added (and named) ones, could sometimes lead to confusion. Situation is made worse by the fact, that there is no straightforward way (at least of which I’m aware of…or rather was – please check the comment of Mikhail Velikikh visible on CERN’s blog) to say if the file is Oracle managed or not. Oracle documentation seems to confirm this:

The database identifies an Oracle managed file based on its name.

Continue reading “Nuances of Oracle Managed Files (OMF) and RMAN”

Which shared memory segments belong to my database instance?

Originally posted on “Databases at CERN” blog

I’ve already described how important is to test your backup strategy and restore/recovery procedures, but while doing so, you could of course encounter some problems, not really related with the recoverability as such. Recently, we’ve got such a problem on our recovery server, at the very beginning of an automatic restore (database name masked):

Continue reading “Which shared memory segments belong to my database instance?”

Design a site like this with WordPress.com
Get started