RMAN on Windows: Dynamic Spool File
From: if_investor_at_yahoo.com <basis_consultant_at_hotmail.com>
Date: Mon, 13 Sep 2010 13:50:35 -0700 (PDT)
Message-ID: <0676f3a5-891c-48e8-b381-4a58b73364fd_at_k13g2000vbq.googlegroups.com>
Hi,
Date: Mon, 13 Sep 2010 13:50:35 -0700 (PDT)
Message-ID: <0676f3a5-891c-48e8-b381-4a58b73364fd_at_k13g2000vbq.googlegroups.com>
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;
Received on Mon Sep 13 2010 - 15:50:35 CDT