Home » RDBMS Server » Backup & Recovery » RMAN output logs (Orale 10g R2)
RMAN output logs [message #326391] Wed, 11 June 2008 05:46 Go to next message
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 #326404 is a reply to message #326391] Wed, 11 June 2008 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use an intermediate variable. See http://www.orafaq.com/forum/mv/msg/118919/321662/102589/#msg_321662

Regards
Michel

[Updated on: Wed, 11 June 2008 06:31]

Report message to a moderator

Re: RMAN output logs [message #326505 is a reply to message #326391] Wed, 11 June 2008 15:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What is the output of echo %date:~0,10%

I'd surmise that the date portion has invalid characters and/or spaces in it. Are the regional settings the same on each server?
Re: RMAN output logs [message #326772 is a reply to message #326505] Thu, 12 June 2008 09:50 Go to previous message
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

Previous Topic: Undo db changes of particular user in particular date
Next Topic: Invalid Password File error while performing Restore
Goto Forum:
  


Current Time: Wed Dec 07 20:16:32 CST 2016

Total time taken to generate the page: 0.16497 seconds