RE: RMAN Script Question

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 06 Aug 2003 08:04:23 -0800
Message-ID: <F001.005C93EE.20030806080423@fatcity.com>

RMAN Script QuestionDavid,

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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of David Wagoner
  Sent: Wednesday, August 06, 2003 11:00 AM   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:Samir.SARKAR_at_nottingham.sema.slb.com]   Sent: Wednesday, August 06, 2003 9:52 AM   To: 'ORACLE-L_at_fatcity.com'
  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 : 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-----
      From: David Wagoner [mailto:dwagoner_at_arsenaldigital.com]
      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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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 - 11:04:23 CDT