Re: RMAN Hot backup script

Hi Jeremiah,

   Thanks for your opinion. I gone through the BACKUP ... FULL option earlier. Here is my question. Will it do Consistant Backup? , i have to use RMAN for a 24X7 database. Also i gone through your suggested samples, i came to know that to get a consistant back through RMAN i have to kept the target database in Mount mode which is impossible in my case. Any suggestions and comments are greatly appreciated.

Thanks again.
Leo.

In article <38190C19.A4AE7B09_at_wolfenet.com>,   Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote:
> What an interesting way to use RMAN! I've never seen anything quite
like
> it. The problem is that you are basically scripting out an
> Oracle7-style hot backup in RMAN, when RMAN can do this by itself
> without using hot backup mode. Your current script does nothing that a
> batch file could not do. FWIW, in your script the disk channel you
are
> opening up is doing nothing. All the I/O is being handled by the
ocopy
> command out at the host level.
>
> You need to look at the RMAN documentation, which contains sample
> scripts for using the BACKUP FULL ... (DATABASE); command. This allows
> backup to disk or tape without using tablespace hot backup mode.
>
> There are also sample scripts in the Oracle distribution. On unix
they
> are in ?/rdbms/demo/. On NT they are in ?\Rdbms80\Rman\.
>
> --
> Jeremiah
>
> selvagam_at_my-deja.com wrote:
> >
> > I am trying to do the hot backup through RMAN by using the
following
> > script. I keep ignoring the host command. Is there any other way to
do
> > the hot backup, if anybody have scripts which is a great help for
me.
> >
> > # Performs hot backup.
> > run
> > {
> > allocate channel dev1 type disk;
> > sql "alter tablespace USERS begin backup";
> > host "c:\orante81\bin\ocopy h:\u03\oradata\test\users01.dbf
g:
> > \app\oracle\admin\test\rman_hot\users01.dbf";
> > sql "alter tablespace USERS end backup";
> > sql "alter SYSTEM switch logfile";
> > release channel dev1;
> > }
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 29 1999 - 12:17:21 CDT