6 Replies Latest reply: Nov 12, 2012 3:58 PM by 12cdb RSS

    Netbackup Restore Fails on New Database

    Gensis2001
      We are testing using Netbackup to write our backups to disk and then seeing if we can restore them.
      The version of Netbackup is 7.5.0.3, Oracle Database version is 10.2.0.5 running on RedHat Enterprise Linux Server release 5.7.
      This database was never backed up because it was created for this test.
      The database is about 60GB and was backed up successfully per the logs; however, the restore failed with the following errors:

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 11/09/2012 12:53:17
      ORA-19870: error reading backup piece GHDB_p1_T20121109_t798894177
      ORA-19615: some files not found in backup set
      ORA-19613: datafile 111 not found in backup set

      When I look in the log for the backup, I see the following information:

      INF - Start backup of backup piece: (GHDB_p1_T20121109_t798894177)
      INF - Start backup of backup piece: (GHDB_p1_T20121109_t798894177)
      INF - Backup id: server01.domain.com_1352476986
      INF - Backup id: server01.domain.com_1352476987
      INF - Policy: 111_FULL
      INF - Policy: 111_FULL
      INF - Master server: ghmaster
      INF - Master server: ghmaster
      INF - Beginning backup on server gpmdb03 of client server01.
      INF - Beginning backup on server gpmdb03 of client server01.
      INF - End backup of backup piece: (GHDB_p1_T20121109_t798894177)
      INF - End backup of backup piece: (GHDB_p1_T20121109_t798894177)
      INF - Server status = 0
      INF - Server status = 0
      INF - End backup of backup piece: (GHDB_p1_T20121109_t798893466)
      INF - channel ch01: starting incremental level 0 datafile backupset
      INF - input datafile fno=00145 name=/u42/oracle/ghdb/psdefault_01.dbf
      INF - input datafile fno=00111 name=/u42/oracle/ghdb/inarch_01.dbf
      INF - input datafile fno=00235 name=/u42/oracle/ghdb/gllarge2013_01.dbf
      INF - piece handle=GHDB_p1_T20121109_t798894112 tag=TAG20121109T105105 comment=API Version 2.0,MMS Version 5.0.0.0
      INF - channel ch02: backup set complete, elapsed time: 00:01:05

      The backup settings used are:

      RUN {
      ALLOCATE CHANNEL ch00
      TYPE 'SBT_TAPE';
      ALLOCATE CHANNEL ch01
      TYPE 'SBT_TAPE';
      ALLOCATE CHANNEL ch02
      TYPE 'SBT_TAPE';
      SEND 'NB_ORA_CLIENT=server01.domain.com,NB_ORA_POLICY=111_FULL,NB_ORA_SERV=ghmaster.domain.com';
      BACKUP
      INCREMENTAL LEVEL=0
      FORMAT '%d_p%p__T%T_t%t'
      DATABASE FORCE;

      RELEASE CHANNEL ch00;
      RELEASE CHANNEL ch01;
      RELEASE CHANNEL ch02;

      # Backup Archived Logs
      sql 'alter system archive log current';

      ALLOCATE CHANNEL ch00
      TYPE 'SBT_TAPE';
      ALLOCATE CHANNEL ch01
      TYPE 'SBT_TAPE';
      ALLOCATE CHANNEL ch02
      TYPE 'SBT_TAPE';
      SEND 'NB_ORA_CLIENT=server01.domain.com,NB_ORA_POLICY=111_FULL,NB_ORA_SERV=ghmaster.domain.com';
      BACKUP
      FORMAT 'arch_u%u_s%s_p%p_t%t'
      ARCHIVELOG
      ALL
      DELETE INPUT;

      RELEASE CHANNEL ch00;
      RELEASE CHANNEL ch01;
      RELEASE CHANNEL ch02;

      # Control file backup

      ALLOCATE CHANNEL ch00
      TYPE 'SBT_TAPE';
      SEND 'NB_ORA_CLIENT=server01.domain.com,NB_ORA_POLICY=111_FULL,NB_ORA_SERV=ghmaster.domain.com';
      BACKUP
      FORMAT 'ctrl_u%u_s%s_p%p_t%t'
      CURRENT CONTROLFILE;
      RELEASE CHANNEL ch00;
      }

      It appears the files were backed up, any ideas why they can't be restored?