OraFAQ Forum: Backup & Recovery » Getting error backup controlfile to trace in RMAN script

Home » RDBMS Server » Backup & Recovery » Getting error backup controlfile to trace in RMAN script

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

Getting error backup controlfile to trace in RMAN script [message #193349]

Fri, 15 September 2006 16:13

ksintrakool
Messages: 20
Registered: July 2006
Location: Las Vegas

Junior Member

Hi All,

Does anyone know how I include the following command in RMAN script?

sql "alter database backup controlfile to ''$BACKUP_DEST/$ORACLE_SID_CF_backup_$FILE_TIMESTAMP.dbf''";

BACKUP_DEST, ORACLE_SID and FILE_TIMESTAMP are environment variables.

I keep getting error cannot create file $BACKUP_DEST/$ORACLE_SID_CF_backup_$FILE_TIMESTAMP.dbf

Thanks,

Report message to a moderator

Re: Getting error backup controlfile to trace in RMAN script [message #193350 is a reply to message #193349]

Fri, 15 September 2006 16:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What make you think the "SQL" knows how to do environmental variable substitution?

Report message to a moderator

Re: Getting error backup controlfile to trace in RMAN script [message #193353 is a reply to message #193349]

Fri, 15 September 2006 16:31

ksintrakool
Messages: 20
Registered: July 2006
Location: Las Vegas

Junior Member

I use environment variables in RMAN scripts to tell RMAN where to backup. Since the 'sql' is in the RMAN script, this makes me forgot to think that it is actually in sql.

What I try to accomplice is creating a script to backup control file to different destinations, so I can use one script with many databases. Any idea?

Thanks,

Report message to a moderator

Re: Getting error backup controlfile to trace in RMAN script [message #193354 is a reply to message #193353]

Fri, 15 September 2006 16:54

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

Senior Member
Account Moderator

All you need is a little tweak in the syntax.

oracle@dubbel:~> export MYFILE=/mytracefile
oracle@dubbel:~> export MYDIR=/tmp
oracle@dubbel:~> rman

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Sep 15 10:49:45 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect target /

connected to target database: PRIMARY (DBID=1438506724)

RMAN> sql "alter database backup controlfile to trace as ''/$MYDIR/$MYFILE''";

using target database control file instead of recovery catalog
sql statement: alter database backup controlfile to trace as ''/$MYDIR/$MYFILE''

RMAN> host
2> ;

oracle@dubbel:~> ls -lrt /tmp/mytracefile
-rw-r--r--  1 oracle oinstall 8520 2006-09-15 10:50 /tmp/mytracefile

Report message to a moderator

Re: Getting error backup controlfile to trace in RMAN script [message #193358 is a reply to message #193349]

Fri, 15 September 2006 17:10

ksintrakool
Messages: 20
Registered: July 2006
Location: Las Vegas

Junior Member

It works. THANKS a bunch Mahesh Rajendran.

Report message to a moderator

Previous Topic:	I deleted listener.log file !!!!
Next Topic:	Data recovery using a dump File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 08:28:43 CDT 2024