11 Replies Latest reply: Jul 25, 2013 3:22 AM by 891135 RSS

    Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)

    891135

      Hi All,

      Please help to understand the below scenario.

       

      A database is running in nocatalog mode.Now the situation is that the incremental level 0 backup of the database was taken on 4th July.. since then incremental level 1 backup was taken till today i.e 19th july and in the meantime no full backup was taken..The controlfile_record_keep_time is 7 days.Now if any user asks to restore and recover the database until 15th july will that be possible ? Will the data in the conrolfile be overwritten because controlfile_record_keep_time is 7 days and no record will be shown of 4th july backup ? Please help to understand.

        • 1. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
          Hemant K Chitale

          Why not query the controlfile with a simple LIST BACKUP ?

           

          Apparently, you don't have regular (i.e. scheduled) backups. 

           

          Hemant K Chitale


          • 2. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
            891135

            Hi Heamant,

            Blow is the output of list backup..Please help me to understand here as I was under the impression that since the control_file_record_keep_time is 3 it will keep 3 days old record and delete the old records including records of backup..

             

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            1       Incr 0  80.00K     DISK        00:00:00     19-JUL-13
                    BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T065051
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_4_821170252
              SPFILE Included: Modification time: 19-JUL-13
              SPFILE db_unique_name: THUB

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            2       Incr 0  33.27M     DISK        00:00:02     19-JUL-13
                    BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T065051
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_2_821170252
              Control File Included: Ckp SCN: 12633631356657   Ckp time: 19-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            3       Incr 0  1.21G      DISK        00:06:23     19-JUL-13
                    BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T065832
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_7_821170713
              List of Datafiles in backup set 3
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              6    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/ctxd01.dbf
              9    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/odm.dbf
              10   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/olap.dbf
              17   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_int02.dbf
              18   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/sysaux02.dbf
              19   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/sysaux03.dbf
              21   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/oim1.dbf
              22   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/bmc01.dbf
              27   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/users_1.dbf
              354  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system11.dbf
              379  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/undo01.dbf
              399  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_queue01.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            4       Incr 0  33.27M     DISK        00:00:05     19-JUL-13
                    BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T065832
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_11_821171098
              Control File Included: Ckp SCN: 12633631356831   Ckp time: 19-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            5       Incr 0  80.00K     DISK        00:00:00     19-JUL-13
                    BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T065832
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_12_821171104
              SPFILE Included: Modification time: 19-JUL-13
              SPFILE db_unique_name: THUB

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            6       Incr 0  8.31G      DISK        00:08:21     19-JUL-13
                    BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T065832
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_10_821170713
              List of Datafiles in backup set 6
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              1    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system01.dbf
              4    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system04.dbf
              15   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind06.dbf
              20   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/hig_custom_data_1.dbf
              288  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system10.dbf
              295  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system06.dbf
              314  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/portal01.dbf
              397  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_nolog01.dbf
              400  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_media01.dbf
              403  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind02.dbf
              405  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind04.dbf
              407  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_ref02.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            7       Incr 0  9.14G      DISK        00:08:52     19-JUL-13
                    BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T065832
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_8_821170713
              List of Datafiles in backup set 7
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              3    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system03.dbf
              8    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_queue02.dbf
              16   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_ref03.dbf
              351  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system07.dbf
              352  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system09.dbf
              353  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system08.dbf
              393  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind01.dbf
              398  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_archive01.dbf
              401  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data02.dbf
              402  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data03.dbf
              404  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind03.dbf
              406  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind05.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            8       Incr 0  9.30G      DISK        00:09:21     19-JUL-13
                    BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T065832
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_9_821170713
              List of Datafiles in backup set 8
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              2    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system02.dbf
              5    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system05.dbf
              7    0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/owad01.dbf
              11   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/sysaux01.dbf
              12   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/apps_ts_tools01.dbf
              13   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/system12.dbf
              14   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data04.dbf
              28   0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/hig_accounting_data_1.dbf
              392  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data01.dbf
              394  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_ref01.dbf
              395  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_int01.dbf
              396  0  Incr 12633631356831 19-JUL-13 /acac_qpip/data01/thub_restore/a_summ01.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            9       Full    33.27M     DISK        00:00:03     19-JUL-13
                    BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T070759
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_13_821171280
              Control File Included: Ckp SCN: 12633631356831   Ckp time: 19-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            10      Incr 1  80.00K     DISK        00:00:00     19-JUL-13
                    BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T071519
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_17_821171720
              SPFILE Included: Modification time: 19-JUL-13
              SPFILE db_unique_name: THUB

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            11      Incr 1  33.27M     DISK        00:00:02     19-JUL-13
                    BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T071519
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_15_821171720
              Control File Included: Ckp SCN: 12633631356831   Ckp time: 19-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            12      Full    33.27M     DISK        00:00:01     19-JUL-13
                    BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20130719T071523
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_20_821171723
              Control File Included: Ckp SCN: 12633631356831   Ckp time: 19-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            13      Incr 1  80.00K     DISK        00:00:00     20-JUL-13
                    BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T032324
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_24_821244206
              SPFILE Included: Modification time: 19-JUL-13
              SPFILE db_unique_name: THUB

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            14      Incr 1  33.27M     DISK        00:00:04     20-JUL-13
                    BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T032324
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_22_821244206
              Control File Included: Ckp SCN: 12633631527384   Ckp time: 20-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            15      Incr 1  1.30M      DISK        00:05:39     20-JUL-13
                    BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T032754
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_28_821244475
              List of Datafiles in backup set 15
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              3    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system03.dbf
              8    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_queue02.dbf
              16   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_ref03.dbf
              351  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system07.dbf
              352  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system09.dbf
              353  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system08.dbf
              393  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind01.dbf
              398  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_archive01.dbf
              401  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data02.dbf
              402  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data03.dbf
              404  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind03.dbf
              406  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind05.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            16      Incr 1  65.79M     DISK        00:05:41     20-JUL-13
                    BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T032754
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_27_821244475
              List of Datafiles in backup set 16
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              6    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/ctxd01.dbf
              9    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/odm.dbf
              10   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/olap.dbf
              17   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_int02.dbf
              18   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/sysaux02.dbf
              19   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/sysaux03.dbf
              21   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/oim1.dbf
              22   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/bmc01.dbf
              27   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/users_1.dbf
              354  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system11.dbf
              379  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/undo01.dbf
              399  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_queue01.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            17      Incr 1  80.00K     DISK        00:00:00     20-JUL-13
                    BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T032754
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_32_821244821
              SPFILE Included: Modification time: 20-JUL-13
              SPFILE db_unique_name: THUB

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            18      Incr 1  33.27M     DISK        00:00:02     20-JUL-13
                    BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T032754
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_31_821244820
              Control File Included: Ckp SCN: 12633631529457   Ckp time: 20-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            19      Incr 1  17.05M     DISK        00:05:54     20-JUL-13
                    BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T032754
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_30_821244475
              List of Datafiles in backup set 19
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              1    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system01.dbf
              4    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system04.dbf
              15   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind06.dbf
              20   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/hig_custom_data_1.dbf
              288  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system10.dbf
              295  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system06.dbf
              314  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/portal01.dbf
              397  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_nolog01.dbf
              400  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_media01.dbf
              403  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind02.dbf
              405  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind04.dbf
              407  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_ref02.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            20      Incr 1  36.15M     DISK        00:06:05     20-JUL-13
                    BP Key: 20   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T032754
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_29_821244475
              List of Datafiles in backup set 20
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              2    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system02.dbf
              5    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system05.dbf
              7    1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/owad01.dbf
              11   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/sysaux01.dbf
              12   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/apps_ts_tools01.dbf
              13   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/system12.dbf
              14   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data04.dbf
              28   1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/hig_accounting_data_1.dbf
              392  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data01.dbf
              394  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_ref01.dbf
              395  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_int01.dbf
              396  1  Incr 12633631529457 20-JUL-13 /acac_qpip/data01/thub_restore/a_summ01.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            21      Full    33.27M     DISK        00:00:01     20-JUL-13
                    BP Key: 21   Status: AVAILABLE  Compressed: NO  Tag: TAG20130720T033407
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_33_821244847
              Control File Included: Ckp SCN: 12633631529457   Ckp time: 20-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            22      Incr 1  80.00K     DISK        00:00:00     22-JUL-13
                    BP Key: 22   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214637
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_37_821483199
              SPFILE Included: Modification time: 20-JUL-13
              SPFILE db_unique_name: THUB

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            23      Incr 1  33.27M     DISK        00:00:02     22-JUL-13
                    BP Key: 23   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214637
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_35_821483199
              Control File Included: Ckp SCN: 12633631529457   Ckp time: 20-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            24      Full    33.27M     DISK        00:00:01     22-JUL-13
                    BP Key: 24   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214642
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_40_821483202
              Control File Included: Ckp SCN: 12633631529457   Ckp time: 20-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            25      Incr 1  2.05M      DISK        00:05:10     22-JUL-13
                    BP Key: 25   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214958
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_41_821483399
              List of Datafiles in backup set 25
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              6    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/ctxd01.dbf
              9    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/odm.dbf
              10   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/olap.dbf
              17   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_int02.dbf
              18   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/sysaux02.dbf
              19   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/sysaux03.dbf
              21   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/oim1.dbf
              22   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/bmc01.dbf
              27   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/users_1.dbf
              354  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system11.dbf
              379  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/undo01.dbf
              399  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_queue01.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            26      Incr 1  216.00K    DISK        00:05:14     22-JUL-13
                    BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214958
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_42_821483399
              List of Datafiles in backup set 26
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              3    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system03.dbf
              8    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_queue02.dbf
              16   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_ref03.dbf
              351  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system07.dbf
              352  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system09.dbf
              353  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system08.dbf
              393  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind01.dbf
              398  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_archive01.dbf
              401  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data02.dbf
              402  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data03.dbf
              404  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind03.dbf
              406  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind05.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            27      Incr 1  80.00K     DISK        00:00:00     22-JUL-13
                    BP Key: 27   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214958
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_46_821483715
              SPFILE Included: Modification time: 20-JUL-13
              SPFILE db_unique_name: THUB

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            28      Incr 1  33.27M     DISK        00:00:01     22-JUL-13
                    BP Key: 28   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214958
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_45_821483715
              Control File Included: Ckp SCN: 12633631530437   Ckp time: 22-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            29      Incr 1  16.79M     DISK        00:05:23     22-JUL-13
                    BP Key: 29   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214958
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_44_821483399
              List of Datafiles in backup set 29
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              1    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system01.dbf
              4    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system04.dbf
              15   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind06.dbf
              20   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/hig_custom_data_1.dbf
              288  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system10.dbf
              295  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system06.dbf
              314  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/portal01.dbf
              397  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_nolog01.dbf
              400  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_media01.dbf
              403  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind02.dbf
              405  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind04.dbf
              407  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_ref02.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            30      Incr 1  20.19M     DISK        00:05:30     22-JUL-13
                    BP Key: 30   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T214958
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_43_821483399
              List of Datafiles in backup set 30
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              2    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system02.dbf
              5    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system05.dbf
              7    1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/owad01.dbf
              11   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/sysaux01.dbf
              12   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/apps_ts_tools01.dbf
              13   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/system12.dbf
              14   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data04.dbf
              28   1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/hig_accounting_data_1.dbf
              392  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data01.dbf
              394  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_ref01.dbf
              395  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_int01.dbf
              396  1  Incr 12633631530437 22-JUL-13 /acac_qpip/data01/thub_restore/a_summ01.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            31      Full    33.27M     DISK        00:00:01     22-JUL-13
                    BP Key: 31   Status: AVAILABLE  Compressed: NO  Tag: TAG20130722T215531
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_47_821483731
              Control File Included: Ckp SCN: 12633631530437   Ckp time: 22-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            32      Full    33.27M     DISK        00:00:01     23-JUL-13
                    BP Key: 32   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T185029
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_52_821559030
              Control File Included: Ckp SCN: 12633631530437   Ckp time: 22-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            33      Full    33.30M     DISK        00:00:01     23-JUL-13
                    BP Key: 33   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T185033
                    Piece Name: /tech/oracle/product/11.2.0.3_FAH/dbs/c-448384833-20130723-00
              SPFILE Included: Modification time: 20-JUL-13
              SPFILE db_unique_name: THUB
              Control File Included: Ckp SCN: 12633631530437   Ckp time: 22-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            34      Full    33.27M     DISK        00:00:02     23-JUL-13
                    BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T185212
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_58_821559132
              Control File Included: Ckp SCN: 12633631530437   Ckp time: 22-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            35      Full    33.30M     DISK        00:00:01     23-JUL-13
                    BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T185214
                    Piece Name: /tech/oracle/product/11.2.0.3_FAH/dbs/c-448384833-20130723-01
              SPFILE Included: Modification time: 20-JUL-13
              SPFILE db_unique_name: THUB
              Control File Included: Ckp SCN: 12633631530437   Ckp time: 22-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            36      Incr 1  128.00K    DISK        00:05:16     23-JUL-13
                    BP Key: 36   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T191635
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_61_821560596
              List of Datafiles in backup set 36
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              3    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system03.dbf
              8    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_queue02.dbf
              16   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_ref03.dbf
              351  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system07.dbf
              352  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system09.dbf
              353  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system08.dbf
              393  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind01.dbf
              398  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_archive01.dbf
              401  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data02.dbf
              402  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data03.dbf
              404  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind03.dbf
              406  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind05.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            37      Incr 1  4.00M      DISK        00:05:19     23-JUL-13
                    BP Key: 37   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T191635
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_60_821560595
              List of Datafiles in backup set 37
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              6    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/ctxd01.dbf
              9    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/odm.dbf
              17   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_int02.dbf
              18   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/sysaux02.dbf
              19   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/sysaux03.dbf
              21   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/oim1.dbf
              22   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/bmc01.dbf
              23   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/test1.dbf
              354  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system11.dbf
              379  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/undo01.dbf
              399  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_queue01.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            38      Incr 1  16.77M     DISK        00:05:27     23-JUL-13
                    BP Key: 38   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T191635
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_63_821560596
              List of Datafiles in backup set 38
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              1    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system01.dbf
              4    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system04.dbf
              10   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/olap.dbf
              15   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind06.dbf
              20   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/hig_custom_data_1.dbf
              288  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system10.dbf
              295  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system06.dbf
              314  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/portal01.dbf
              397  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_nolog01.dbf
              400  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_media01.dbf
              403  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind02.dbf
              405  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_ind04.dbf
              407  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_ref02.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            39      Incr 1  21.27M     DISK        00:05:31     23-JUL-13
                    BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T191635
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_62_821560596
              List of Datafiles in backup set 39
              File LV Type Ckp SCN    Ckp Time  Name
              ---- -- ---- ---------- --------- ----
              2    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system02.dbf
              5    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system05.dbf
              7    1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/owad01.dbf
              11   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/sysaux01.dbf
              12   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/apps_ts_tools01.dbf
              13   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/system12.dbf
              14   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data04.dbf
              27   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/users_1.dbf
              28   1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/hig_accounting_data_1.dbf
              392  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_txn_data01.dbf
              394  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_ref01.dbf
              395  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_int01.dbf
              396  1  Incr 12633631533042 23-JUL-13 /acac_qpip/data01/thub_restore/a_summ01.dbf

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            40      Full    33.27M     DISK        00:00:02     23-JUL-13
                    BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T192211
                    Piece Name: /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_64_821560931
              Control File Included: Ckp SCN: 12633631533042   Ckp time: 23-JUL-13

            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
            ------- ---- -- ---------- ----------- ------------ ---------------
            41      Full    33.30M     DISK        00:00:01     23-JUL-13
                    BP Key: 41   Status: AVAILABLE  Compressed: NO  Tag: TAG20130723T192213
                    Piece Name: /tech/oracle/product/11.2.0.3_FAH/dbs/c-448384833-20130723-02
              SPFILE Included: Modification time: 23-JUL-13
              SPFILE db_unique_name: THUB
              Control File Included: Ckp SCN: 12633631533042   Ckp time: 23-JUL-13

            RMAN>

            • 3. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
              Hemant K Chitale

              The L0 backup was on 19-July.  Oracle *has* to maintain information about the the L0 backup that meets the Retention Policy.  So the L0 backup and all subsequent backups are retained.

              If it were to purge information about the 19-Jul backup, it would lose the ability to restore your database because it would lose the L0 backup.

               

              Hemant K Chitale

              • 4. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
                891135

                Thanks Hemant..

                 

                The retention policy of the database is as follows:-

                 

                RMAN> show all;

                RMAN configuration parameters for database with db_unique_name THUB are:
                CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

                 

                So as per the retention policy it should reatin the information of at least one L0 backup in the controlfile and it will not matter whatever the controlfile_record_keep_time is defined.. Am I correct ? Also if I take another L0 backup now as per the retention policy it will not keep the information of 19-July l) backup..Please correct me if I am wrong..

                • 5. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
                  Hemant K Chitale

                  If you take a fresh L0 backup, it may yet keep information about older backups if there is enough space in the controlfile.  However, it will mark the older backup as "OBSOLETE".

                   

                  Hemant K Chitale

                  • 6. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
                    891135

                    Thanks a ton Hemant.. Appreciate your help ..

                    • 7. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
                      EdStevens

                      HemantKChitale wrote:

                       

                      If you take a fresh L0 backup, it may yet keep information about older backups if there is enough space in the controlfile.  However, it will mark the older backup as "OBSOLETE".

                       

                      Hemant K Chitale

                       

                      "Point of order"

                       

                      I've never seen any evidence that any record of any backupset is marked as obsolete.  I believe that backupsets are evaluated for obsolescence whenever such determination needs to be made.  My own testing has shown that a previously obsolete backupset can be made un-obsolete merely by altering the retention policy.

                       

                      I will admit to having a nagging feeling that someone can prove me wrong.  If so I'd be happy to see the evidence.

                      • 8. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
                        Hemant K Chitale

                        I guess I erred.  I can find no evidence that they get "marked" as obsolete. The REPORT OBSOLETE command evaluates all the backups and identifies -- evaluates, as you've said -- the obsolete ones.  So the "obsolete" status isn't permanently stored as an attribute.

                         

                         

                        Hemant K Chitale

                        • 9. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
                          891135

                          Hemant,

                          I did a restore testing in the database where I have fired the command :-

                           

                          RMAN> run

                          2> {

                          3> set until time 'Jul 20 2013 06:57:10';

                          4> restore database;

                          5> recover database;

                          6> }

                           

                          I am surprised to find that the database was restored and recovered while my understanding is you cannot restore and recover from an obsolete backup.. Please suggest.

                           

                          RMAN> report obsolete;

                          RMAN retention policy will be applied to the command
                          RMAN retention policy is set to redundancy 1
                          Report of obsolete backups and copies
                          Type                 Key    Completion Time    Filename/Handle
                          -------------------- ------ ------------------ --------------------

                          Backup Set           14     20-JUL-13

                            Backup Piece       14     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_22_821244206

                          Backup Set           13     20-JUL-13

                            Backup Piece       13     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_24_821244206

                          Backup Set           16     20-JUL-13

                            Backup Piece       16     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_27_821244475

                          Backup Set           15     20-JUL-13

                            Backup Piece       15     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_28_821244475

                          Backup Set           20     20-JUL-13

                            Backup Piece       20     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_29_821244475

                          Backup Set           19     20-JUL-13

                            Backup Piece       19     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_30_821244475

                          Backup Set           18     20-JUL-13

                            Backup Piece       18     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_31_821244820

                          Backup Set           17     20-JUL-13

                            Backup Piece       17     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/DB_THUB_32_821244821

                          Backup Set           21     20-JUL-13

                            Backup Piece       21     20-JUL-13          /acac_qpip/data01/thub_restore/rman_bkp/cntrl_THUB_33_821244847

                          • 10. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
                            Hemant K Chitale

                            > my understanding is you cannot restore and recover from an obsolete backup

                             

                            An obsolete backup is one that is older than the retention policy.  It doesn't prevent a restore.

                             

                            Many DBA scripts run a "DELETE OBSOLETE" whereby Obsolete backups are deleted. That makes them non-restorable until they are recataloged with the CATALOG command.  Then, they can be used for a restore.

                             

                            Hemant K Chitale

                            • 11. Re: Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)
                              891135

                              Thanks again for the really helpful answers..