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