| RMAN output logs [message #326391] |
Wed, 11 June 2008 05:46  |
since
Messages: 18
Registered: May 2008
|
Junior Member |
|
|
Hi all!
I use the following bat file to call the RMAN script in windows 2003 but failed.
set oracle_sid=XXX
rman target sys/XXX@XXX msglog G:\RMAN\FULL\XXX_%date:~0,10%.log cmdfile=G:\RMAN\SCRIPT\RMANfull.rman
I save the code as *.bat format that I can double click to perform backup. But it doesn't work.
This code was successfull used in another database whith the same version (Oracle 10.2 R2) and also based on windows server 2003.
I had to static the output log filename, modify the script like this:
rman target sys/XXX@XXX msglog G:\RMAN\FULL\XXX_FULL.log cmdfile=G:\RMAN\SCRIPT\RMANfull.rman
That works, but in this case there is only one output logfile.
How can I keep all the RMAN output logfile with file name include date and sequence?
The same problem also use LEVEL 0 and LEVEL 1 backups.
Thanks!
|
|
|
|
|
|
|
|
| Re: RMAN output logs [message #326772 is a reply to message #326505] |
Thu, 12 June 2008 09:50  |
since
Messages: 18
Registered: May 2008
|
Junior Member |
|
|
Yes! Thank you very much! The default date format is changed.
The American region default setting in windows 2003 server, the following script would be fine. I give up to add a incremental sequence to keep the script simply.
rman target sys/XXX@XXX cmdfile=E:\RMAN\SCRIPT\FULL.RMAN LOG E:\RMAN\FULL\FULL%date:~-4%_%date:~-10,2%_%date:~-7,2%.log
[Updated on: Thu, 12 June 2008 09:51] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
