RE: RMAN Script Question

[SARKAR, Samir]

Title: RMAN Script Question

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-----
From: David Wagoner [mailto:[EMAIL PROTECTED]
Sent: 06 August 2003 16:00
To: Multiple recipients of list ORACLE-L
Subject: RE: RMAN Script Question

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-----
From: SARKAR, Samir [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 9:52 AM
To: '[EMAIL PROTECTED]'
Cc: David Wagoner
Subject: RE: RMAN Script Question

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  :  [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 Question

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