RE: RMAN Script Question

[David Wagoner]

Title: 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 AMTo: 
'[EMAIL PROTECTED]'Cc: David WagonerSubject: RE: RMAN 
Script Question

  David,
  
  Change the 
  following line in ur script :
  
  backup database plus archivelog delete 
  input 
  
  
  to 
  
  
  backupincremental level = 0plus 
  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:09To: Multiple recipients of list ORACLE-LSubject: 
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 

RMAN Script Question

[David Wagoner]

Title: 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

RE: RMAN Script Question

[SARKAR, Samir]

Title: RMAN Script Question



David,

Change the 
following line in ur script :

backup database plus archivelog delete 
input 


to 


backupincremental level = 0plus 
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:09To: Multiple recipients of list ORACLE-LSubject: 
  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 

RE: RMAN Script Question

[Ruth Gramolini]

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

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of David 
  WagonerSent: Wednesday, August 06, 2003 11:00 AMTo: 
  Multiple recipients of list ORACLE-LSubject: 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 AMTo: 
  '[EMAIL PROTECTED]'Cc: David WagonerSubject: RE: RMAN 
  Script Question
  
David,

Change the 
following line in ur script :

backup database plus archivelog delete 
input 


to 


backupincremental level = 0plus 
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:09To: Multiple recipients of list 
  ORACLE-LSubject: 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 

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'; backupdatabase 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:00To: Multiple recipients of list ORACLE-LSubject: 
  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 AMTo: 
  '[EMAIL PROTECTED]'Cc: David WagonerSubject: RE: RMAN 
  Script Question
  
David,

Change the 
following line in ur script :

backup database plus archivelog delete 
input 


to 


backupincremental level = 0plus 
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:09To: Multiple recipients of list 
  ORACLE-LSubject: 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