4 Replies Latest reply on May 17, 2012 2:16 PM by AbhayK

    Problem while appling incremental backup on standby 10.2.0.4

    AbhayK
      Hi,

      While recovering incremental backup on standby database, we are facing problem.
      Even though we have cataloged the backup we want to recover, when we issue "RMAN> recover database noredo;" recovery fails as rman tries to recover from the backup which are not avaliable on disk.

      RMAN> recover database noredo;

      Starting recover at 20-OCT-11
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=531 devtype=DISK
      allocated channel: ORA_DISK_2
      channel ORA_DISK_2: sid=530 devtype=DISK
      allocated channel: ORA_DISK_3
      channel ORA_DISK_3: sid=529 devtype=DISK
      allocated channel: ORA_DISK_4
      channel ORA_DISK_4: sid=528 devtype=DISK
      channel ORA_DISK_1: starting incremental datafile backupset restore
      channel ORA_DISK_1: specifying datafile(s) to restore from backup set
      destination for restore of datafile 00012: /u02/oradata/p1sipmdm/data/p1sipmdm_cmx_temp2.dbf
      destination for restore of datafile 00013: /u05/oradata/p1sipmdm/index/p1sipmdm_cmx_indx3.dbf
      destination for restore of datafile 00027: /u05/oradata/p1sipmdm/data/p1sipmdm_cmx_temp4.dbf
      destination for restore of datafile 00042: /u01/oradata/p1sipmdm/index/p1sipmdm_cmx_indx9.dbf
      destination for restore of datafile 00046: /u03/oradata/p1sipmdm/data/p1sipmdm_cmx_data19.dbf
      destination for restore of datafile 00068: /u06/oradata/p1sipmdm/index/gnw_death_ors_x04.dbf
      destination for restore of datafile 00076: /u07/oradata/p1sipmdm/data/p1sipmdm_cmx_data24.dbf
      channel ORA_DISK_1: reading from backup piece /backup/rman_backup/p1sipmdm/qimouvjj_1_1
      channel ORA_DISK_2: starting incremental datafile backupset restore
      channel ORA_DISK_2: specifying datafile(s) to restore from backup set
      destination for restore of datafile 00010: /u06/oradata/p1sipmdm/index/p1sipmdm_cmx_indx2.dbf
      destination for restore of datafile 00022: /u07/oradata/p1sipmdm/data/p1sipmdm_cmx_data7.dbf
      destination for restore of datafile 00025: /u03/oradata/p1sipmdm/data/p1sipmdm_cmx_temp3.dbf
      destination for restore of datafile 00030: /u09/oradata/p1sipmdm/data/p1sipmdm_cmx_data10.dbf
      destination for restore of datafile 00069: /u02/oradata/p1sipmdm/index/gnw_death_ors_x05.dbf
      destination for restore of datafile 00083: /u08/oradata/p1sipmdm/data/system09.dbf
      destination for restore of datafile 00086: /u08/oradata/p1sipmdm/data/gnw_producer01.dbf
      channel ORA_DISK_2: reading from backup piece /backup/rman_backup/p1sipmdm/qmmov08s_1_1
      channel ORA_DISK_3: starting incremental datafile backupset restore
      channel ORA_DISK_3: specifying datafile(s) to restore from backup set
      destination for restore of datafile 00006: /u02/oradata/p1sipmdm/data/p1sipmdm_cmx_data2.dbf
      destination for restore of datafile 00009: /u05/oradata/p1sipmdm/index/p1sipmdm_cmx_indx1.dbf
      destination for restore of datafile 00032: /u09/oradata/p1sipmdm/index/p1sipmdm_cmx_indx6.dbf
      destination for restore of datafile 00067: /u03/oradata/p1sipmdm/index/gnw_death_ors_x03.dbf
      destination for restore of datafile 00080: /u08/oradata/p1sipmdm/data/p1sipmdm_cmx_data27.dbf
      channel ORA_DISK_3: reading from backup piece /backup/rman_backup/p1sipmdm/qkmov07b_1_1
      channel ORA_DISK_4: starting incremental datafile backupset restore
      channel ORA_DISK_4: specifying datafile(s) to restore from backup set
      destination for restore of datafile 00020: /u07/oradata/p1sipmdm/data/p1sipmdm_mdm_data3.dbf
      destination for restore of datafile 00072: /u01/oradata/p1sipmdm/data/docgen_data01.dbf
      channel ORA_DISK_4: reading from backup piece /backup/rman_backup/p1sipmdm/qnmov0ev_1_1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of recover command at 10/20/2011 22:54:39
      ORA-19870: error reading backup piece /backup/rman_backup/p1sipmdm/qimouvjj_1_1
      ORA-19505: failed to identify file "/backup/rman_backup/p1sipmdm/qimouvjj_1_1"
      ORA-27037: unable to obtain file status
      Linux-x86_64 Error: 2: No such file or directory
      Additional information: 3


      Actual files are located at /u07/oradata/p1sipmdm_bkp/ location .. when we issue list backup summary rman shows these backups that we want to use..

      RMAN> list backups;

      BS Key Type LV Size Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      11210 Incr 4.88G DISK 00:00:00 20-OCT-11
      BP Key: 12907 Status: AVAILABLE Compressed: YES Tag: TAG20111020T101659
      Piece Name: /u07/oradata/p1sipmdm_bkp/pmsipmdp_1empinlp_1_1
      List of Datafiles in backup set 11210
      File LV Type Ckp SCN Ckp Time Name
      ---- -- ---- ---------- --------- ----
      4 Incr 8428228181070 20-OCT-11 /u01/oradata/p1sipmdm/data/users01.dbf
      7 Incr 8428228181070 20-OCT-11 /u03/oradata/p1sipmdm/data/p1sipmdm_cmx_data3.dbf
      16 Incr 8428228181070 20-OCT-11 /u01/oradata/p1sipmdm/data/p1sipmdm_cmx_data6.dbf
      18 Incr 8428228181070 20-OCT-11 /u06/oradata/p1sipmdm/data/p1sipmdm_mdm_data1.dbf
      29 Incr 8428228181070 20-OCT-11 /u05/oradata/p1sipmdm/data/undotbs03.dbf
      41 Incr 8428228181070 20-OCT-11 /u02/oradata/p1sipmdm/data/p1sipmdm_cmx_data15.dbf
      79 Incr 8428228181070 20-OCT-11 /u06/oradata/p1sipmdm/data/p1sipmdm_cmx_data26.dbf

      BS Key Type LV Size Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      11211 Incr 80.00K DISK 00:00:00 20-OCT-11
      BP Key: 12908 Status: AVAILABLE Compressed: YES Tag: TAG20111020T101659
      Piece Name: /u07/oradata/p1sipmdm_bkp/pmsipmdp_1impioai_1_1
      SPFILE Included: Modification time: 20-OCT-11

      please advice.

      Regards,
      Abhay.....
        • 1. Re: Problem while appling incremental backup on standby 10.2.0.4
          CKPT
          RMAN-03002: failure of recover command at 10/20/2011 22:54:39
          ORA-19870: error reading backup piece /backup/rman_backup/p1sipmdm/qimouvjj_1_1
          ORA-19505: failed to identify file "/backup/rman_backup/p1sipmdm/qimouvjj_1_1"
          Seems to be backup piece is missing physically.

          post
          $ls -ltr /backup/rman_backup/p1sipmdm/qimouvjj_1_1
          BTW, are you cataloged those pieces with controlfile?
          RMAN > catalog start with '/backup/rman_backup/';
          Edited by: CKPT on Oct 21, 2011 9:20 AM
          • 2. Re: Problem while appling incremental backup on standby 10.2.0.4
            AbhayK
            Hi,

            Backups are cataloged and they are persent on te server but on another location.

            BS Key Type LV Size Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            11210 Incr 4.88G DISK 00:00:00 20-OCT-11
            BP Key: 12907 Status: AVAILABLE Compressed: YES Tag: TAG20111020T101659
            Piece Name: /u07/oradata/p1sipmdm_bkp/pmsipmdp_1empinlp_1_1
            List of Datafiles in backup set 11210
            File LV Type Ckp SCN Ckp Time Name
            ---- -- ---- ---------- --------- ----
            4 Incr 8428228181070 20-OCT-11 /u01/oradata/p1sipmdm/data/users01.dbf
            7 Incr 8428228181070 20-OCT-11 /u03/oradata/p1sipmdm/data/p1sipmdm_cmx_data3.dbf
            16 Incr 8428228181070 20-OCT-11 /u01/oradata/p1sipmdm/data/p1sipmdm_cmx_data6.dbf
            18 Incr 8428228181070 20-OCT-11 /u06/oradata/p1sipmdm/data/p1sipmdm_mdm_data1.dbf
            29 Incr 8428228181070 20-OCT-11 /u05/oradata/p1sipmdm/data/undotbs03.dbf
            41 Incr 8428228181070 20-OCT-11 /u02/oradata/p1sipmdm/data/p1sipmdm_cmx_data15.dbf
            79 Incr 8428228181070 20-OCT-11 /u06/oradata/p1sipmdm/data/p1sipmdm_cmx_data26.dbf

            BS Key Type LV Size Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            11211 Incr 80.00K DISK 00:00:00 20-OCT-11
            BP Key: 12908 Status: AVAILABLE Compressed: YES Tag: TAG20111020T101659
            Piece Name: /u07/oradata/p1sipmdm_bkp/pmsipmdp_1impioai_1_1
            SPFILE Included: Modification time: 20-OCT-11
            • 3. Re: Problem while appling incremental backup on standby 10.2.0.4
              CKPT
              Backups are cataloged and they are persent on te server but on another location.
              how did you cataloed?

              From Source:-
              Piece Name: /u07/oradata/p1sipmdm_bkp/pmsipmdp_1empinlp_1_1
              Destination:-
              /backup/rman_backup/p1sipmdm/qimouvjj_1_1
              So catalog from mount status as below.

              RMAN> catalog start with '/backup/rman_backup/'
              RMAN> list backup;