Re: RMAN Hot backup script

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;
> }
Received on Thu Oct 28 1999 - 21:53:13 CDT