This discussion is archived
11 Replies Latest reply: Jul 25, 2013 1:22 AM by 891135 RSS

Confusion about recovery in nocatalog mode (Oracle 11.2.0.3)

891135 Newbie
Currently Being Moderated

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 Oracle ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    Thanks a ton Hemant.. Appreciate your help ..

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

    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 Oracle ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    > 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 Newbie
    Currently Being Moderated

    Thanks again for the really helpful answers..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points