Home » RDBMS Server » Backup & Recovery » RMAN backup successfully? (windows,oracle 10.2)
RMAN backup successfully? [message #585681] Wed, 29 May 2013 01:45 Go to next message
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?
Re: RMAN backup successfully? [message #585683 is a reply to message #585681] Wed, 29 May 2013 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58609
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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?
Re: RMAN backup successfully? [message #585695 is a reply to message #585692] Wed, 29 May 2013 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 58609
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: RMAN backup successfully? [message #585697 is a reply to message #585692] Wed, 29 May 2013 03:32 Go to previous messageGo to next message
John Watson
Messages: 4400
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?
Re: RMAN backup successfully? [message #585699 is a reply to message #585695] Wed, 29 May 2013 03:38 Go to previous messageGo to next message
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

Re: RMAN backup successfully? [message #585701 is a reply to message #585699] Wed, 29 May 2013 03:44 Go to previous messageGo to next message
sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai
Junior Member
My windows is Simple Chinese (language),so some of info deleted.
Re: RMAN backup successfully? [message #585703 is a reply to message #585701] Wed, 29 May 2013 03:54 Go to previous message
sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai
Junior Member
Oh my God! Sorry,It's my mistake to end with the semicolon.

Previous Topic: RMAN Backup failed.
Next Topic: how to restore a database from a different server
Goto Forum:
  


Current Time: Tue Jul 29 07:49:31 CDT 2014

Total time taken to generate the page: 0.12420 seconds