Re: My RMAN script of full backup

From: joel garry <joel-garry_at_home.com>
Date: Sun, 29 Apr 2012 12:26:08 -0700 (PDT)
Message-ID: <5a9854a1-0b17-4f4f-b564-a86c153cb267_at_e42g2000yqa.googlegroups.com>

On Apr 29, 6:17 am, John Hurley <johnthehur..._at_gmail.com> 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!

jg

--
_at_home.com 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