OraFAQ Forum: Backup & Recovery » How to run script backup

Home » RDBMS Server » Backup & Recovery » How to run script backup

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

How to run script backup [message #153919]

Wed, 04 January 2006 21:41

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.

Report message to a moderator

Re: How to run script backup [message #153933 is a reply to message #153919]

Thu, 05 January 2006 00:22

Frank Naude
Messages: 4581
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

Report message to a moderator

Re: How to run script backup [message #153937 is a reply to message #153933]

Thu, 05 January 2006 00:47

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?

Report message to a moderator

Re: How to run script backup [message #153939 is a reply to message #153937]

Thu, 05 January 2006 00:58

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

"cmdfile" is a command line option, not an RMAN command!

Report message to a moderator

Re: How to run script backup [message #153942 is a reply to message #153939]

Thu, 05 January 2006 01:05

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

Report message to a moderator

Re: How to run script backup [message #153943 is a reply to message #153942]

Thu, 05 January 2006 01:09

Frank Naude
Messages: 4581
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!

Report message to a moderator

Re: How to run script backup [message #154183 is a reply to message #153943]

Fri, 06 January 2006 03:05

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

Thank you I have run success

Report message to a moderator

Re: How to run script backup [message #156636 is a reply to message #154183]

Thu, 26 January 2006 10:46

ujumaka
Messages: 7
Registered: January 2006

Junior Member

pls what command did u finally use in running it successfully? Thanks

Report message to a moderator

Re: How to run script backup [message #259622 is a reply to message #154183]

Thu, 16 August 2007 02:31

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,

Report message to a moderator

Re: How to run script backup [message #259626 is a reply to message #153919]

Thu, 16 August 2007 02:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

lOOK at the posts of Frank Naude about this topic.

Report message to a moderator

Re: How to run script backup [message #259631 is a reply to message #259626]

Thu, 16 August 2007 02:40

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Thanks Arju,

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

TIA,

Report message to a moderator

Re: How to run script backup [message #259637 is a reply to message #153919]

Thu, 16 August 2007 02:45

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).

Report message to a moderator

Re: How to run script backup [message #259644 is a reply to message #259631]

Thu, 16 August 2007 03:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to run script backup [message #259657 is a reply to message #259644]

Thu, 16 August 2007 03:39

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...

Report message to a moderator

Re: How to run script backup [message #259666 is a reply to message #259657]

Thu, 16 August 2007 04:13

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to run script backup [message #259676 is a reply to message #259666]

Thu, 16 August 2007 04:27

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

hey

It just happens michel....

Report message to a moderator

Re: How to run script backup [message #259824 is a reply to message #259676]

Thu, 16 August 2007 11:11

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Yes sometimes when MIND is some where else Wink

Report message to a moderator

Re: How to run script backup [message #445433 is a reply to message #259824]

Mon, 01 March 2010 19:28

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>

Report message to a moderator

Re: How to run script backup [message #445434 is a reply to message #445433]

Mon, 01 March 2010 19:34

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...

Report message to a moderator

Previous Topic:	Enterprise Manager and RMAN commands
Next Topic:	RMAN issue in Unix

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:02:21 CST 2024