OraFAQ Forum: Backup & Recovery » RMAN backup successfully?

Home » RDBMS Server » Backup & Recovery » RMAN backup successfully? (windows,oracle 10.2)

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

RMAN backup successfully? [message #585681]

Wed, 29 May 2013 01:45

sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai

Junior Member

when I execute this rman backup script

run{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup as compressed backupset incremental level 0 filesperset 4 database;
backup as compressed backupset incremental level 0 archivelog all delete all input;
release channel d1;
release channel d2;
};

it throws a error RMAN-00558 etc. in the end.

Description in alert_orcl.log:

Wed May 29 14:10:21 2013
Thread 1 cannot allocate new log, sequence 129
Private strand flush not complete
  Current log# 1 seq# 128 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thread 1 advanced to log sequence 129
  Current log# 2 seq# 129 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

backup successfully?

What does the description represent?

Report message to a moderator

Re: RMAN backup successfully? [message #585683 is a reply to message #585681]

Wed, 29 May 2013 01:58

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

Senior Member
Account Moderator

Quote:

backup successfully?

No, the script is wrong:

RMAN-00558: error encountered while parsing input commands
 *Cause:  The parser detected a syntax error.
 *Action: This message should be accompanied by other error message(s)
          indicating the cause of the error.

Quote:

What does the description represent?

Just Google, this has been answered hundred times and this has nothing related to the error.

Regards
Michel

[Updated on: Wed, 29 May 2013 01:59]

Report message to a moderator

Re: RMAN backup successfully? [message #585692 is a reply to message #585683]

Wed, 29 May 2013 03:12

sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai

Junior Member

Quote:

No, the script is wrong:

but when I list backup all of them display.
It can not represent the backup is successful?

Report message to a moderator

Re: RMAN backup successfully? [message #585695 is a reply to message #585692]

Wed, 29 May 2013 03:25

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

Senior Member
Account Moderator

I don't known, no one can't know, you didn't post what you did.
All I say is that the script/command before the error is syntaxically wrong, this is what the message says. It also says to have a look at the other error messages you didn't share with us.

If you want specific and accurate answers you MUST post all the information.

Regards
Michel

Report message to a moderator

Re: RMAN backup successfully? [message #585697 is a reply to message #585692]

Wed, 29 May 2013 03:32

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Look carefully at the output. You will see that the commands succeed, up until your syntax error at the end. How should you terminate a run block?

Report message to a moderator

Re: RMAN backup successfully? [message #585699 is a reply to message #585695]

Wed, 29 May 2013 03:38

sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai

Junior Member

The error on windows command console can not be copied.

so,I re-execute the script with log option,

MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 0 column 2 file: standard input
[/code]

[Updated on: Wed, 29 May 2013 03:42]

Report message to a moderator