Home » RDBMS Server » Backup & Recovery » How to run script backup
How to run script backup [message #153919] Wed, 04 January 2006 21:41 Go to next message
quytc
Messages: 81
Registered: November 2005
Location: Viet Nam
Member

I have a database which infomations follow:
Database name: TEST
TNS name : TEST
user name DBA: TEST
Password : TEST
and I have a script is BACKUP.RCV which same Care1.rcv in oraclehome/rdbms/demo.
Can anybody help me to run this script BACKUP.RCV.
Re: How to run script backup [message #153933 is a reply to message #153919] Thu, 05 January 2006 00:22 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
You can run RCV files with RMAN. Enter the following command from the command line:

rman cmdfile BACKUP.RCV


Best regards.

Frank
Re: How to run script backup [message #153937 is a reply to message #153933] Thu, 05 January 2006 00:47 Go to previous messageGo to next message
quytc
Messages: 81
Registered: November 2005
Location: Viet Nam
Member

thanks.
But I trie to run this command with RMAN. RMAN report error:
RMAN> cmdfile backup.rcv;
RMAN-00571: ================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ====
RMAN-00571: ================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "cmdfile": expecting one of: "allocate, alter, beginline, catalog, change, connect, create,....
RMAN-01007: at line 1 column 1 file: standard input

is location of file backup importance?
Re: How to run script backup [message #153939 is a reply to message #153937] Thu, 05 January 2006 00:58 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
"cmdfile" is a command line option, not an RMAN command!
Re: How to run script backup [message #153942 is a reply to message #153939] Thu, 05 January 2006 01:05 Go to previous messageGo to next message
quytc
Messages: 81
Registered: November 2005
Location: Viet Nam
Member

I run this command in command dos. this report error
D:\Documents and Settings\Administrator>rman cmdfile backup.rcv
Argument Value Description
---------------------------------------------------------------
target quoted-string connect-string for target database
rcvcat quoted-string connect-string for recovery catalog
debug none if specified, activate debugging mode
cmdfile quoted-string name of input command file
msglog quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, msglog opened in append mode
nocatalog none if specified, then no recovery catalog
-----------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "backup.rcv"

Can you help me to find this error
Re: How to run script backup [message #153943 is a reply to message #153942] Thu, 05 January 2006 01:09 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
RMAN cannot open file "backup.rcv". Specify the full path to backup.rcv or "cd" into the directory where your script is!
Re: How to run script backup [message #154183 is a reply to message #153943] Fri, 06 January 2006 03:05 Go to previous messageGo to next message
quytc
Messages: 81
Registered: November 2005
Location: Viet Nam
Member

Thank you I have run success
Re: How to run script backup [message #156636 is a reply to message #154183] Thu, 26 January 2006 10:46 Go to previous messageGo to next message
ujumaka
Messages: 7
Registered: January 2006
Junior Member

pls what command did u finally use in running it successfully? Thanks
Re: How to run script backup [message #259622 is a reply to message #154183] Thu, 16 August 2007 02:31 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
hey guy,

I am having the same problem now. how to specify the .rcv file can u post me the syntax please?

Oracle 10.2.0
WindowsNT

TIA,

Re: How to run script backup [message #259626 is a reply to message #153919] Thu, 16 August 2007 02:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

lOOK at the posts of Frank Naude about this topic.
Re: How to run script backup [message #259631 is a reply to message #259626] Thu, 16 August 2007 02:40 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Thanks Arju,

Sorry to ask this
Can u plz post me the link....

TIA,
Re: How to run script backup [message #259637 is a reply to message #153919] Thu, 16 August 2007 02:45 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

From start menu select run and write cmd
then command prompt will appear. Now change your directory by using cd command (if it is in D drive write
D:
then cd )and go to your desired directory where .rcv file resides.
Now write

rman cmdfile <filename> 


(omit < and > while writing in command line).
Re: How to run script backup [message #259644 is a reply to message #259631] Thu, 16 August 2007 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can u plz post me the link....

How stupid could be the guy that asks this when we told him to read few posts above!
I really can't imagine.

Regards
Michel
Re: How to run script backup [message #259657 is a reply to message #259644] Thu, 16 August 2007 03:39 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
hey

I thought it as a seperate thread.
so asked
I dont think it as a stupid one...

Re: How to run script backup [message #259666 is a reply to message #259657] Thu, 16 August 2007 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First answer of the thread:
Frank Naude wrote on Thu, 05 January 2006 07:22
You can run RCV files with RMAN. Enter the following command from the command line:

rman cmdfile BACKUP.RCV


Best regards.

Frank

Final answer from Arju:
Quote:
rman cmdfile <filename>

Oh yes! this is not a stupid question.

Regards
Michel

Re: How to run script backup [message #259676 is a reply to message #259666] Thu, 16 August 2007 04:27 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
hey

It just happens michel....
Re: How to run script backup [message #259824 is a reply to message #259676] Thu, 16 August 2007 11:11 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yes sometimes when MIND is some where else Wink
icon5.gif  Re: How to run script backup [message #445433 is a reply to message #259824] Mon, 01 March 2010 19:28 Go to previous messageGo to next message
learningdba
Messages: 2
Registered: March 2010
Junior Member
I read the above comments fully...

But i cant run the script from the folder where i have stored.

C:\oraclexe\app\oracle\admin\XE\scripts>rman cmdfile rman1.rcv

Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "rman1.rcv"

C:\oraclexe\app\oracle\admin\XE\scripts>
Re: How to run script backup [message #445434 is a reply to message #445433] Mon, 01 March 2010 19:34 Go to previous message
learningdba
Messages: 2
Registered: March 2010
Junior Member
Thank god ! It runs now....

Sorry for the above request...

The problem with file extension it saved as "rman1.rcv.text" instead of "rman1.rcv"... so the file is not opened. later then i found that and renamed the extension.

now its working...
Previous Topic: Enterprise Manager and RMAN commands
Next Topic: RMAN issue in Unix
Goto Forum:
  


Current Time: Mon Dec 05 02:54:07 CST 2016

Total time taken to generate the page: 0.08729 seconds