Re: Cheap Cheap Database Recovery
From: jgar the jorrible <joel-garry_at_home.com>
Date: Mon, 23 Feb 2009 10:23:08 -0800 (PST)
Message-ID: <a1c29b7c-7d09-47db-9483-430b6b4adaa8_at_x38g2000yqj.googlegroups.com>
On Feb 22, 7:40 pm, pitufo <vandr..._at_gmail.com> 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,
Date: Mon, 23 Feb 2009 10:23:08 -0800 (PST)
Message-ID: <a1c29b7c-7d09-47db-9483-430b6b4adaa8_at_x38g2000yqj.googlegroups.com>
On Feb 22, 7:40 pm, pitufo <vandr..._at_gmail.com> 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 10.2.0.4. It's more than a little important.
jg
-- _at_home.com is bogus. “People with I.T. backgrounds tend to be wrong for the job.” http://www.nytimes.com/2009/02/08/jobs/08starts.html?_r=1Received on Mon Feb 23 2009 - 12:23:08 CST