OraFAQ Forum: Backup & Recovery » How to make tag name unique everytime you run backup script

Home » RDBMS Server » Backup & Recovery » How to make tag name unique everytime you run backup script (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to make tag name unique everytime you run backup script [message #328265]

Thu, 19 June 2008 10:01

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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

Report message to a moderator

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

roopla
Messages: 52
Registered: May 2006

Member

Can you be more specific? I didn't get exactly what do you mean?

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Use of "here document".
Look into EOF used in Ana's example.

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	rman
Next Topic:	set sbt_tape to none?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 20:39:55 CST 2024