29 June, 2025

Creating a new PDB in RAC without Standby Protection

 I've published a new Video demonstration when you need to create a new PDB (even as a clone of an existing one) without requiring a Standby copy of the PDB.

(Use cases : Test environment for a day or two, it would take too long to create a new Test Server and clone the database, it would take too long to change Firewall rules to allow Applications to connect to the Test Server)

This in RAC with DataGuard Useful commands : Create new PDB : 

CREATE PLUGGABLE DATABASE PRDAPPTST FROM PDB1  STANDBYS=NONE
Create Service : 
srvctl add service -db RACDB  -service newtestpdb -preferred RACDB1,RACDB2 -tafpolicy BASIC -failovertype SELECT -clbgoal SHORT -pdb PRDAPPTST
Start Service : 
srvctl enable service -db RACDB -service newtestpdb
srvctl status service -db RACDB -service newtestpdb
srvctl start service -db RACDB -service newtestpdb
srvctl status service -db RACDB -service newtestpdb

Always use custom Service Names instead of the default name derived from the PDB Name.


UPDATE  02-July : In response to a question on x.com : "One question: what if we want to create standby in future. Do we have to change standby parameter using any command or we can directly create standby normally"

My reply is :
The STANDBYS=NONE applies only to this PDB (PRDAPPTST). Any new PDB would still default to STANDBYS=ALL.

Although PRDAPPTST is intended to be dropped in a day or two, if you want it to be protected by Standby for longer or permanently, you can restore it to the Standby CDB (as it is in the controlfile and datadictionary) and resume recovery with ENABLE RECOVERY



Also see this series of posts on Refreshable Clone PDBs that I published a few years ago.
No comments:

18 June, 2025

Backup a Backup that is in ASM

 In RAC or Single Instance environments with ASM, it is possible to run database backups to ASM  (typically the FRA diskgroup).

However, you would need the ability to copy the backup *out of ASM*  -- e.g. using non-Oracle methods to copy to backup storage / offsite storage / tape drive.

Note : Timestamps are in UTC in the listings below

First, I run a Fresh Backup that, by default, goes to the designated FRA

[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:
Subscribe to: Posts (Atom)