Re: My RMAN script of full backup

From: joel garry <>
Date: Sun, 29 Apr 2012 12:26:08 -0700 (PDT)
Message-ID: <>

On Apr 29, 6:17 am, John Hurley <> wrote:
> Joel:
> # You need to understand when to back off and let Oracle do the right
> thing automatically.
> Ummm ... never?

A reasonable viewpoint, considering the consequences of losing data.

> Oracle restart for example obviously one of the worst concepts ever.
> Server reboots for some reason and things startup before the system is
> checked out?

Yes, I've seen the downside of automatonism, though I've never worked with that product.

> I am a firm believer in scripting all the rman backup steps myself
> ( including getting extra copies of control file and spfile ).

Used to do that, but I'm trying to be a good dba 2.0 and use dbconsole for backups. In reality, I take what it generates and make a couple of paranoid mods. Of course I also have other redundancies, including all the old stuff I did myself, for when dbconsole decides to suck a gun.

> Letting oracle make decisions on restoring anything ... not this dba.

Remember, most dba's are less experienced, and many will shoot their own feet. In the end, it is a dba decision, in concert with management SLA's.

I find it encouraging that the OP would at least ask.

> Testing every single step of all recovery actions periodically ... you
> got my vote there dude!


-- is bogus.
"You are receiving this message because your email address is
associated with an unmigrated legacy Blogger account."  - In an email
to one of my spamtrap addresses.
Received on Sun Apr 29 2012 - 14:26:08 CDT

Original text of this message