Re: RMAN on Windows: Dynamic Spool File

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Tue, 14 Sep 2010 16:20:52 -0700 (PDT)
Message-ID: <11c0f433-864c-404c-951c-472ac83f4d7d_at_w4g2000vbh.googlegroups.com>

On Sep 13, 4:50 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> Hi,
>
> We are running Oracle 10g on Windows 2003. We intend to run an RMAN
> batch script as follows: "rman target=/ _at_backup_script.sql".
>
> Backup_script.sql contains a "spool log" command; I want to
> change that command to spool to a dynamic filename, with
> a date and time script. How can this be done?
>
> Backup_script.sql is as follows:
>
> spool log to 'E:\RMAN\RMANbackup.log';
> Run {
>   CONFIGURE CHANNEL ...
>   BACKUP DATABASE;
>   ......
>  }
> exit;
> spool off;

There are a ton of scripting alternatives available in a windows environment.

Why don't you figure out which of the options you want to use and do some learning about writing scripts in that specific environment? Received on Tue Sep 14 2010 - 18:20:52 CDT