Re: Cheap Cheap Database Recovery

From: jgar the jorrible <>
Date: Mon, 23 Feb 2009 10:23:08 -0800 (PST)
Message-ID: <>

On Feb 22, 7:40 pm, pitufo <> wrote:
> John, Thanks, you have explained my situation better and  in fewer
> words.
> Michael,
> RMAN, could be my best weapon, yes,but inconsistency here, where it
> should not be any, makes me think of hidden problems that are not
> obvious, I have to solve it,before trying something new for me like
> RMAN. Or what  is happening here now could also  be happening again
> when using RMAN, or any other more complicated method.
> If I can't fix it now, what guarantees that I will fix it then.
> That's what my logic tells me. I don't see any possibilities of
> corruption in the database, all I am doing (except the "alter database
> backup controlfile to 'binary.control.file" ) takes place in a
> different server...How can I corrupt my production database while
> doing that ?
> thanks,

Google about for "never backup online redo logs" and figure that golden oldie first. What you are doing is the exception to that rule, but there is a reason that some people advise "never never never do that." The reason is, someone eventually will restore them when they are not supposed to, losing data.

When we ask for database version here, we're not talking about backups, but rather that banner that is displayed when you go into sql*plus, like It's more than a little important.


-- is bogus.
“People with I.T. backgrounds tend to be wrong for the job.”
Received on Mon Feb 23 2009 - 12:23:08 CST

Original text of this message