Re: Oracle 10g backup/restore
Date: Mon, 23 Feb 2009 10:03:45 -0800 (PST)
On Feb 23, 3:43 am, Adi <adityagupta..._at_gmail.com> wrote:
> Thanks a lot..
> Now that I have got this, is there some cook book to use RMAN?
I agree with the others that you have to understand what is going on, a cookbook is fine, but doesn't help you when the soup boils over. Recovery is the one thing you can't screw up.
This means you need to learn the concepts and practice, practice, practice. In the past I thought the way Oracle does this is counterproductive, relying on manual procedures during a crisis, but the modern versions make it as automated as makes sense. The downside is some things are abstract, you still need to learn the concepts cold to understand what is going on. For larger sites, there are a lot of knobs and levers to twiddle, this can be overwhelming even to the experienced. I know I'm surprised more often than I should be.
Read the docs, they start with a simple getting started doc. Get familiar with metalink and the way Oracle does support. Search metalink for "backup scenarios", there are some informative docs.
Here's the monkey-pushing-buttons version: http://www.oracle.com/technology/obe/2day_dba/backup/backup.htm
You really should aim for command-line RMAN mastery, though. And have someone else to back you up.
Here's an intro to this group, with some general resources: http://www.dbaoracle.net/readme-cdos.htm
-- _at_home.com is bogus. Silver Bullet: http://catless.ncl.ac.uk/Risks/25.58.html#subj11Received on Mon Feb 23 2009 - 12:03:45 CST