Re: Hot backup
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 4 Mar 2009 06:42:29 -0800 (PST)
Message-ID: <f5170a36-2281-4693-b786-d16866cc5f34_at_e2g2000vbe.googlegroups.com>
On Mar 4, 6:40 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 04 Mar 2009 02:20:47 -0800, oracle_user wrote:
> > Hi
>
> > Can someone guide me on what are the components of a hotbackup and how
> > to restore a hot backup.
>
> Yes. There is a guide:http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/toc.htm
> It can guide you very well, if you only read it. Also, you should Google
> for "Robert G. Freeman RMAN 10g" or "Arup Nanda RMAN recipes". I always
> recommend Google. Because of the similarity of my last to the name of the
> popular search engine, I am getting paid by the number of searches.
>
> > I have tried it , but always i had to use 'until cancel' option while
> > recovering the database. How can i avoid this.
>
> You can avoid it by reading the documentation. It doesn't hurt, it will
> not kill you and it might even prove useful.
>
>
>
> > Regards,
>
> Kindest regards.
>
> --http://mgogala.freehostia.com
Date: Wed, 4 Mar 2009 06:42:29 -0800 (PST)
Message-ID: <f5170a36-2281-4693-b786-d16866cc5f34_at_e2g2000vbe.googlegroups.com>
On Mar 4, 6:40 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 04 Mar 2009 02:20:47 -0800, oracle_user wrote:
> > Hi
>
> > Can someone guide me on what are the components of a hotbackup and how
> > to restore a hot backup.
>
> Yes. There is a guide:http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/toc.htm
> It can guide you very well, if you only read it. Also, you should Google
> for "Robert G. Freeman RMAN 10g" or "Arup Nanda RMAN recipes". I always
> recommend Google. Because of the similarity of my last to the name of the
> popular search engine, I am getting paid by the number of searches.
>
> > I have tried it , but always i had to use 'until cancel' option while
> > recovering the database. How can i avoid this.
>
> You can avoid it by reading the documentation. It doesn't hurt, it will
> not kill you and it might even prove useful.
>
>
>
> > Regards,
>
> Kindest regards.
>
> --http://mgogala.freehostia.com
For restores using manual hot backups also look in the SQL Manual at the ALTER DATABASE entry. You want to specifiy the automatic option.
The details of how to perform recovery and your options are discussed in the manual Mgogala recommended.
HTH -- Mark D Powell -- Received on Wed Mar 04 2009 - 08:42:29 CST