RMAN on Windows 2000: How to use date parameter?

Hi all,

I want schedule the RMAN backup on Windows 2000 server for our 8i production database.

In that, I want to generate RMAN backup file with DD,MM,YYYY stamp and also write some if/then/else construct using DD/MM/YYYY parameter. I have a command file from which I call RMAN command passing the .RCV (RMAN script file). In the RMAN script file, I have all RMAN backup commands. Now, In this file, I want to write the RMAN backup file name with DD / MM/ YYYY values.

Has any one used it?

Pl. help.

Thanks in Adv.

Hi,

Any help please...

Thanks,

I have not used it and also don't think oracle provides the format with dd/mm/yyyy with rman(not 100% sure). But I would write a shell script to rename the OS file with dd/mm/yyyy as soon as RMAN writes the backup file.....if you are not directly writing to the tapes. Hope this helps.

Hi dbasupuser,

Thanks for yr reply.

is there any other way to do it?

Thanks,

I think u can do it in ur script....any way try this....

In ur script, capture the string dd/mm/yyyy in some variable from any dummy table say DUAL & use that variable for the generation of the file name in which u want to put RMAN backup.

Regards
Abhay.

Quote:

---

Originally posted by dbasupuser
I have not used it and also don't think oracle provides the format with dd/mm/yyyy with rman(not 100% sure). But I would write a shell script to rename the OS file with dd/mm/yyyy as soon as RMAN writes the backup file.....if you are not directly writing to the tapes. Hope this helps.

---

Renaming RMAN backup files would be a disaster thing to do. In case of recovery RMAN will look for the files it has created and will give errors when it doesn't find them.

To include timestamp in the RMAN filename you can use %t. For more information see the FORMAT options.

HTH

Hi Sanjay,

%t does not provide something like YYYYMMDD, which I want to include in the file name.

After some research, I am now able to generate the RMAN .RCV file with the timestamp as I want. But now, I have one more problem left.

In Windows command file, I want to print '%' in the echo command. Problem is that % in command batch file with echo command is used for substitution.

Does any one know how to suppress the effect of % to actually print % in the echo command?

Thanks,

Quote:

---

Originally posted by samdba


In Windows command file, I want to print '%' in the echo command. Problem is that % in command batch file with echo command is used for substitution.

Does any one know how to suppress the effect of % to actually print % in the echo command?

Thanks,

---

say if u wana print 2 % prior to and after message....then the echo command has to be

ECHO %%%"the message u want to include"%%%

Result
%%"the message u want to include"%%

#append % with %s where u want to print '%'

Quote:

---

Originally posted by samdba


%t does not provide something like YYYYMMDD, which I want to include in the file name.

After some research, I am now able to generate the RMAN .RCV file with the timestamp as I want. But now, I have one more problem left.

Thanks,

---

Cau u tell us what did u do to get timestamp in ur file name?

Regards
Abhay.