Re: RMAN BACKUP Script used by Macro

Chuck Lee wrote:

> Hi Rogers
>
> I checked the www.dizwell.com,its a very good web site.
> I found a backup script there, but it performs a non RMAN backup.
> Could some one inform , where should I find a RMAN BACKUP Script which
> can be used by Macro as we see in www.dizwell.com.
>
> Thnaks
>
> Lee

Oh please.

First, the name is Howard, not Rogers.

Second, you asked for suggestions regarding VB scripting, and I suggested this to show you one. In particular, you wanted to know how to output text files from within a VB script. You didn't ask to see backup scripts, or RMAN scripts, but for help with VB scripting in general.

Third, the script at dizwell has enough examples of coding that anyone with even a modicum of effort could knock up their own variants to do all sorts of things.

Fourth, this is an Oracle newsgroup, not a VB scripting one.

Five, what's on the website is on the website. What isn't, isn't. Live with it.

Six. How complicated do you think an RMAN backup would get? "Backup database;" is the only command that really needs issuing in 9i. You really want a VB script macro to issue that... or do you think typing 16 characters on your keyboard might be more efficient?

Seven, I give up. Here's the script you want:

strFileOut="beginbackup.txt"
set objFS=CreateObject("Scripting.FileSystemObject") set objOutFile=objFS.OpenTextFile(strFileOut,2,1) strOutput="backup database;"
objOutFile.WriteLine strOutPut

set WShShell=CreateObject("WScript.Shell") WShShell.Run "rman target / @beginbackup.txt"

...which you could have deduced from the very first subroutine of the script at www.dizwell.com.

HJR Received on Tue Apr 27 2004 - 16:22:22 CDT