In RAC or Single Instance environments with ASM, it is possible to run database backups to ASM (typically the FRA diskgroup).
Note : Timestamps are in UTC in the listings below
[oracle@srv1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 18 14:34:21 2025
Version 19.25.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.25.0.0.0
SQL> show parameter db_recover
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 13332M
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.25.0.0.0
[oracle@srv1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jun 18 14:34:49 2025
Version 19.25.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: RACDB (DBID=1162136313)
RMAN> backup as compressed backupset database plus archivelog delete input;
backup as compressed backupset database plus archivelog delete input;
Starting backup at 18-JUN-25
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=246 instance=RACDB1 device type=DISK
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=381 RECID=1257 STAMP=1199502152
input archived log thread=2 sequence=334 RECID=1258 STAMP=1199502185
input archived log thread=1 sequence=382 RECID=1260 STAMP=1199502404
...
...
...
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/RACDB/DATAFILE/system.257.1164519439
input datafile file number=00003 name=+DATA/RACDB/DATAFILE/sysaux.258.1164519463
input datafile file number=00004 name=+DATA/RACDB/DATAFILE/undotbs1.259.1164519479
input datafile file number=00009 name=+DATA/RACDB/DATAFILE/undotbs2.269.1164519893
input datafile file number=00007 name=+DATA/RACDB/DATAFILE/users.260.1164519479
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947 tag=TAG20250618T143546 comment=NONE
...
...
...
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=+DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/system.274.1164520333
input datafile file number=00011 name=+DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/sysaux.275.1164520333
input datafile file number=00012 name=+DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/undotbs1.273.1164520333
input datafile file number=00013 name=+DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/undo_2.277.1164520345
input datafile file number=00015 name=+DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users2.279.1167388913
input datafile file number=00016 name=+DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users3.280.1167388955
input datafile file number=00014 name=+DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users.278.1164520353
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
piece handle=+FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013 tag=TAG20250618T143546 comment=NONE
...
...
...
RMAN-08120: warning: archived log not deleted, not yet applied by standby
archived log file name=+FRA/RACDB/ARCHIVELOG/2025_06_18/thread_1_seq_403.402.1204123149 thread=1 sequence=403
RMAN-08120: warning: archived log not deleted, not yet applied by standby
archived log file name=+FRA/RACDB/ARCHIVELOG/2025_06_18/thread_2_seq_348.515.1204123149 thread=2 sequence=348
Finished backup at 18-JUN-25
Starting Control File and SPFILE Autobackup at 18-JUN-25
piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151 comment=NONE
Finished Control File and SPFILE Autobackup at 18-JUN-25
RMAN>
RMAN> list backupset completed after "trunc(sysdate)";
list backupset completed after "trunc(sysdate)";
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
337 57.35M DISK 00:00:03 18-JUN-25
BP Key: 337 Status: AVAILABLE Compressed: YES Tag: TAG20250618T143542
Piece Name: +FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943
List of Archived Logs in backup set 337
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
...
...
...
1 401 11161346 01-MAY-25 11165463 18-JUN-25
1 402 11165463 18-JUN-25 11177493 18-JUN-25
...
...
...
2 346 11161357 01-MAY-25 11161847 18-JUN-25
2 347 11161847 18-JUN-25 11177499 18-JUN-25
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
338 Full 1.07G DISK 00:00:57 18-JUN-25
BP Key: 338 Status: AVAILABLE Compressed: YES Tag: TAG20250618T143546
Piece Name: +FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947
List of Datafiles in backup set 338
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/system.257.1164519439
3 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/sysaux.258.1164519463
4 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/undotbs1.259.1164519479
7 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/users.260.1164519479
9 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/undotbs2.269.1164519893
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
339 Full 775.09M DISK 00:00:42 18-JUN-25
BP Key: 339 Status: AVAILABLE Compressed: YES Tag: TAG20250618T143546
Piece Name: +FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013
List of Datafiles in backup set 339
Container ID: 3, PDB Name: PDB1
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
10 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/system.274.1164520333
11 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/sysaux.275.1164520333
12 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/undotbs1.273.1164520333
13 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/undo_2.277.1164520345
14 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users.278.1164520353
15 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users2.279.1167388913
16 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users3.280.1167388955
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
340 Full 812.50M DISK 00:00:42 18-JUN-25
BP Key: 340 Status: AVAILABLE Compressed: YES Tag: TAG20250618T143546
Piece Name: +FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057
List of Datafiles in backup set 340
Container ID: 5, PDB Name: TSTPDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
25 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/system.281.1199369077
26 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/sysaux.283.1199369077
27 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/undotbs1.282.1199369077
28 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/undo_2.285.1199369085
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
341 Full 812.46M DISK 00:00:42 18-JUN-25
BP Key: 341 Status: AVAILABLE Compressed: YES Tag: TAG20250618T143546
Piece Name: +FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103
List of Datafiles in backup set 341
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.265.1164519659
6 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.266.1164519659
8 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1164519659
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
342 674.00K DISK 00:00:00 18-JUN-25
BP Key: 342 Status: AVAILABLE Compressed: YES Tag: TAG20250618T143909
Piece Name: +FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149
List of Archived Logs in backup set 342
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 403 11177493 18-JUN-25 11179239 18-JUN-25
2 348 11177499 18-JUN-25 11179236 18-JUN-25
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
343 Full 19.17M DISK 00:00:00 18-JUN-25
BP Key: 343 Status: AVAILABLE Compressed: NO Tag: TAG20250618T143910
Piece Name: +FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151
SPFILE Included: Modification time: 18-JUN-25
SPFILE db_unique_name: RACDB
Control File Included: Ckp SCN: 11179258 Ckp time: 18-JUN-25
RMAN>
So I have run a backup from the first node of the RAC Cluster "srv1". These are Backup Sets 337 to 343. Since I didn't provide a TAG name in the BACKUP command, they have default TAG names based on Date and Time (TAG20250618T143542, TAG20250618T143546, TAG20250618T143546, TAG20250618T143546, TAG20250618T143546, TAG20250618T143909, TAG20250618T143910)
Next I want to copy (i.e. backup) this backup to filesystem on "srv2" being the second node of the RAC Cluster. As they are on the (shared) ASM DiskGroup, I can crosscheck them from srv2 first before I backup to filesystem.
[oracle@srv2 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jun 18 14:45:19 2025
Version 19.25.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: RACDB (DBID=1162136313)
RMAN> crosscheck backup completed after "trunc(sysdate)";
crosscheck backup completed after "trunc(sysdate)";
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=229 instance=RACDB2 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943 RECID=337 STAMP=1204122943
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947 RECID=338 STAMP=1204122946
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013 RECID=339 STAMP=1204123012
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057 RECID=340 STAMP=1204123057
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103 RECID=341 STAMP=1204123102
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149 RECID=342 STAMP=1204123149
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151 RECID=343 STAMP=1204123150
Crosschecked 7 objects
RMAN>
RMAN> backup device type disk format '/u02/RMAN_To_Disk/%U' backupset completed after "trunc(sysdate)";
backup device type disk format '/u02/RMAN_To_Disk/%U' backupset completed after "trunc(sysdate)";
Starting backup at 18-JUN-25
using channel ORA_DISK_1
channel ORA_DISK_1: input backup set: count=380, stamp=1204122942, piece=1
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece +FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943
piece handle=/u02/RMAN_To_Disk/bs3sat9u_380_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=381, stamp=1204122946, piece=1
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece +FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947
piece handle=/u02/RMAN_To_Disk/bt3sata2_381_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=382, stamp=1204123011, piece=1
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece +FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013
piece handle=/u02/RMAN_To_Disk/bu3satc3_382_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=383, stamp=1204123057, piece=1
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece +FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057
piece handle=/u02/RMAN_To_Disk/bv3satdh_383_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=384, stamp=1204123102, piece=1
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece +FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103
piece handle=/u02/RMAN_To_Disk/c03sateu_384_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=385, stamp=1204123149, piece=1
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece +FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149
piece handle=/u02/RMAN_To_Disk/c13satgd_385_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=386, stamp=1204123150, piece=1
channel ORA_DISK_1: starting piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece +FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151
piece handle=/u02/RMAN_To_Disk/c23satge_386_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 18-JUN-25
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
Finished backup at 18-JUN-25
Starting Control File and SPFILE Autobackup at 18-JUN-25
piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123831.443.1204123831 comment=NONE
Finished Control File and SPFILE Autobackup at 18-JUN-25
RMAN>
RMAN> crosscheck backup completed after "trunc(sysdate)";
crosscheck backup completed after "trunc(sysdate)";
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943 RECID=337 STAMP=1204122943
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/RMAN_To_Disk/bs3sat9u_380_1_2 RECID=344 STAMP=1204123823
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947 RECID=338 STAMP=1204122946
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/RMAN_To_Disk/bt3sata2_381_1_2 RECID=345 STAMP=1204123825
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013 RECID=339 STAMP=1204123012
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/RMAN_To_Disk/bu3satc3_382_1_2 RECID=346 STAMP=1204123826
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057 RECID=340 STAMP=1204123057
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/RMAN_To_Disk/bv3satdh_383_1_2 RECID=347 STAMP=1204123827
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103 RECID=341 STAMP=1204123102
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/RMAN_To_Disk/c03sateu_384_1_2 RECID=348 STAMP=1204123828
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149 RECID=342 STAMP=1204123149
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/RMAN_To_Disk/c13satgd_385_1_2 RECID=349 STAMP=1204123829
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151 RECID=343 STAMP=1204123150
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/RMAN_To_Disk/c23satge_386_1_2 RECID=350 STAMP=1204123830
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123831.443.1204123831 RECID=351 STAMP=1204123831
Crosschecked 15 objects
RMAN>RMAN> list backup summary completed after "trunc(sysdate)";
list backup summary completed after "trunc(sysdate)";
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
337 B A A DISK 18-JUN-25 1 2 YES TAG20250618T143542
338 B F A DISK 18-JUN-25 1 2 YES TAG20250618T143546
339 B F A DISK 18-JUN-25 1 2 YES TAG20250618T143546
340 B F A DISK 18-JUN-25 1 2 YES TAG20250618T143546
341 B F A DISK 18-JUN-25 1 2 YES TAG20250618T143546
342 B A A DISK 18-JUN-25 1 2 YES TAG20250618T143909
343 B F A DISK 18-JUN-25 1 2 NO TAG20250618T143910
344 B F A DISK 18-JUN-25 1 1 NO TAG20250618T145031
RMAN>
RMAN> list backupset completed after "trunc(sysdate)";
list backupset completed after "trunc(sysdate)";
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Size
------- ----------
337 57.35M
List of Archived Logs in backup set 337
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
...
...
...
1 401 11161346 01-MAY-25 11165463 18-JUN-25
1 402 11165463 18-JUN-25 11177493 18-JUN-25
...
...
...
2 346 11161357 01-MAY-25 11161847 18-JUN-25
2 347 11161847 18-JUN-25 11177499 18-JUN-25
Backup Set Copy #1 of backup set 337
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:03 18-JUN-25 YES TAG20250618T143542
List of Backup Pieces for backup set 337 Copy #1 ### Shown as Copy #1 for Backupset 337
BP Key Pc# Status Piece Name
------- --- ----------- ----------
337 1 AVAILABLE +FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943
Backup Set Copy #2 of backup set 337
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:03 18-JUN-25 YES TAG20250618T143542
List of Backup Pieces for backup set 337 Copy #2 ### Shown as Copy #2 for Backupset 337
BP Key Pc# Status Piece Name
------- --- ----------- ----------
344 1 AVAILABLE /u02/RMAN_To_Disk/bs3sat9u_380_1_2
BS Key Type LV Size
------- ---- -- ----------
338 Full 1.07G
List of Datafiles in backup set 338
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/system.257.1164519439
3 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/sysaux.258.1164519463
4 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/undotbs1.259.1164519479
7 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/users.260.1164519479
9 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/undotbs2.269.1164519893
Backup Set Copy #1 of backup set 338
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:57 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 338 Copy #1 ### Shown as Copy #1 for Backupset 338
BP Key Pc# Status Piece Name
------- --- ----------- ----------
338 1 AVAILABLE +FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947
Backup Set Copy #2 of backup set 338
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:57 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 338 Copy #2 ### Shown as Copy #2 for Backupset 338
BP Key Pc# Status Piece Name
------- --- ----------- ----------
345 1 AVAILABLE /u02/RMAN_To_Disk/bt3sata2_381_1_2
BS Key Type LV Size
------- ---- -- ----------
339 Full 775.09M
List of Datafiles in backup set 339
Container ID: 3, PDB Name: PDB1
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
10 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/system.274.1164520333
11 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/sysaux.275.1164520333
12 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/undotbs1.273.1164520333
13 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/undo_2.277.1164520345
14 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users.278.1164520353
15 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users2.279.1167388913
16 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users3.280.1167388955
Backup Set Copy #1 of backup set 339
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 339 Copy #1 ### Shown as Copy #1 for Backupset 339
BP Key Pc# Status Piece Name
------- --- ----------- ----------
339 1 AVAILABLE +FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013
Backup Set Copy #2 of backup set 339
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 339 Copy #2 ### Shown as Copy #2 for Backupset 339
BP Key Pc# Status Piece Name
------- --- ----------- ----------
346 1 AVAILABLE /u02/RMAN_To_Disk/bu3satc3_382_1_2
BS Key Type LV Size
------- ---- -- ----------
340 Full 812.50M
List of Datafiles in backup set 340
Container ID: 5, PDB Name: TSTPDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
25 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/system.281.1199369077
26 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/sysaux.283.1199369077
27 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/undotbs1.282.1199369077
28 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/undo_2.285.1199369085
Backup Set Copy #1 of backup set 340
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 340 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
340 1 AVAILABLE +FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057
Backup Set Copy #2 of backup set 340
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 340 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
347 1 AVAILABLE /u02/RMAN_To_Disk/bv3satdh_383_1_2
BS Key Type LV Size
------- ---- -- ----------
341 Full 812.46M
List of Datafiles in backup set 341
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.265.1164519659
6 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.266.1164519659
8 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1164519659
Backup Set Copy #1 of backup set 341
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 341 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
341 1 AVAILABLE +FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103
Backup Set Copy #2 of backup set 341
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 341 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
348 1 AVAILABLE /u02/RMAN_To_Disk/c03sateu_384_1_2
BS Key Size
------- ----------
342 674.00K
List of Archived Logs in backup set 342
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 403 11177493 18-JUN-25 11179239 18-JUN-25
2 348 11177499 18-JUN-25 11179236 18-JUN-25
Backup Set Copy #1 of backup set 342
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 18-JUN-25 YES TAG20250618T143909
List of Backup Pieces for backup set 342 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
342 1 AVAILABLE +FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149
Backup Set Copy #2 of backup set 342
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 18-JUN-25 YES TAG20250618T143909
List of Backup Pieces for backup set 342 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
349 1 AVAILABLE /u02/RMAN_To_Disk/c13satgd_385_1_2
BS Key Type LV Size
------- ---- -- ----------
343 Full 19.17M
SPFILE Included: Modification time: 18-JUN-25
SPFILE db_unique_name: RACDB
Control File Included: Ckp SCN: 11179258 Ckp time: 18-JUN-25
Backup Set Copy #1 of backup set 343
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 18-JUN-25 NO TAG20250618T143910
List of Backup Pieces for backup set 343 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
343 1 AVAILABLE +FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151
Backup Set Copy #2 of backup set 343
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 18-JUN-25 NO TAG20250618T143910
List of Backup Pieces for backup set 343 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
350 1 AVAILABLE /u02/RMAN_To_Disk/c23satge_386_1_2
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
344 Full 19.17M DISK 00:00:00 18-JUN-25
BP Key: 351 Status: AVAILABLE Compressed: NO Tag: TAG20250618T145031
Piece Name: +FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123831.443.1204123831
SPFILE Included: Modification time: 18-JUN-25
SPFILE db_unique_name: RACDB
Control File Included: Ckp SCN: 11185112 Ckp time: 18-JUN-25
RMAN>
[oracle@srv2 ~]$ cd /u02/RMAN_To_Disk
[oracle@srv2 RMAN_To_Disk]$ ls -l
total 3656024
-rw-r-----. 1 oracle oinstall 60140032 Jun 18 14:50 bs3sat9u_380_1_2
-rw-r-----. 1 oracle oinstall 1146150912 Jun 18 14:50 bt3sata2_381_1_2
-rw-r-----. 1 oracle oinstall 812752896 Jun 18 14:50 bu3satc3_382_1_2
-rw-r-----. 1 oracle oinstall 851976192 Jun 18 14:50 bv3satdh_383_1_2
-rw-r-----. 1 oracle oinstall 851935232 Jun 18 14:50 c03sateu_384_1_2
-rw-r-----. 1 oracle oinstall 690688 Jun 18 14:50 c13satgd_385_1_2
-rw-r-----. 1 oracle oinstall 20119552 Jun 18 14:50 c23satge_386_1_2
[oracle@srv2 RMAN_To_Disk]$
Thus, RMAN on Server "srv2" sees 2 copies of each backupset (337 to 343) (while 344 is the new BackupsSet for the Controlfile + SPFILE Autobackp created on FRA)
However srv1 will not "see" the additional BackupSet Copies ("Copy #2") created on FileSystem on srv2 -- although they will appear in the controlfile, a CROSSCHECK executed from srv1 will fail to find them.
[oracle@srv1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jun 18 15:05:16 2025
Version 19.25.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: RACDB (DBID=1162136313)
RMAN> list backup completed after "trunc(sysdate)";
list backup completed after "trunc(sysdate)";
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Size
------- ----------
337 57.35M
List of Archived Logs in backup set 337
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
...
...
...
1 401 11161346 01-MAY-25 11165463 18-JUN-25
1 402 11165463 18-JUN-25 11177493 18-JUN-25
...
...
...
2 346 11161357 01-MAY-25 11161847 18-JUN-25
2 347 11161847 18-JUN-25 11177499 18-JUN-25
Backup Set Copy #1 of backup set 337
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:03 18-JUN-25 YES TAG20250618T143542
List of Backup Pieces for backup set 337 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
337 1 AVAILABLE +FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943
Backup Set Copy #2 of backup set 337
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:03 18-JUN-25 YES TAG20250618T143542
List of Backup Pieces for backup set 337 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
344 1 AVAILABLE /u02/RMAN_To_Disk/bs3sat9u_380_1_2
BS Key Type LV Size
------- ---- -- ----------
338 Full 1.07G
List of Datafiles in backup set 338
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/system.257.1164519439
3 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/sysaux.258.1164519463
4 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/undotbs1.259.1164519479
7 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/users.260.1164519479
9 Full 11177541 18-JUN-25 NO +DATA/RACDB/DATAFILE/undotbs2.269.1164519893
Backup Set Copy #1 of backup set 338
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:57 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 338 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
338 1 AVAILABLE +FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947
Backup Set Copy #2 of backup set 338
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:57 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 338 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
345 1 AVAILABLE /u02/RMAN_To_Disk/bt3sata2_381_1_2
BS Key Type LV Size
------- ---- -- ----------
339 Full 775.09M
List of Datafiles in backup set 339
Container ID: 3, PDB Name: PDB1
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
10 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/system.274.1164520333
11 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/sysaux.275.1164520333
12 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/undotbs1.273.1164520333
13 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/undo_2.277.1164520345
14 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users.278.1164520353
15 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users2.279.1167388913
16 Full 11177736 18-JUN-25 NO +DATA/RACDB/1476C653214704CFE0635A38A8C08494/DATAFILE/users3.280.1167388955
Backup Set Copy #1 of backup set 339
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 339 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
339 1 AVAILABLE +FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013
Backup Set Copy #2 of backup set 339
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 339 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
346 1 AVAILABLE /u02/RMAN_To_Disk/bu3satc3_382_1_2
BS Key Type LV Size
------- ---- -- ----------
340 Full 812.50M
List of Datafiles in backup set 340
Container ID: 5, PDB Name: TSTPDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
25 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/system.281.1199369077
26 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/sysaux.283.1199369077
27 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/undotbs1.282.1199369077
28 Full 11083998 25-APR-25 NO +DATA/RACDB/339BC12E8011538DE0635A38A8C0C92A/DATAFILE/undo_2.285.1199369085
Backup Set Copy #1 of backup set 340
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 340 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
340 1 AVAILABLE +FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057
Backup Set Copy #2 of backup set 340
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 340 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
347 1 AVAILABLE /u02/RMAN_To_Disk/bv3satdh_383_1_2
BS Key Type LV Size
------- ---- -- ----------
341 Full 812.46M
List of Datafiles in backup set 341
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.265.1164519659
6 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.266.1164519659
8 Full 9669002 26-NOV-24 NO +DATA/RACDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1164519659
Backup Set Copy #1 of backup set 341
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 341 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
341 1 AVAILABLE +FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103
Backup Set Copy #2 of backup set 341
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:42 18-JUN-25 YES TAG20250618T143546
List of Backup Pieces for backup set 341 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
348 1 AVAILABLE /u02/RMAN_To_Disk/c03sateu_384_1_2
BS Key Size
------- ----------
342 674.00K
List of Archived Logs in backup set 342
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 403 11177493 18-JUN-25 11179239 18-JUN-25
2 348 11177499 18-JUN-25 11179236 18-JUN-25
Backup Set Copy #1 of backup set 342
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 18-JUN-25 YES TAG20250618T143909
List of Backup Pieces for backup set 342 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
342 1 AVAILABLE +FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149
Backup Set Copy #2 of backup set 342
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 18-JUN-25 YES TAG20250618T143909
List of Backup Pieces for backup set 342 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
349 1 AVAILABLE /u02/RMAN_To_Disk/c13satgd_385_1_2
BS Key Type LV Size
------- ---- -- ----------
343 Full 19.17M
SPFILE Included: Modification time: 18-JUN-25
SPFILE db_unique_name: RACDB
Control File Included: Ckp SCN: 11179258 Ckp time: 18-JUN-25
Backup Set Copy #1 of backup set 343
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 18-JUN-25 NO TAG20250618T143910
List of Backup Pieces for backup set 343 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
343 1 AVAILABLE +FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151
Backup Set Copy #2 of backup set 343
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 18-JUN-25 NO TAG20250618T143910
List of Backup Pieces for backup set 343 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
350 1 AVAILABLE /u02/RMAN_To_Disk/c23satge_386_1_2
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
344 Full 19.17M DISK 00:00:00 18-JUN-25
BP Key: 351 Status: AVAILABLE Compressed: NO Tag: TAG20250618T145031
Piece Name: +FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123831.443.1204123831
SPFILE Included: Modification time: 18-JUN-25
SPFILE db_unique_name: RACDB
Control File Included: Ckp SCN: 11185112 Ckp time: 18-JUN-25
RMAN>
RMAN> crosscheck backup completed after "trunc(sysdate)";
crosscheck backup completed after "trunc(sysdate)";
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=245 instance=RACDB1 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943 RECID=337 STAMP=1204122943
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/RMAN_To_Disk/bs3sat9u_380_1_2 RECID=344 STAMP=1204123823
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947 RECID=338 STAMP=1204122946
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/RMAN_To_Disk/bt3sata2_381_1_2 RECID=345 STAMP=1204123825
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013 RECID=339 STAMP=1204123012
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/RMAN_To_Disk/bu3satc3_382_1_2 RECID=346 STAMP=1204123826
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057 RECID=340 STAMP=1204123057
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/RMAN_To_Disk/bv3satdh_383_1_2 RECID=347 STAMP=1204123827
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103 RECID=341 STAMP=1204123102
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/RMAN_To_Disk/c03sateu_384_1_2 RECID=348 STAMP=1204123828
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149 RECID=342 STAMP=1204123149
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/RMAN_To_Disk/c13satgd_385_1_2 RECID=349 STAMP=1204123829
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151 RECID=343 STAMP=1204123150
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/RMAN_To_Disk/c23satge_386_1_2 RECID=350 STAMP=1204123830
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123831.443.1204123831 RECID=351 STAMP=1204123831
Crosschecked 15 objects
RMAN>
RMAN> delete noprompt expired backup; delete noprompt expired backup; using channel ORA_DISK_1 List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 344 337 1 2 EXPIRED DISK /u02/RMAN_To_Disk/bs3sat9u_380_1_2 345 338 1 2 EXPIRED DISK /u02/RMAN_To_Disk/bt3sata2_381_1_2 346 339 1 2 EXPIRED DISK /u02/RMAN_To_Disk/bu3satc3_382_1_2 347 340 1 2 EXPIRED DISK /u02/RMAN_To_Disk/bv3satdh_383_1_2 348 341 1 2 EXPIRED DISK /u02/RMAN_To_Disk/c03sateu_384_1_2 349 342 1 2 EXPIRED DISK /u02/RMAN_To_Disk/c13satgd_385_1_2 350 343 1 2 EXPIRED DISK /u02/RMAN_To_Disk/c23satge_386_1_2 deleted backup piece backup piece handle=/u02/RMAN_To_Disk/bs3sat9u_380_1_2 RECID=344 STAMP=1204123823 deleted backup piece backup piece handle=/u02/RMAN_To_Disk/bt3sata2_381_1_2 RECID=345 STAMP=1204123825 deleted backup piece backup piece handle=/u02/RMAN_To_Disk/bu3satc3_382_1_2 RECID=346 STAMP=1204123826 deleted backup piece backup piece handle=/u02/RMAN_To_Disk/bv3satdh_383_1_2 RECID=347 STAMP=1204123827 deleted backup piece backup piece handle=/u02/RMAN_To_Disk/c03sateu_384_1_2 RECID=348 STAMP=1204123828 deleted backup piece backup piece handle=/u02/RMAN_To_Disk/c13satgd_385_1_2 RECID=349 STAMP=1204123829 deleted backup piece backup piece handle=/u02/RMAN_To_Disk/c23satge_386_1_2 RECID=350 STAMP=1204123830 Deleted 7 EXPIRED objects RMAN>
RMAN's LIST BACKUP command on srv1 does list the Copy #2 backups to filesystem /u02/RMAN_To_Disk that exist only on srv2.
However, the CROSSCHECK BACKUP command marks them as "EXPIRED" as it cannot "see" (i.e find) the Backup Pieces on srv1.
I can "reCatalog" them from srv2.
[oracle@srv2 RMAN_To_Disk]$ pwd /u02/RMAN_To_Disk [oracle@srv2 RMAN_To_Disk]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jun 18 15:12:33 2025 Version 19.25.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: RACDB (DBID=1162136313) RMAN> crosscheck backup completed after "trunc(sysdate)"; crosscheck backup completed after "trunc(sysdate)"; using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943 RECID=337 STAMP=1204122943 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947 RECID=338 STAMP=1204122946 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013 RECID=339 STAMP=1204123012 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057 RECID=340 STAMP=1204123057 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103 RECID=341 STAMP=1204123102 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149 RECID=342 STAMP=1204123149 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151 RECID=343 STAMP=1204123150 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123831.443.1204123831 RECID=351 STAMP=1204123831 Crosschecked 8 objects RMAN> RMAN> catalog start with '/u02/RMAN_To_Disk'; catalog start with '/u02/RMAN_To_Disk'; searching for all files that match the pattern /u02/RMAN_To_Disk List of Files Unknown to the Database ===================================== File Name: /u02/RMAN_To_Disk/bs3sat9u_380_1_2 File Name: /u02/RMAN_To_Disk/bt3sata2_381_1_2 File Name: /u02/RMAN_To_Disk/bu3satc3_382_1_2 File Name: /u02/RMAN_To_Disk/bv3satdh_383_1_2 File Name: /u02/RMAN_To_Disk/c03sateu_384_1_2 File Name: /u02/RMAN_To_Disk/c13satgd_385_1_2 File Name: /u02/RMAN_To_Disk/c23satge_386_1_2 Do you really want to catalog the above files (enter YES or NO)? YES cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u02/RMAN_To_Disk/bs3sat9u_380_1_2 File Name: /u02/RMAN_To_Disk/bt3sata2_381_1_2 File Name: /u02/RMAN_To_Disk/bu3satc3_382_1_2 File Name: /u02/RMAN_To_Disk/bv3satdh_383_1_2 File Name: /u02/RMAN_To_Disk/c03sateu_384_1_2 File Name: /u02/RMAN_To_Disk/c13satgd_385_1_2 File Name: /u02/RMAN_To_Disk/c23satge_386_1_2 RMAN> RMAN> crosscheck backup completed after "trunc(sysdate)"; crosscheck backup completed after "trunc(sysdate)"; using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143542_0.473.1204122943 RECID=337 STAMP=1204122943 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u02/RMAN_To_Disk/bs3sat9u_380_1_2 RECID=352 STAMP=1204125222 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.442.1204122947 RECID=338 STAMP=1204122946 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u02/RMAN_To_Disk/bt3sata2_381_1_2 RECID=353 STAMP=1204125222 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/1476C653214704CFE0635A38A8C08494/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.453.1204123013 RECID=339 STAMP=1204123012 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u02/RMAN_To_Disk/bu3satc3_382_1_2 RECID=354 STAMP=1204125222 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/339BC12E8011538DE0635A38A8C0C92A/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.460.1204123057 RECID=340 STAMP=1204123057 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u02/RMAN_To_Disk/bv3satdh_383_1_2 RECID=355 STAMP=1204125222 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/14769E258FBB5FD8E0635A38A8C09D43/BACKUPSET/2025_06_18/nnndf0_tag20250618t143546_0.349.1204123103 RECID=341 STAMP=1204123102 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u02/RMAN_To_Disk/c03sateu_384_1_2 RECID=356 STAMP=1204125222 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/BACKUPSET/2025_06_18/annnf0_tag20250618t143909_0.492.1204123149 RECID=342 STAMP=1204123149 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u02/RMAN_To_Disk/c13satgd_385_1_2 RECID=357 STAMP=1204125222 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123150.388.1204123151 RECID=343 STAMP=1204123150 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u02/RMAN_To_Disk/c23satge_386_1_2 RECID=358 STAMP=1204125222 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=+FRA/RACDB/AUTOBACKUP/2025_06_18/s_1204123831.443.1204123831 RECID=351 STAMP=1204123831 Crosschecked 15 objects RMAN>
Thus even though I executed a "DELETE" from srv1, I can re-Catalog them because the BackupPieces of these Copy #2 Backups still exist on filesystem /u02/RMAN_To_Disk on srv2.
No comments:
Post a Comment