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