Home » RDBMS Server » Backup & Recovery » How to make tag name unique everytime you run backup script (10g)
How to make tag name unique everytime you run backup script [message #328265] Thu, 19 June 2008 10:01 Go to next message
roopla
Messages: 52
Registered: May 2006
Member
I wrote a script and wants tag name for backup unique everytime you run the script

RUN
{
BACKUP
TAG 'CNTL_BKUP_${date_parm}'
CURRENT CONTROLFILE;
}

variable date_parm will be coming from unix script. But it doesn't work, date_parm will never be substituted as it is in the run block rman.

Is there any way we can make it work
Re: How to make tag name unique everytime you run backup script [message #328271 is a reply to message #328265] Thu, 19 June 2008 10:16 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

>Is there any way we can make it work
by using a "here script"

rman <<EOF

RUN
{
BACKUP
TAG 'CNTL_BKUP_${date_parm}'
CURRENT CONTROLFILE;
}
EOF
Re: How to make tag name unique everytime you run backup script [message #328280 is a reply to message #328271] Thu, 19 June 2008 10:37 Go to previous messageGo to next message
roopla
Messages: 52
Registered: May 2006
Member
Can you be more specific? I didn't get exactly what do you mean?
Re: How to make tag name unique everytime you run backup script [message #328281 is a reply to message #328265] Thu, 19 June 2008 10:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
To add,
>>wants tag name for backup unique everytime you run the script
That is not for what tags are originally meant for.
Re: How to make tag name unique everytime you run backup script [message #328282 is a reply to message #328281] Thu, 19 June 2008 10:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Use of "here document".
Look into EOF used in Ana's example.
Re: How to make tag name unique everytime you run backup script [message #328284 is a reply to message #328280] Thu, 19 June 2008 10:45 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
roopla wrote on Thu, 19 June 2008 08:37
Can you be more specific? I didn't get exactly what do you mean?


I am sorry to see that GOOGLE is broken for you.

Please be patient while repairs are underway.

Some folks are clue resistant; while others are clue repellent.
Previous Topic: rman
Next Topic: set sbt_tape to none?
Goto Forum:
  


Current Time: Fri Dec 09 02:10:57 CST 2016

Total time taken to generate the page: 0.05929 seconds