RE: RMAN Script Question

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Wed, 06 Aug 2003 07:39:30 -0800
Message-ID: <F001.005C93D1.20030806073930@fatcity.com>

David,  

I notice that u r using the line  

format 'data_full_%d_%U_%p_%c.bak' (database);  

in ur backup script when u r actually performing a database backup including archived logs backup.  

Try modifying the script as :  

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';
backup tag='control_file_backup'
format 'control_%s_%t.ctl' (current controlfile) ; release channel t1;
}

Samir

-----Original Message-----
Sent: 06 August 2003 16:00
To: Multiple recipients of list ORACLE-L

Thanks 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-----
Sent: Wednesday, August 06, 2003 9:52 AM To: 'ORACLE-L_at_fatcity.com'
Cc: David Wagoner

David,  

Change the following line in ur script :  

backup database plus archivelog delete input  

to  

backup incremental level = 0 plus archivelog delete input  

Hth,  

Samir  

Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : ssarkar2_at_slb.com
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018

-----Original Message-----
Sent: 06 August 2003 15:09
To: Multiple recipients of list ORACLE-L

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: SARKAR, Samir
  INET: Samir.SARKAR_at_nottingham.sema.slb.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 - 10:39:30 CDT