-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of David Wagoner
Sent: Wednesday, August 06, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RMAN Script QuestionThanks Samir, but I already tried that one too and it didn't work either.Best regards,
David B. Wagoner
Database Administrator
Arsenal Digital Solutions
-----Original Message-----
From: SARKAR, Samir [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 9:52 AM
To: '[EMAIL PROTECTED]'
Cc: David Wagoner
Subject: RE: RMAN Script QuestionDavid,Change the following line in ur script :backup database plus archivelog delete inputtobackup incremental level = 0 plus archivelog delete inputHth,SamirSamir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018-----Original Message-----
From: David Wagoner [mailto:[EMAIL PROTECTED]
Sent: 06 August 2003 15:09
To: Multiple recipients of list ORACLE-L
Subject: RMAN Script QuestionI believe I have an RMAN script syntax error. The following script works fine:
resync catalog;
run {
allocate channel t1 type 'SBT_TAPE';
backup incremental level 0
skip inaccessible
tag hot_db_bk_level0
filesperset 5
format 'data_full_%d_%U_%p_%c.bak' (database);
backup tag='control_file_backup'
format 'control_%s_%t.ctl' (current controlfile) ;
release channel t1;
}However, when I change the backup command to include archive logs and remove them after backup, I get an exit status of 1 in NetBackup and some RMAN errors. Here is the revised script:
resync catalog;
run {
allocate channel t1 type 'SBT_TAPE';
backup database plus archivelog delete input
skip inaccessible
tag hot_db_bk_level0
filesperset 5
format 'data_full_%d_%U_%p_%c.bak' (database);
backup tag='control_file_backup'
format 'control_%s_%t.ctl' (current controlfile) ;
release channel t1;
}Here is the RMAN error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "(": expecting one of: "channel, comma, delete, diskratio, filesperset, format, force, include, keep, maxsetsize, noexclude, nokeep, not, parms, pool, ;, skip, setsize, tag"RMAN-01007: at line 8 column 36 file: /usr/openv/netbackup/oracle_db/hot_database_backup_level0.rcv
Anyone see the error?
Best regards,
David B. Wagoner
Database Administrator
Arsenal Digital Solutions
Title: RMAN Script Question
David,
I have
a set of scripts which do various rman backups that I would be happy to send you
if you send me your email address ( no attachments to the list). They work
because I use them every day.
Ruth
- RE: RMAN Script Question Ruth Gramolini
- RE: RMAN Script Question SARKAR, Samir
- RE: RMAN Script Question David Wagoner
- RMAN Script Question David Wagoner
- RE: RMAN Script Question SARKAR, Samir