Passing Environment variables to the RMAN command rcv file
dennydbaOct 21 2009 — edited Oct 21 2009Hi all...I'm setting up a Unix-based nightly job to duplicate a production database via RMAN's duplication process. The backupset to be used in the duplication finishes approx 3:00 am. I need to run the duplication later in the day, so I'm trying to figure out a way to provide the SET UNTIL SEQUENCE statement with the sequence number of the last archived log file from that latest 3:00 am backup job. I actually add 1 to the number to get RMAN to stop the duplication process after the final file is applied.
There are a few ways to go about this, but I was that hoping someone can tell me if there is anyway to set up the RCV file with the equivalent of an environment variable. I can find a way to obtain that and place it into a file that could be read, or using sed to make the file look how I want, but I still need to pass that value onto the RCV file so I don't have to manually update the sequence number each night.
I've looked around and so far I have not read about anything similar being done or discussed.
Any help would be great. Thanks!
Den
Edited by: user12020266 on Oct 21, 2009 12:10 PM