RMAN Script Question

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Wed, 06 Aug 2003 06:09:23 -0800
Message-ID: <F001.005C93A7.20030806060923@fatcity.com>

I 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Wagoner
  INET: dwagoner_at_arsenaldigital.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Aug 06 2003 - 09:09:23 CDT