Re: Cheap Cheap Database Recovery

From: <>
Date: Sun, 22 Feb 2009 11:11:19 -0800 (PST)
Message-ID: <>

On Feb 22, 8:19 am, pitufo <> wrote:

jgar:>   Everyone needs to learn, but not with production, and not on production without understanding the basics

> That's exactly why I want this to work....I don't want to learn rman
> now, I want to have a D/R I can trust, and I thought that a 'golden
> oldie' would give me a safety net so I could spend time in a test
> environment playing with rman and understand its complexity before
> putting in production.

Makes sense to me. The only basic that you seem to have not completely grasped is that a complete cold backup of a database in archivelog that includes the control files ... online logs ... etc ... along with database files of course ... is good to go from a recovery standpoint using only that plus future archivelogs.

It may not be efficiently exactly esp with lots of archivelogs to apply ...

> The real problem here is the inconsistency,
>  I am waiting for Oracle Support, and see if they find the culprit of
> this problem, I'll post any result I get.

Lots of opinions here about the quality of Oracle Support in the last several years. It used to be so good but that was a long time back now.

Don't hold your breath in other words ... most of us are used to the self service approach.

> I really appreciate the efforts of all of you. Thank you very much!

We appreciate someone making the effort that you are. I think several people including me were thrown off initially by what you were doing with extra control file backups and restores of those backups. Received on Sun Feb 22 2009 - 13:11:19 CST

Original text of this message