Monday, March 25, 2013

difference of backup info and resync catalog


I was wondering any difference of stored backup information stored in controlfile and catalog. So I use "list backup" examine this.
I also verify the need of using "resync catalog".

1. Use "rman target /"  and use RMAN catalog to list backup info respectively.
orarac1poc:DG:/home/oracle> rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Mar 25 10:52:52 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DG (DBID=1716975309)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
418     Full    192.38M    DISK        00:01:20     Mar 22 2013 17:33:19
        BP Key: 418   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173158
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_nnndf_TAG20130322T173158_8nr98j1l_.bkp
  List of Datafiles in backup set 418
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/system01.dbf
  2       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/sysaux01.dbf
  3       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/undotbs01.dbf
  4       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
419     95.00K     DISK        00:00:01     Mar 22 2013 17:33:29
        BP Key: 419   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173327
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_annnn_TAG20130322T173327_8nr9c8j1_.bkp

  List of Archived Logs in backup set 419
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
420     Full    12.67M     DISK        00:00:00     Mar 22 2013 17:33:31
        BP Key: 420   Status: AVAILABLE  Compressed: NO  Tag: TAG20130322T173331
        Piece Name: /u01/oradata/DG/FRA/DG/autobackup/2013_03_22/o1_mf_s_810754411_8nr9ccd0_.bkp
  SPFILE Included: Modification time: Mar 20 2013 10:34:26
  SPFILE db_unique_name: DG
  Control File Included: Ckp SCN: 12002541     Ckp time: Mar 22 2013 17:33:31

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
421     129.54M    DISK        00:00:44     Mar 23 2013 17:31:58
        BP Key: 421   Status: AVAILABLE  Compressed: YES  Tag: TAG20130323T173112
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_23/o1_mf_annnn_TAG20130323T173112_8ntxm4bj_.bkp

  List of Archived Logs in backup set 421
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1110    11859638   Mar 21 2013 17:33:05 11887592   Mar 21 2013 22:01:06
  1    1111    11887592   Mar 21 2013 22:01:06 11904714   Mar 22 2013 00:15:04
  1    1112    11904714   Mar 22 2013 00:15:04 11904870   Mar 22 2013 00:15:25
  1    1113    11904870   Mar 22 2013 00:15:25 11938520   Mar 22 2013 05:58:56
  1    1114    11938520   Mar 22 2013 05:58:56 11980445   Mar 22 2013 13:32:43
  1    1115    11980445   Mar 22 2013 13:32:43 12002231   Mar 22 2013 17:31:08
  1    1116    12002231   Mar 22 2013 17:31:08 12002254   Mar 22 2013 17:31:09
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
422     133.45M    DISK        00:00:45     Mar 24 2013 17:32:02
        BP Key: 422   Status: AVAILABLE  Compressed: YES  Tag: TAG20130324T173115
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_24/o1_mf_annnn_TAG20130324T173115_8nxkz5pn_.bkp

  List of Archived Logs in backup set 422
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10
  1    1126    12154478   Mar 23 2013 17:31:10 12189084   Mar 23 2013 23:24:43
  1    1127    12189084   Mar 23 2013 23:24:43 12195578   Mar 24 2013 00:17:42
  1    1128    12195578   Mar 24 2013 00:17:42 12229147   Mar 24 2013 06:00:03
  1    1129    12229147   Mar 24 2013 06:00:03 12235389   Mar 24 2013 06:02:19
  1    1130    12235389   Mar 24 2013 06:02:19 12268849   Mar 24 2013 11:40:46
  1    1131    12268849   Mar 24 2013 11:40:46 12302347   Mar 24 2013 17:31:11
  1    1132    12302347   Mar 24 2013 17:31:11 12302370   Mar 24 2013 17:31:13

RMAN> exit


Recovery Manager complete.
orarac1poc:DG:/home/oracle> rman target / catalog rman/rman123@RCAT

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Mar 25 10:54:46 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DG (DBID=1716975309)
connected to recovery catalog database

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
190275  Full    192.38M    DISK        00:01:20     Mar 22 2013 17:33:19
        BP Key: 190291   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173158
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_nnndf_TAG20130322T173158_8nr98j1l_.bkp
  List of Datafiles in backup set 190275
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/system01.dbf
  2       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/sysaux01.dbf
  3       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/undotbs01.dbf
  4       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190324  95.00K     DISK        00:00:01     Mar 22 2013 17:33:29
        BP Key: 190329   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173327
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_annnn_TAG20130322T173327_8nr9c8j1_.bkp

  List of Archived Logs in backup set 190324
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
190354  Full    12.67M     DISK        00:00:00     Mar 22 2013 17:33:31
        BP Key: 190356   Status: AVAILABLE  Compressed: NO  Tag: TAG20130322T173331
        Piece Name: /u01/oradata/DG/FRA/DG/autobackup/2013_03_22/o1_mf_s_810754411_8nr9ccd0_.bkp
  SPFILE Included: Modification time: Mar 20 2013 10:34:26
  SPFILE db_unique_name: DG
  Control File Included: Ckp SCN: 12002541     Ckp time: Mar 22 2013 17:33:31

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190617  129.54M    DISK        00:00:44     Mar 23 2013 17:31:58
        BP Key: 190620   Status: AVAILABLE  Compressed: YES  Tag: TAG20130323T173112
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_23/o1_mf_annnn_TAG20130323T173112_8ntxm4bj_.bkp

  List of Archived Logs in backup set 190617
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1110    11859638   Mar 21 2013 17:33:05 11887592   Mar 21 2013 22:01:06
  1    1111    11887592   Mar 21 2013 22:01:06 11904714   Mar 22 2013 00:15:04
  1    1112    11904714   Mar 22 2013 00:15:04 11904870   Mar 22 2013 00:15:25
  1    1113    11904870   Mar 22 2013 00:15:25 11938520   Mar 22 2013 05:58:56
  1    1114    11938520   Mar 22 2013 05:58:56 11980445   Mar 22 2013 13:32:43
  1    1115    11980445   Mar 22 2013 13:32:43 12002231   Mar 22 2013 17:31:08
  1    1116    12002231   Mar 22 2013 17:31:08 12002254   Mar 22 2013 17:31:09
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190920  133.45M    DISK        00:00:45     Mar 24 2013 17:32:02
        BP Key: 190937   Status: AVAILABLE  Compressed: YES  Tag: TAG20130324T173115
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_24/o1_mf_annnn_TAG20130324T173115_8nxkz5pn_.bkp

  List of Archived Logs in backup set 190920
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10
  1    1126    12154478   Mar 23 2013 17:31:10 12189084   Mar 23 2013 23:24:43
  1    1127    12189084   Mar 23 2013 23:24:43 12195578   Mar 24 2013 00:17:42
  1    1128    12195578   Mar 24 2013 00:17:42 12229147   Mar 24 2013 06:00:03
  1    1129    12229147   Mar 24 2013 06:00:03 12235389   Mar 24 2013 06:02:19
  1    1130    12235389   Mar 24 2013 06:02:19 12268849   Mar 24 2013 11:40:46
  1    1131    12268849   Mar 24 2013 11:40:46 12302347   Mar 24 2013 17:31:11
  1    1132    12302347   Mar 24 2013 17:31:11 12302370   Mar 24 2013 17:31:13

2. Compare above information with the help of WinMerge, which shows only "BS Key" and "BP Key" are different.



3. Next, I switched some redolog, and backup them while  using target database control file instead of recovery catalog.

orarac1poc:DG:/home/oracle> rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Mar 25 10:58:30 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DG (DBID=1716975309)

RMAN> backup archivelog all not backed up;

Starting backup at Mar 25 2013 10:59:09
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=67 device type=DISK
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_22/o1_mf_1_1117_8nr9c5n0_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_22/o1_mf_1_1118_8nrs0z37_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_23/o1_mf_1_1119_8ns0r591_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_23/o1_mf_1_1120_8ns0z3mr_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_23/o1_mf_1_1121_8nso3r25_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_23/o1_mf_1_1122_8nsqwvts_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_23/o1_mf_1_1123_8ntcg8z1_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_23/o1_mf_1_1124_8ntxlx6q_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_23/o1_mf_1_1125_8ntxlyg2_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_23/o1_mf_1_1126_8nvl9voy_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_24/o1_mf_1_1127_8nvof6v8_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_24/o1_mf_1_1128_8nw9h4k6_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_24/o1_mf_1_1129_8nw9md2p_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_24/o1_mf_1_1130_8nwxfywl_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_24/o1_mf_1_1131_8nxkyzrm_.arc; already backed on Mar 24 2013 17:32:02
skipping archived log file /u01/oradata/DG/FRA/DG/archivelog/2013_03_24/o1_mf_1_1132_8nxkz2gh_.arc; already backed on Mar 24 2013 17:32:02
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1133 RECID=3946 STAMP=810946827
input archived log thread=1 sequence=1134 RECID=3949 STAMP=810951525
input archived log thread=1 sequence=1135 RECID=3952 STAMP=810966637
input archived log thread=1 sequence=1136 RECID=3955 STAMP=810989558
input archived log thread=1 sequence=1137 RECID=3958 STAMP=810989563
input archived log thread=1 sequence=1138 RECID=3961 STAMP=810989949
channel ORA_DISK_1: starting piece 1 at Mar 25 2013 10:59:11
channel ORA_DISK_1: finished piece 1 at Mar 25 2013 10:59:26
piece handle=/u01/oradata/DG/FRA/DG/backupset/2013_03_25/o1_mf_annnn_TAG20130325T105910_8nzhcz69_.bkp tag=TAG20130325T105910 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at Mar 25 2013 10:59:26

Starting Control File and SPFILE Autobackup at Mar 25 2013 10:59:26
piece handle=/u01/oradata/DG/FRA/DG/autobackup/2013_03_25/o1_mf_s_810989966_8nzhdgp4_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at Mar 25 2013 10:59:27

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
418     Full    192.38M    DISK        00:01:20     Mar 22 2013 17:33:19
        BP Key: 418   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173158
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_nnndf_TAG20130322T173158_8nr98j1l_.bkp
  List of Datafiles in backup set 418
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/system01.dbf
  2       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/sysaux01.dbf
  3       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/undotbs01.dbf
  4       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
419     95.00K     DISK        00:00:01     Mar 22 2013 17:33:29
        BP Key: 419   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173327
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_annnn_TAG20130322T173327_8nr9c8j1_.bkp

  List of Archived Logs in backup set 419
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
420     Full    12.67M     DISK        00:00:00     Mar 22 2013 17:33:31
        BP Key: 420   Status: AVAILABLE  Compressed: NO  Tag: TAG20130322T173331
        Piece Name: /u01/oradata/DG/FRA/DG/autobackup/2013_03_22/o1_mf_s_810754411_8nr9ccd0_.bkp
  SPFILE Included: Modification time: Mar 20 2013 10:34:26
  SPFILE db_unique_name: DG
  Control File Included: Ckp SCN: 12002541     Ckp time: Mar 22 2013 17:33:31

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
421     129.54M    DISK        00:00:44     Mar 23 2013 17:31:58
        BP Key: 421   Status: AVAILABLE  Compressed: YES  Tag: TAG20130323T173112
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_23/o1_mf_annnn_TAG20130323T173112_8ntxm4bj_.bkp

  List of Archived Logs in backup set 421
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1110    11859638   Mar 21 2013 17:33:05 11887592   Mar 21 2013 22:01:06
  1    1111    11887592   Mar 21 2013 22:01:06 11904714   Mar 22 2013 00:15:04
  1    1112    11904714   Mar 22 2013 00:15:04 11904870   Mar 22 2013 00:15:25
  1    1113    11904870   Mar 22 2013 00:15:25 11938520   Mar 22 2013 05:58:56
  1    1114    11938520   Mar 22 2013 05:58:56 11980445   Mar 22 2013 13:32:43
  1    1115    11980445   Mar 22 2013 13:32:43 12002231   Mar 22 2013 17:31:08
  1    1116    12002231   Mar 22 2013 17:31:08 12002254   Mar 22 2013 17:31:09
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
422     133.45M    DISK        00:00:45     Mar 24 2013 17:32:02
        BP Key: 422   Status: AVAILABLE  Compressed: YES  Tag: TAG20130324T173115
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_24/o1_mf_annnn_TAG20130324T173115_8nxkz5pn_.bkp

  List of Archived Logs in backup set 422
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10
  1    1126    12154478   Mar 23 2013 17:31:10 12189084   Mar 23 2013 23:24:43
  1    1127    12189084   Mar 23 2013 23:24:43 12195578   Mar 24 2013 00:17:42
  1    1128    12195578   Mar 24 2013 00:17:42 12229147   Mar 24 2013 06:00:03
  1    1129    12229147   Mar 24 2013 06:00:03 12235389   Mar 24 2013 06:02:19
  1    1130    12235389   Mar 24 2013 06:02:19 12268849   Mar 24 2013 11:40:46
  1    1131    12268849   Mar 24 2013 11:40:46 12302347   Mar 24 2013 17:31:11
  1    1132    12302347   Mar 24 2013 17:31:11 12302370   Mar 24 2013 17:31:13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
423     40.17M     DISK        00:00:12     Mar 25 2013 10:59:23
        BP Key: 423   Status: AVAILABLE  Compressed: YES  Tag: TAG20130325T105910
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_25/o1_mf_annnn_TAG20130325T105910_8nzhcz69_.bkp

  List of Archived Logs in backup set 423
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1133    12302370   Mar 24 2013 17:31:13 12335068   Mar 24 2013 23:00:26
  1    1134    12335068   Mar 24 2013 23:00:26 12343393   Mar 25 2013 00:18:44
  1    1135    12343393   Mar 25 2013 00:18:44 12368693   Mar 25 2013 04:30:35
  1    1136    12368693   Mar 25 2013 04:30:35 12403541   Mar 25 2013 10:52:37
  1    1137    12403541   Mar 25 2013 10:52:37 12403550   Mar 25 2013 10:52:43
  1    1138    12403550   Mar 25 2013 10:52:43 12404127   Mar 25 2013 10:59:09

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
424     Full    12.67M     DISK        00:00:00     Mar 25 2013 10:59:26
        BP Key: 424   Status: AVAILABLE  Compressed: NO  Tag: TAG20130325T105926
        Piece Name: /u01/oradata/DG/FRA/DG/autobackup/2013_03_25/o1_mf_s_810989966_8nzhdgp4_.bkp
  SPFILE Included: Modification time: Mar 25 2013 10:48:30
  SPFILE db_unique_name: DG
  Control File Included: Ckp SCN: 12404165     Ckp time: Mar 25 2013 10:59:26

RMAN> exit


4. Next I observe if the backup information is automatically synchronized to recovery catalog data.

orarac1poc:DG:/home/oracle> rman target / catalog rman/rman123@RCAT

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Mar 25 10:59:49 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DG (DBID=1716975309)
connected to recovery catalog database

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
190275  Full    192.38M    DISK        00:01:20     Mar 22 2013 17:33:19
        BP Key: 190291   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173158
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_nnndf_TAG20130322T173158_8nr98j1l_.bkp
  List of Datafiles in backup set 190275
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/system01.dbf
  2       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/sysaux01.dbf
  3       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/undotbs01.dbf
  4       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190324  95.00K     DISK        00:00:01     Mar 22 2013 17:33:29
        BP Key: 190329   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173327
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_annnn_TAG20130322T173327_8nr9c8j1_.bkp

  List of Archived Logs in backup set 190324
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
190354  Full    12.67M     DISK        00:00:00     Mar 22 2013 17:33:31
        BP Key: 190356   Status: AVAILABLE  Compressed: NO  Tag: TAG20130322T173331
        Piece Name: /u01/oradata/DG/FRA/DG/autobackup/2013_03_22/o1_mf_s_810754411_8nr9ccd0_.bkp
  SPFILE Included: Modification time: Mar 20 2013 10:34:26
  SPFILE db_unique_name: DG
  Control File Included: Ckp SCN: 12002541     Ckp time: Mar 22 2013 17:33:31

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190617  129.54M    DISK        00:00:44     Mar 23 2013 17:31:58
        BP Key: 190620   Status: AVAILABLE  Compressed: YES  Tag: TAG20130323T173112
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_23/o1_mf_annnn_TAG20130323T173112_8ntxm4bj_.bkp

  List of Archived Logs in backup set 190617
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1110    11859638   Mar 21 2013 17:33:05 11887592   Mar 21 2013 22:01:06
  1    1111    11887592   Mar 21 2013 22:01:06 11904714   Mar 22 2013 00:15:04
  1    1112    11904714   Mar 22 2013 00:15:04 11904870   Mar 22 2013 00:15:25
  1    1113    11904870   Mar 22 2013 00:15:25 11938520   Mar 22 2013 05:58:56
  1    1114    11938520   Mar 22 2013 05:58:56 11980445   Mar 22 2013 13:32:43
  1    1115    11980445   Mar 22 2013 13:32:43 12002231   Mar 22 2013 17:31:08
  1    1116    12002231   Mar 22 2013 17:31:08 12002254   Mar 22 2013 17:31:09
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190920  133.45M    DISK        00:00:45     Mar 24 2013 17:32:02
        BP Key: 190937   Status: AVAILABLE  Compressed: YES  Tag: TAG20130324T173115
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_24/o1_mf_annnn_TAG20130324T173115_8nxkz5pn_.bkp

  List of Archived Logs in backup set 190920
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10
  1    1126    12154478   Mar 23 2013 17:31:10 12189084   Mar 23 2013 23:24:43
  1    1127    12189084   Mar 23 2013 23:24:43 12195578   Mar 24 2013 00:17:42
  1    1128    12195578   Mar 24 2013 00:17:42 12229147   Mar 24 2013 06:00:03
  1    1129    12229147   Mar 24 2013 06:00:03 12235389   Mar 24 2013 06:02:19
  1    1130    12235389   Mar 24 2013 06:02:19 12268849   Mar 24 2013 11:40:46
  1    1131    12268849   Mar 24 2013 11:40:46 12302347   Mar 24 2013 17:31:11
  1    1132    12302347   Mar 24 2013 17:31:11 12302370   Mar 24 2013 17:31:13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
191069  40.17M     DISK        00:00:12     Mar 25 2013 10:59:23
        BP Key: 191087   Status: AVAILABLE  Compressed: YES  Tag: TAG20130325T105910
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_25/o1_mf_annnn_TAG20130325T105910_8nzhcz69_.bkp

  List of Archived Logs in backup set 191069
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1133    12302370   Mar 24 2013 17:31:13 12335068   Mar 24 2013 23:00:26
  1    1134    12335068   Mar 24 2013 23:00:26 12343393   Mar 25 2013 00:18:44
  1    1135    12343393   Mar 25 2013 00:18:44 12368693   Mar 25 2013 04:30:35
  1    1136    12368693   Mar 25 2013 04:30:35 12403541   Mar 25 2013 10:52:37
  1    1137    12403541   Mar 25 2013 10:52:37 12403550   Mar 25 2013 10:52:43
  1    1138    12403550   Mar 25 2013 10:52:43 12404127   Mar 25 2013 10:59:09

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
191070  Full    12.67M     DISK        00:00:00     Mar 25 2013 10:59:26
        BP Key: 191088   Status: AVAILABLE  Compressed: NO  Tag: TAG20130325T105926
        Piece Name: /u01/oradata/DG/FRA/DG/autobackup/2013_03_25/o1_mf_s_810989966_8nzhdgp4_.bkp
  SPFILE Included: Modification time: Mar 25 2013 10:48:30
  SPFILE db_unique_name: DG
  Control File Included: Ckp SCN: 12404165     Ckp time: Mar 25 2013 10:59:26


-- test resync command


RMAN> resync catalog;

starting full resync of recovery catalog
full resync complete

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
190275  Full    192.38M    DISK        00:01:20     Mar 22 2013 17:33:19
        BP Key: 190291   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173158
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_nnndf_TAG20130322T173158_8nr98j1l_.bkp
  List of Datafiles in backup set 190275
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/system01.dbf
  2       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/sysaux01.dbf
  3       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/undotbs01.dbf
  4       Full 12002349   Mar 22 2013 17:31:59 /u01/oradata/DG/users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190324  95.00K     DISK        00:00:01     Mar 22 2013 17:33:29
        BP Key: 190329   Status: AVAILABLE  Compressed: YES  Tag: TAG20130322T173327
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_22/o1_mf_annnn_TAG20130322T173327_8nr9c8j1_.bkp

  List of Archived Logs in backup set 190324
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
190354  Full    12.67M     DISK        00:00:00     Mar 22 2013 17:33:31
        BP Key: 190356   Status: AVAILABLE  Compressed: NO  Tag: TAG20130322T173331
        Piece Name: /u01/oradata/DG/FRA/DG/autobackup/2013_03_22/o1_mf_s_810754411_8nr9ccd0_.bkp
  SPFILE Included: Modification time: Mar 20 2013 10:34:26
  SPFILE db_unique_name: DG
  Control File Included: Ckp SCN: 12002541     Ckp time: Mar 22 2013 17:33:31

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190617  129.54M    DISK        00:00:44     Mar 23 2013 17:31:58
        BP Key: 190620   Status: AVAILABLE  Compressed: YES  Tag: TAG20130323T173112
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_23/o1_mf_annnn_TAG20130323T173112_8ntxm4bj_.bkp

  List of Archived Logs in backup set 190617
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1110    11859638   Mar 21 2013 17:33:05 11887592   Mar 21 2013 22:01:06
  1    1111    11887592   Mar 21 2013 22:01:06 11904714   Mar 22 2013 00:15:04
  1    1112    11904714   Mar 22 2013 00:15:04 11904870   Mar 22 2013 00:15:25
  1    1113    11904870   Mar 22 2013 00:15:25 11938520   Mar 22 2013 05:58:56
  1    1114    11938520   Mar 22 2013 05:58:56 11980445   Mar 22 2013 13:32:43
  1    1115    11980445   Mar 22 2013 13:32:43 12002231   Mar 22 2013 17:31:08
  1    1116    12002231   Mar 22 2013 17:31:08 12002254   Mar 22 2013 17:31:09
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
190920  133.45M    DISK        00:00:45     Mar 24 2013 17:32:02
        BP Key: 190937   Status: AVAILABLE  Compressed: YES  Tag: TAG20130324T173115
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_24/o1_mf_annnn_TAG20130324T173115_8nxkz5pn_.bkp

  List of Archived Logs in backup set 190920
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1117    12002254   Mar 22 2013 17:31:09 12002497   Mar 22 2013 17:33:25
  1    1118    12002497   Mar 22 2013 17:33:25 12030401   Mar 22 2013 22:01:02
  1    1119    12030401   Mar 22 2013 22:01:02 12046737   Mar 23 2013 00:12:52
  1    1120    12046737   Mar 23 2013 00:12:52 12047887   Mar 23 2013 00:16:35
  1    1121    12047887   Mar 23 2013 00:16:35 12083373   Mar 23 2013 06:00:23
  1    1122    12083373   Mar 23 2013 06:00:23 12092352   Mar 23 2013 06:47:55
  1    1123    12092352   Mar 23 2013 06:47:55 12125083   Mar 23 2013 12:21:28
  1    1124    12125083   Mar 23 2013 12:21:28 12154463   Mar 23 2013 17:31:08
  1    1125    12154463   Mar 23 2013 17:31:08 12154478   Mar 23 2013 17:31:10
  1    1126    12154478   Mar 23 2013 17:31:10 12189084   Mar 23 2013 23:24:43
  1    1127    12189084   Mar 23 2013 23:24:43 12195578   Mar 24 2013 00:17:42
  1    1128    12195578   Mar 24 2013 00:17:42 12229147   Mar 24 2013 06:00:03
  1    1129    12229147   Mar 24 2013 06:00:03 12235389   Mar 24 2013 06:02:19
  1    1130    12235389   Mar 24 2013 06:02:19 12268849   Mar 24 2013 11:40:46
  1    1131    12268849   Mar 24 2013 11:40:46 12302347   Mar 24 2013 17:31:11
  1    1132    12302347   Mar 24 2013 17:31:11 12302370   Mar 24 2013 17:31:13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
191069  40.17M     DISK        00:00:12     Mar 25 2013 10:59:23
        BP Key: 191087   Status: AVAILABLE  Compressed: YES  Tag: TAG20130325T105910
        Piece Name: /u01/oradata/DG/FRA/DG/backupset/2013_03_25/o1_mf_annnn_TAG20130325T105910_8nzhcz69_.bkp

  List of Archived Logs in backup set 191069
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    1133    12302370   Mar 24 2013 17:31:13 12335068   Mar 24 2013 23:00:26
  1    1134    12335068   Mar 24 2013 23:00:26 12343393   Mar 25 2013 00:18:44
  1    1135    12343393   Mar 25 2013 00:18:44 12368693   Mar 25 2013 04:30:35
  1    1136    12368693   Mar 25 2013 04:30:35 12403541   Mar 25 2013 10:52:37
  1    1137    12403541   Mar 25 2013 10:52:37 12403550   Mar 25 2013 10:52:43
  1    1138    12403550   Mar 25 2013 10:52:43 12404127   Mar 25 2013 10:59:09

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
191070  Full    12.67M     DISK        00:00:00     Mar 25 2013 10:59:26
        BP Key: 191088   Status: AVAILABLE  Compressed: NO  Tag: TAG20130325T105926
        Piece Name: /u01/oradata/DG/FRA/DG/autobackup/2013_03_25/o1_mf_s_810989966_8nzhdgp4_.bkp
  SPFILE Included: Modification time: Mar 25 2013 10:48:30
  SPFILE db_unique_name: DG
  Control File Included: Ckp SCN: 12404165     Ckp time: Mar 25 2013 10:59:26

5. Use WinMerge to compare them again, which shows backup information is automatically synchronized to recovery catalog data.
Maybe under most situation, we don't have to invoke the resync command.

6. Issue "resync catalog" and list backup again. From WinMerge, theresult is identical.













7. Further reading and I find :
Manually resynchronize the recovery catalog in the following situations:
• After the recovery catalog was unavailable for RMAN to automatically resynchronize it
• When you perform infrequent backups of your target database
• After making changes to the physical structure of the target database