I've created a video demonstration of a Cross-Instance Deadlock in a 2-node RAC environment and how to read the trace file.
Note : Only the SQL that has been returned the "deadlock" error is failed, the session and transaction are still valid.
I am an Oracle Database Specialist in Singapore.
Please note that this site uses cookies.
I've created a video demonstration of a Cross-Instance Deadlock in a 2-node RAC environment and how to read the trace file.
Note : Only the SQL that has been returned the "deadlock" error is failed, the session and transaction are still valid.
Description:
This session will cover the fundamentals of Oracle Cloud Infrastructure (OCI) including cloud concepts, OCI structures, and core OCI services. OCI service areas that will be discussed include Identity and Access Management (IAM), networking, compute, storage, and database. You will also learn about Users, Groups, and Policies, along with the core tenets of virtual network design that will help set the foundations for application deployment to OCI. We will also cover terms and definitions for each of the topic areas to establish a foundation for additional sessions.
I have created a new Video demonstrating how you can add new Services to an existing database. In RAC, you can choose to have the Service running on all or selected or a single node of the Cluster. The service can be bound to a PDB.
This allows you to separate different applications / groups of users via Services and manage availability via Startup/Shutdown/Relocation/Failover of services.
The comand to configure a service to a single PDB and Instance is :
srvctl add service -db RACDB -service prdapps1 -preferred RACDB1 -available RACDB2 -tafpolicy BASIC -failovertype SELECT -clbgoal SHORT -pdb PDAPPTST
In my previous blog post and video, I had demonstrated creating a PDB (as a clone from an existing PDB) to be used for some testing/validation for a short period of time, without needing protection of a Standby database.
But what if you do decide to provide Standby protection ?
First, here's the status of the Pluggable Database at the Primary :
SQL> select con_id, pdb_name, creation_time, force_logging 2 from cdb_pdbs 3 where pdb_name = 'PRDAPPTST' 4 / CON_ID PDB_NAME CREATION_ FORCE_LOGGING ---------- ------------ --------- --------------------------------------- 4 PRDAPPTST 29-JUN-25 NO SQL> SQL> select force_logging from v$database; FORCE_LOGGING --------------------------------------- YES SQL> SQL> alter pluggable database prdapptst enable force logging; Pluggable database altered. SQL> SQL> select con_id, pdb_name, creation_time, force_logging 2 from cdb_pdbs 3 where pdb_name = 'PRDAPPTST' 4 / CON_ID PDB_NAME CREATION_ FORCE_LOGGING ---------- ------------ --------- --------------------------------------- 4 PRDAPPTST 29-JUN-25 YES SQL>
SQL> l 1 select con_id, name, open_mode, recovery_status 2 from v$pdbs 3* where name ='PRDAPPTST' SQL> / CON_ID NAME OPEN_MODE RECOVERY ---------- ------------ ---------- -------- 4 PRDAPPTST MOUNTED DISABLED SQL> SQL> l 1 select con_id, file#, status, plugged_in, name 2 from v$datafile 3 where con_id=4 4* order by file# SQL> / CON_ID FILE# STATUS PLUGGED_IN NAME ---------- ---------- ------- ---------- -------------------------------- 4 60 SYSOFF 0 /u01/app/oracle/product/19.0.0/d bhome_1/dbs/UNNAMED00060 4 61 RECOVER 0 /u01/app/oracle/product/19.0.0/d bhome_1/dbs/UNNAMED00061 4 62 RECOVER 0 /u01/app/oracle/product/19.0.0/d bhome_1/dbs/UNNAMED00062 4 63 RECOVER 0 /u01/app/oracle/product/19.0.0/d bhome_1/dbs/UNNAMED00063 4 64 RECOVER 0 /u01/app/oracle/product/19.0.0/d bhome_1/dbs/UNNAMED00064 SQL>
Recovery created pluggable database PRDAPPTST PRDAPPTST(4):Tablespace-SYSTEM during PDB create skipped since source is in r/w mode or this is a refresh clone PRDAPPTST(4):File #60 added to control file as 'UNNAMED00060'. Originally created as: PRDAPPTST(4):'+DATA/RACDB/38AE431466FE1FDBE0635A38A8C085D8/DATAFILE/system.299.1205032267' PRDAPPTST(4):because the pluggable database was created with nostandby PRDAPPTST(4):or the tablespace belonging to the pluggable database is PRDAPPTST(4):offline. PRDAPPTST(4):Tablespace-SYSAUX during PDB create skipped since source is in r/w mode or this is a refresh clone PRDAPPTST(4):File #61 added to control file as 'UNNAMED00061'. Originally created as: PRDAPPTST(4):'+DATA/RACDB/38AE431466FE1FDBE0635A38A8C085D8/DATAFILE/sysaux.280.1205032267' PRDAPPTST(4):because the pluggable database was created with nostandby PRDAPPTST(4):or the tablespace belonging to the pluggable database is PRDAPPTST(4):offline. PRDAPPTST(4):Tablespace-UNDOTBS1 during PDB create skipped since source is in r/w mode or this is a refresh clone PRDAPPTST(4):File #62 added to control file as 'UNNAMED00062'. Originally created as: PRDAPPTST(4):'+DATA/RACDB/38AE431466FE1FDBE0635A38A8C085D8/DATAFILE/undotbs1.285.1205032267' PRDAPPTST(4):because the pluggable database was created with nostandby PRDAPPTST(4):or the tablespace belonging to the pluggable database is PRDAPPTST(4):offline. PRDAPPTST(4):Tablespace-TEMP during PDB create skipped since source is in r/w mode or this is a refresh clone PRDAPPTST(4):Tablespace-UNDO_2 during PDB create skipped since source is in r/w mode or this is a refresh clone PRDAPPTST(4):File #63 added to control file as 'UNNAMED00063'. Originally created as: PRDAPPTST(4):'+DATA/RACDB/38AE431466FE1FDBE0635A38A8C085D8/DATAFILE/undo_2.284.1205032267' PRDAPPTST(4):because the pluggable database was created with nostandby PRDAPPTST(4):or the tablespace belonging to the pluggable database is PRDAPPTST(4):offline. PRDAPPTST(4):Tablespace-USERS during PDB create skipped since source is in r/w mode or this is a refresh clone PRDAPPTST(4):File #64 added to control file as 'UNNAMED00064'. Originally created as: PRDAPPTST(4):'+DATA/RACDB/38AE431466FE1FDBE0635A38A8C085D8/DATAFILE/users.279.1205032267' PRDAPPTST(4):because the pluggable database was created with nostandby PRDAPPTST(4):or the tablespace belonging to the pluggable database is PRDAPPTST(4):offline.
SQL> connect hemant/hemant@newtestpdb Connected. SQL> @INS_QRY 1 row created. SQL> l 1* insert into my_txn_table select systimestamp, substr(p.name,1,12), substr(i.host_name,1,12), 'XXX' from v$pdbs p, v$instance i SQL> set pages600 linesize 132 SQL> select * from my_txn_table; TXN_TIMESTAMP TARGET_PDB_NAME TARGET_HOST_NAM TXN_DETAILS --------------------------------------------------------------------------- --------------- --------------- --------------- 29-JUN-25 03.06.43.264562 AM PDB1 srv2 XXX 29-JUN-25 03.15.26.694170 AM PRDAPPTST srv1 XXX 06-JUL-25 08.31.33.903344 AM PRDAPPTST srv2 XXX 29-JUN-25 03.27.26.855776 AM PRDAPPTST srv2 XXX SQL> select * from my_txn_table order by txn_timestamp; TXN_TIMESTAMP TARGET_PDB_NAME TARGET_HOST_NAM TXN_DETAILS --------------------------------------------------------------------------- --------------- --------------- --------------- 29-JUN-25 03.06.43.264562 AM PDB1 srv2 XXX 29-JUN-25 03.15.26.694170 AM PRDAPPTST srv1 XXX 29-JUN-25 03.27.26.855776 AM PRDAPPTST srv2 XXX 06-JUL-25 08.31.33.903344 AM PRDAPPTST srv2 XXX SQL> commit; Commit complete. SQL> connect hemant/hemant@newtestpdb Connected. SQL> @INS_QRY 1 row created. SQL> commit; Commit complete. SQL> connect hemant/hemant@newtestpdb Connected. SQL> @INS_QRY 1 row created. SQL> commit; Commit complete. SQL> select * from my_txn_table order by txn_timestamp; TXN_TIMESTAMP TARGET_PDB_NAME TARGET_HOST_NAM TXN_DETAILS --------------------------------------------------------------------------- --------------- --------------- --------------- 29-JUN-25 03.06.43.264562 AM PDB1 srv2 XXX 29-JUN-25 03.15.26.694170 AM PRDAPPTST srv1 XXX 29-JUN-25 03.27.26.855776 AM PRDAPPTST srv2 XXX 06-JUL-25 08.31.33.903344 AM PRDAPPTST srv2 XXX 06-JUL-25 08.32.29.154557 AM PRDAPPTST srv1 XXX 06-JUL-25 08.32.41.404084 AM PRDAPPTST srv2 XXX 6 rows selected. SQL>
[oracle@srv1 ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Sun Jul 6 08:35:56 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 backup as compressed backupset 2> pluggable database PRDAPPTST pluggable database PRDAPPTST 3> format '/tmp/PRDAPPTST_DB_%U.bak';
[oracle@stdby tmp]$ ls -ltr *bak -rw-r-----. 1 oracle oinstall 849739776 Jul 6 08:38 PRDAPPTST_DB_ch3tsbcj_401_1_1.bak [oracle@stdby tmp]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Sun Jul 6 08:39:12 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, not open) RMAN> catalog start with '/tmp'; catalog start with '/tmp'; using target database control file instead of recovery catalog searching for all files that match the pattern /tmp List of Files Unknown to the Database ===================================== File Name: /tmp/PRDAPPTST_DB_ch3tsbcj_401_1_1.bak Do you really want to catalog the above files (enter YES or NO)? YES cataloging files... cataloging done List of Cataloged Files ======================= File Name: /tmp/PRDAPPTST_DB_ch3tsbcj_401_1_1.bak RMAN> RMAN> list backup of pluggable database PRDAPPTST; list backup of pluggable database PRDAPPTST; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 319 Full 810.37M DISK 00:00:43 06-JUL-25 BP Key: 319 Status: AVAILABLE Compressed: YES Tag: TAG20250706T083635 Piece Name: /tmp/PRDAPPTST_DB_ch3tsbcj_401_1_1.bak List of Datafiles in backup set 319 Container ID: 4, PDB Name: PRDAPPTST File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 60 Full 12491346 06-JUL-25 NO /u01/app/oracle/product/19.0.0/dbhome_1/dbs/UNNAMED00060 61 Full 12491346 06-JUL-25 NO /u01/app/oracle/product/19.0.0/dbhome_1/dbs/UNNAMED00061 62 Full 12491346 06-JUL-25 NO /u01/app/oracle/product/19.0.0/dbhome_1/dbs/UNNAMED00062 63 Full 12491346 06-JUL-25 NO /u01/app/oracle/product/19.0.0/dbhome_1/dbs/UNNAMED00063 64 Full 12491346 06-JUL-25 NO /u01/app/oracle/product/19.0.0/dbhome_1/dbs/UNNAMED00064 RMAN> RMAN> run run 2> { { 3> set newname for pluggable database PRDAPPTST to '/Standby_DB/oradata/STDBY/PRDAPPTST/%U.dbf'; set newname for pluggable database PRDAPPTST to '/Standby_DB/oradata/STDBY/PRDAPPTST/%U.dbf'; 4> restore pluggable database PRDAPPTST; restore pluggable database PRDAPPTST; 5> switch datafile all; switch datafile all; 6> } channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00060 to /Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-SYSTEM_FNO-60.dbf channel ORA_DISK_1: restoring datafile 00061 to /Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-SYSAUX_FNO-61.dbf channel ORA_DISK_1: restoring datafile 00062 to /Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-UNDOTBS1_FNO-62.dbf channel ORA_DISK_1: restoring datafile 00063 to /Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-UNDO_2_FNO-63.dbf channel ORA_DISK_1: restoring datafile 00064 to /Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-USERS_FNO-64.dbf channel ORA_DISK_1: reading from backup piece /tmp/PRDAPPTST_DB_ch3tsbcj_401_1_1.bak channel ORA_DISK_1: piece handle=/tmp/PRDAPPTST_DB_ch3tsbcj_401_1_1.bak tag=TAG20250706T083635 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:45 Finished restore at 06-JUL-25 datafile 60 switched to datafile copy input datafile copy RECID=54 STAMP=1205746519 file name=/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-SYSTEM_FNO-60.dbf datafile 61 switched to datafile copy input datafile copy RECID=55 STAMP=1205746519 file name=/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-SYSAUX_FNO-61.dbf datafile 62 switched to datafile copy input datafile copy RECID=56 STAMP=1205746519 file name=/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-UNDOTBS1_FNO-62.dbf datafile 63 switched to datafile copy input datafile copy RECID=57 STAMP=1205746519 file name=/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-UNDO_2_FNO-63.dbf datafile 64 switched to datafile copy input datafile copy RECID=58 STAMP=1205746519 file name=/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-USERS_FNO-64.dbf RMAN>
[oracle@srv1 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 6 10:32:27 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> alter pluggable database prdapptst enable recovery; alter pluggable database prdapptst enable recovery * ERROR at line 1: ORA-65046: operation not allowed from outside a pluggable database SQL> alter session set container=PRDAPPTST; Session altered. SQL> alter pluggable database prdapptst enable recovery; Pluggable database altered. SQL> connect hemant/hemant@newtestpdb Connected. SQL> @INS_QRY 1 row created. SQL> set pages600 linesize 132 SQL> commit; Commit complete. SQL> select * from my_txn_table order by 1; TXN_TIMESTAMP TARGET_PDB_NAME TARGET_HOST_NAM TXN_DETAILS --------------------------------------------------------------------------- --------------- --------------- --------------- 29-JUN-25 03.06.43.264562 AM PDB1 srv2 XXX 29-JUN-25 03.15.26.694170 AM PRDAPPTST srv1 XXX 29-JUN-25 03.27.26.855776 AM PRDAPPTST srv2 XXX 06-JUL-25 08.31.33.903344 AM PRDAPPTST srv2 XXX 06-JUL-25 08.32.29.154557 AM PRDAPPTST srv1 XXX 06-JUL-25 08.32.41.404084 AM PRDAPPTST srv2 XXX 06-JUL-25 09.53.06.164510 AM PRDAPPTST srv1 XXX 06-JUL-25 10.33.28.132217 AM PRDAPPTST srv2 XXX 8 rows selected. SQL> SQL> connect / as sysdba Connected. SQL> alter system archive log current; System altered. SQL>
[oracle@stdby trace]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 6 10:39:50 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> alter database recover managed standby database cancel; Database altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 2147480256 bytes Fixed Size 9179840 bytes Variable Size 486539264 bytes Database Buffers 1644167168 bytes Redo Buffers 7593984 bytes Database mounted. SQL> alter session set container=PRDAPPTST; Session altered. SQL> alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-SYSTEM_FNO-60.dbf' online; alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-SYSTEM_FNO-60.dbf' online * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files SQL> alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-SYSAUX_FNO-61.dbf' online; alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-SYSAUX_FNO-61.dbf' online * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files SQL> alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-UNDOTBS1_FNO-62.dbf' online; alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-UNDOTBS1_FNO-62.dbf' online * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files SQL> alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-UNDO_2_FNO-63.dbf' online; alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-UNDO_2_FNO-63.dbf' online * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files SQL> alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-USERS_FNO-64.dbf' online; alter database datafile '/Standby_DB/oradata/STDBY/PRDAPPTST/data_D-RACDB_TS-USERS_FNO-64.dbf' online * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files SQL> SQL> connect / as sysdba Connected. SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 2147480256 bytes Fixed Size 9179840 bytes Variable Size 486539264 bytes Database Buffers 1644167168 bytes Redo Buffers 7593984 bytes Database mounted. SQL> alter session set container=PRDAPPTST; Session altered. SQL> alter pluggable database enable recovery; alter pluggable database enable recovery * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.25.0.0.0 [oracle@stdby trace]$ dgmgrl DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sun Jul 6 11:05:42 2025 Version 19.25.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect / as sysdba Connected to "STDBY" Connected as SYSDBA. DGMGRL> edit database STDBY set state='apply-off'; Succeeded. DGMGRL> exit [oracle@stdby trace]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 6 11:06:48 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> alter session set container=PRDAPPTST; Session altered. SQL> alter pluggable database enable recovery; Pluggable database altered. SQL> SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.25.0.0.0 [oracle@stdby trace]$ dgmgrl DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sun Jul 6 11:07:32 2025 Version 19.25.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect / as sysdba Connected to "STDBY" Connected as SYSDBA. DGMGRL> edit database stdby set state='apply-on'; Succeeded. DGMGRL> exit [oracle@stdby trace]$ [oracle@stdby trace]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 6 11:08:09 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> select name, open_mode from v$pdbs; NAME -------------------------------------------------------------------------------- OPEN_MODE ---------- PDB$SEED MOUNTED PDB1 MOUNTED PRDAPPTST MOUNTED SQL> alter database open read only; Database altered. SQL> alter pluggable database prdapptst open read only; Pluggable database altered. SQL> SQL> alter session set container=PRDAPPTST; Session altered. SQL> set pages600 linesize 132 SQL> select * from hemant.my_txn_table order by 1; TXN_TIMESTAMP TARGET_PDB_NAME TARGET_HOST_NAM TXN_DETAILS --------------------------------------------------------------------------- --------------- --------------- --------------- 29-JUN-25 03.06.43.264562 AM PDB1 srv2 XXX 29-JUN-25 03.15.26.694170 AM PRDAPPTST srv1 XXX 29-JUN-25 03.27.26.855776 AM PRDAPPTST srv2 XXX 06-JUL-25 08.31.33.903344 AM PRDAPPTST srv2 XXX 06-JUL-25 08.32.29.154557 AM PRDAPPTST srv1 XXX 06-JUL-25 08.32.41.404084 AM PRDAPPTST srv2 XXX 06-JUL-25 09.53.06.164510 AM PRDAPPTST srv1 XXX 06-JUL-25 10.33.28.132217 AM PRDAPPTST srv2 XXX 8 rows selected. SQL>
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 PRDAPPTSTStart 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 newtestpdbAlways use custom Service Names instead of the default name derived from the PDB Name.
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>
[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]$
[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>
[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>
I have seen some I.T. managers that decide to backup only the Primary Database and not the Standby. The logic is "if the Storage or Server for the Standby go down, we can rebuild the database from the Primary". OR "we haven't allocated storage / tape drive space at the Standby site" OR "our third-party backup tool does not know how to backup a Standby database and handle the warning about Archive Logs that is generated when it issues a "PLUS ARCHIVELOG" {see the warning below when I run the backup command)
Do they factor the time that is required to run Backup, Copy, Restore commands OR run the Duplicate command to rebuild the Standby ? All that while their Critical database is running without a Standby -- without a D.R. site.
Given a moderately large Database, it can be faster to restore from a "local" Backup at the Standby then to copy / duplicate across the network. Also, this method does NOT require rebuilding DataGuard Broker configuration.
Firstly, you CAN backup a Standby even while Recovery (i.e. Redo Apply) is running. The only catch is the "PLUS ARCHIVELOG" clause in "BACKUP ... DATABASE PLUS ARCHIVELOG" returns a minor error because a Standby cannot issue "ALTER SYSTEM ARCHIVE LOG CURRENT" (or "ALTER SYSTEM SWITCH LOGFILE")
Here's my Backup command at the Standby (while Redo Apply -- i.e. Media Recovery -- is running) without issuing a CANCEL RECOVERY.
RMAN> backup as compressed backupset 2> database 3> format '/tmp/STDBY_Backup/DB_DataFiles_%U.bak' 4> plus archivelog 5> format '/tmp/STDBY_Backup/DB_ArchLogs_%U.bak'; .... .... RMAN> backup current controlfile 2> format '/tmp/STDBY_Backup/standby_controlfile.bak';
RMAN-06820: warning: failed to archive current log at primary database cannot connect to remote database .... .... .... RMAN-06820: warning: failed to archive current log at primary database cannot connect to remote database using channel ORA_DISK_1 specification does not match any archived log in the repository backup cancelled because there are no files to backup
RMAN> list backup; list backup; using target database control file instead of recovery catalog List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 311 44.10M DISK 00:00:02 01-MAY-25 BP Key: 311 Status: AVAILABLE Compressed: YES Tag: TAG20250501T074832 Piece Name: /tmp/STDBY_Backup/DB_ArchLogs_ad3objeg_333_1_1.bak List of Archived Logs in backup set 311 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 393 11126161 01-MAY-25 11126287 01-MAY-25 1 394 11126287 01-MAY-25 11127601 01-MAY-25 ... ... 2 338 11126158 01-MAY-25 11126290 01-MAY-25 2 339 11126290 01-MAY-25 11127596 01-MAY-25 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 312 Full 1.07G DISK 00:00:57 01-MAY-25 BP Key: 312 Status: AVAILABLE Compressed: YES Tag: TAG20250501T074835 Piece Name: /tmp/STDBY_Backup/DB_DataFiles_ae3objej_334_1_1.bak List of Datafiles in backup set 312 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- .... .... BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 313 Full 831.00M DISK 00:00:43 01-MAY-25 BP Key: 313 Status: AVAILABLE Compressed: YES Tag: TAG20250501T074835 Piece Name: /tmp/STDBY_Backup/DB_DataFiles_af3objgk_335_1_1.bak List of Datafiles in backup set 313 Container ID: 3, PDB Name: PDB1 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- .... .... BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 314 Full 807.77M DISK 00:00:42 01-MAY-25 BP Key: 314 Status: AVAILABLE Compressed: YES Tag: TAG20250501T074835 Piece Name: /tmp/STDBY_Backup/DB_DataFiles_ag3obji1_336_1_1.bak List of Datafiles in backup set 314 Container ID: 5, PDB Name: TSTPDB File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- .... .... BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 315 Full 807.75M DISK 00:00:43 01-MAY-25 BP Key: 315 Status: AVAILABLE Compressed: YES Tag: TAG20250501T074835 Piece Name: /tmp/STDBY_Backup/DB_DataFiles_ah3objje_337_1_1.bak List of Datafiles in backup set 315 Container ID: 2, PDB Name: PDB$SEED File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- .... .... BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 317 Full 19.58M DISK 00:00:01 01-MAY-25 BP Key: 317 Status: AVAILABLE Compressed: NO Tag: TAG20250501T075522 Piece Name: /tmp/STDBY_Backup/standby_controlfile.bak Standby Control File Included: Ckp SCN: 11128626 Ckp time: 01-MAY-25 RMAN>
DGMGRL> connect sys Password: Connected to "RACDB" Connected as SYSDBA. DGMGRL> EDIT DATABASE 'RACDB' SET STATE='TRANSPORT-OFF'; Succeeded. DGMGRL>
[oracle@stdby ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 1 08:27:23 2025 Version 19.25.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> startup nomount; startup nomount; Oracle instance started Total System Global Area 2147480256 bytes Fixed Size 9179840 bytes Variable Size 486539264 bytes Database Buffers 1644167168 bytes Redo Buffers 7593984 bytes RMAN> restore standby controlfile from '/tmp/STDBY_Backup/standby_controlfile.bak'; restore standby controlfile from '/tmp/STDBY_Backup/standby_controlfile.bak'; Starting restore at 01-MAY-25 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=310 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/Standby_DB/oradata/control01.ctl output file name=/Standby_DB/FRA/control02.ctl Finished restore at 01-MAY-25 RMAN>I am now ready to CATALOG the Backups and RESTORE the Database
RMAN> alter database mount; alter database mount; released channel: ORA_DISK_1 Statement processed RMAN> catalog start with '/tmp/STDBY_Backup'; catalog start with '/tmp/STDBY_Backup'; Starting implicit crosscheck backup at 01-MAY-25 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=11 device type=DISK Crosschecked 13 objects Finished implicit crosscheck backup at 01-MAY-25 Starting implicit crosscheck copy at 01-MAY-25 using channel ORA_DISK_1 Finished implicit crosscheck copy at 01-MAY-25 searching for all files in the recovery area cataloging files... no files cataloged searching for all files that match the pattern /tmp/STDBY_Backup List of Files Unknown to the Database ===================================== File Name: /tmp/STDBY_Backup/standby_controlfile.bak Do you really want to catalog the above files (enter YES or NO)? YES cataloging files... cataloging done List of Cataloged Files ======================= File Name: /tmp/STDBY_Backup/standby_controlfile.bak RMAN>
RMAN> list backup ; list backup ; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 311 44.10M DISK 00:00:02 01-MAY-25 BP Key: 311 Status: AVAILABLE Compressed: YES Tag: TAG20250501T074832 Piece Name: /tmp/STDBY_Backup/DB_ArchLogs_ad3objeg_333_1_1.bak BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 312 Full 1.07G DISK 00:00:57 01-MAY-25 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 313 Full 831.00M DISK 00:00:43 01-MAY-25 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 314 Full 807.77M DISK 00:00:42 01-MAY-25 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 315 Full 807.75M DISK 00:00:43 01-MAY-25 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 316 Full 19.61M DISK 00:00:01 01-MAY-25 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 317 Full 19.58M DISK 00:00:01 01-MAY-25 BP Key: 317 Status: AVAILABLE Compressed: NO Tag: TAG20250501T075522 Piece Name: /tmp/STDBY_Backup/standby_controlfile.bak Standby Control File Included: Ckp SCN: 11128626 Ckp time: 01-MAY-25 RMAN>
RMAN> exit exit RMAN Client Diagnostic Trace file : /u01/app/oracle/diag/clients/user_oracle/host_4144547424_110/trace/ora_4560_140406053321216.trc Recovery Manager complete. [oracle@stdby ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu May 1 08:37:54 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> select open_mode, database_role from v$database; OPEN_MODE DATABASE_ROLE -------------------- ---------------- MOUNTED PHYSICAL STANDBY SQL>
SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.25.0.0.0 [oracle@stdby ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 1 08:40:32 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, not open) RMAN> RMAN> restore database; restore database; Starting restore at 01-MAY-25 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=2 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /Standby_DB/oradata/STDBY/datafile/o1_mf_system_m33j9fqn_.dbf ... ... ... channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00005 to /Standby_DB/oradata/STDBY/14769E258FBB5FD8E0635A38A8C09D43/datafile/o1_mf_system_m33jb79n_.dbf channel ORA_DISK_1: restoring datafile 00006 to /Standby_DB/oradata/STDBY/14769E258FBB5FD8E0635A38A8C09D43/datafile/o1_mf_sysaux_m33jbbgz_.dbf channel ORA_DISK_1: restoring datafile 00008 to /Standby_DB/oradata/STDBY/14769E258FBB5FD8E0635A38A8C09D43/datafile/o1_mf_undotbs1_m33jbgrs_.dbf channel ORA_DISK_1: reading from backup piece /tmp/STDBY_Backup/DB_DataFiles_ah3objje_337_1_1.bak channel ORA_DISK_1: piece handle=/tmp/STDBY_Backup/DB_DataFiles_ah3objje_337_1_1.bak tag=TAG20250501T074835 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:45 Finished restore at 01-MAY-25 RMAN>
RMAN> restore archivelog from time "trunc(sysdate)"; restore archivelog from time "trunc(sysdate)"; Starting restore at 01-MAY-25 using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=391 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=392 channel ORA_DISK_1: restoring archived log archived log thread=2 sequence=336 channel ORA_DISK_1: restoring archived log archived log thread=2 sequence=337 channel ORA_DISK_1: restoring archived log archived log thread=2 sequence=338 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=393 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=394 channel ORA_DISK_1: restoring archived log archived log thread=2 sequence=339 channel ORA_DISK_1: reading from backup piece /tmp/STDBY_Backup/DB_ArchLogs_ad3objeg_333_1_1.bak channel ORA_DISK_1: piece handle=/tmp/STDBY_Backup/DB_ArchLogs_ad3objeg_333_1_1.bak tag=TAG20250501T074832 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 Finished restore at 01-MAY-25 RMAN> RMAN> list archivelog all completed after "trunc(sysdate)"; list archivelog all completed after "trunc(sysdate)"; List of Archived Log Copies for database with db_unique_name STDBY ===================================================================== Key Thrd Seq S Low Time ------- ---- ------- - --------- 675 1 391 A 27-APR-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_1_391_n16fcchs_.arc 667 1 391 A 27-APR-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_1_391_n169cng5_.arc 682 1 392 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_1_392_n16fcbh7_.arc 670 1 392 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_1_392_n169fh7s_.arc 678 1 393 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_1_393_n16fcckd_.arc 671 1 393 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_1_393_n169g77l_.arc 677 1 394 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_1_394_n16fccjb_.arc 674 1 394 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_1_394_n169my72_.arc 680 2 336 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_336_n16fccnv_.arc 668 2 336 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_336_n169d0fm_.arc 681 2 337 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_337_n16fcbhy_.arc 669 2 337 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_337_n169fh6j_.arc 679 2 338 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_338_n16fccm6_.arc 672 2 338 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_338_n169g790_.arc 676 2 339 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_339_n16fcchw_.arc 673 2 339 A 01-MAY-25 Name: /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_339_n169mxfp_.arc RMAN>(the output shows duplicate entries if either the ArchiveLogs were already present at the Standby OR the Restore was executed twice)
RMAN> exit exit sqlRMAN Client Diagnostic Trace file : /u01/app/oracle/diag/clients/user_oracle/host_4144547424_110/trace/ora_5380_139777366395392.trc Recovery Manager complete. [oracle@stdby ~]$ sqlplus / as sysdba SQL> select thread#, group# from v$standby_log; THREAD# GROUP# ---------- ---------- 1 5 2 6 0 7 1 8 1 9 1 10 2 11 2 12 8 rows selected. SQL> alter database drop standby logfile group 5; Database altered. SQL> alter database drop standby logfile group 6; Database altered. SQL> alter database drop standby logfile group 7; Database altered. SQL> alter database drop standby logfile group 8; alter database drop standby logfile group 8 * ERROR at line 1: ORA-00313: open failed for members of log group 8 of thread 1 ORA-00312: online log 8 thread 1: '/Standby_DB/FRA/STDBY/onlinelog/o1_mf_8_mb6rdbos_.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 ORA-00312: online log 8 thread 1: '/Standby_DB/oradata/STDBY/onlinelog/o1_mf_8_mb6rd9h8_.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 SQL> alter database drop standby logfile group 9; Database altered. SQL> alter database drop standby logfile group 10; Database altered. SQL> alter database drop standby logfile group 11; alter database drop standby logfile group 11 * ERROR at line 1: ORA-00313: open failed for members of log group 11 of thread 2 ORA-00312: online log 11 thread 2: '/Standby_DB/FRA/STDBY/onlinelog/o1_mf_11_mb6rf8ob_.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 ORA-00312: online log 11 thread 2: '/Standby_DB/oradata/STDBY/onlinelog/o1_mf_11_mb6rf7hs_.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 SQL> alter database drop standby logfile group 12; Database altered. SQL> SQL> select thread#, group# from v$standby_log; THREAD# GROUP# ---------- ---------- 1 8 2 11 SQL> SQL> alter database clear logfile group 8; Database altered. SQL> alter database clear logfile group 11; Database altered. SQL> SQL> alter database drop standby logfile group 8; Database altered. SQL> alter database drop standby logfile group 11; Database altered. SQL> select thread#, group# from v$standby_log; no rows selected SQL> SQL> alter database add standby logfile thread 1 size 512M; Database altered. SQL> alter database add standby logfile thread 1 size 512M; Database altered. SQL> alter database add standby logfile thread 2 size 512M; Database altered. SQL> alter database add standby logfile thread 2 size 512M; Database altered. SQL> alter database add standby logfile thread 2 size 512M; Database altered. SQL> SQL> select thread#, group# from v$standby_log order by 1,2; THREAD# GROUP# ---------- ---------- 1 5 1 6 1 7 2 8 2 9 2 10 6 rows selected. SQL>I have to clear and then drop and recreate one Standby Log of each Thread that were last being used just before all the files were lost -- so the controlfile expected Group 8 and Group 11 to be present. These were the entries in the alert log for the last set of Recover commands before the storage was lost :
2025-05-01T08:10:41.554409+00:00 Recovery of Online Redo Log: Thread 2 Group 11 Seq 343 Reading mem 0 Mem# 0: /Standby_DB/oradata/STDBY/onlinelog/o1_mf_11_mb6rf7hs_.log Mem# 1: /Standby_DB/FRA/STDBY/onlinelog/o1_mf_11_mb6rf8ob_.log 2025-05-01T08:10:41.557828+00:00 ARC1 (PID:1813): Archived Log entry 680 added for B-1164519547.T-1.S-397 LOS:0x0000000000a9f8a3 NXS:0x0000000000a9f8d2 NAB:12 ID 0x46c5be03 LAD:1 2025-05-01T08:10:41.563027+00:00 rfs (PID:1825): Selected LNO:8 for T-1.S-398 dbid 1162136313 branch 1164519547 2025-05-01T08:10:41.642227+00:00 PR00 (PID:1863): Media Recovery Waiting for T-1.S-398 (in transit) 2025-05-01T08:10:41.642508+00:00 Recovery of Online Redo Log: Thread 1 Group 8 Seq 398 Reading mem 0 Mem# 0: /Standby_DB/oradata/STDBY/onlinelog/o1_mf_8_mb6rd9h8_.log Mem# 1: /Standby_DB/FRA/STDBY/onlinelog/o1_mf_8_mb6rdbos_.log 2025-05-01T08:14:02.648081+00:00 Shutting down ORACLE instance (abort) (OS id: 3584)
SQL> alter database recover managed standby database using current logfile disconnect from session; Database altered. SQL> SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> SQL> startup mount; ORACLE instance started. Total System Global Area 2147480256 bytes Fixed Size 9179840 bytes Variable Size 486539264 bytes Database Buffers 1644167168 bytes Redo Buffers 7593984 bytes Database mounted. SQL> alter database recover managed standby database using current logfile disconnect from session; Database altered. SQL> exit
[oracle@srv1 ~]$ dgmgrl DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu May 1 09:11:56 2025 Version 19.25.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect sys Password: Connected to "RACDB" Connected as SYSDBA. DGMGRL> EDIT DATABASE 'RACDB' SET STATE='TRANSPORT-ON'; Succeeded. DGMGRL> DGMGRL> show configuration; Configuration - racdb_dg Protection Mode: MaxPerformance Members: racdb - Primary database stdby - Physical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 34 seconds ago) DGMGRL> show configuration lag; Configuration - racdb_dg Protection Mode: MaxPerformance Members: racdb - Primary database stdby - Physical standby database Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seconds (computed 1 second ago) Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 37 seconds ago) DGMGRL>Note : I have to wait for a few seconds to a few minutes for the SHOW CONFIGURATION and SHOW CONFIGURATION LAG commands to return the correct information. Initially, they may show that there are errors but once Primary and Standby are "talking to each other", these errors would clear.
2025-05-01T09:19:30.530588+00:00 Recovery of Online Redo Log: Thread 2 Group 8 Seq 344 Reading mem 0 Mem# 0: /Standby_DB/oradata/STDBY/onlinelog/o1_mf_8_n16gb9wm_.log Mem# 1: /Standby_DB/FRA/STDBY/onlinelog/o1_mf_8_n16gbb4m_.log 2025-05-01T09:19:30.611573+00:00 rfs (PID:7642): krsr_rfs_atc: Identified database type as 'PHYSICAL': Client is ASYNC (PID:11557) 2025-05-01T09:19:30.623795+00:00 rfs (PID:7642): Selected LNO:5 for T-1.S-399 dbid 1162136313 branch 1164519547 2025-05-01T09:19:30.631133+00:00 PR00 (PID:7486): Media Recovery Waiting for T-1.S-399 (in transit) 2025-05-01T09:19:30.631475+00:00 Recovery of Online Redo Log: Thread 1 Group 5 Seq 399 Reading mem 0 Mem# 0: /Standby_DB/oradata/STDBY/onlinelog/o1_mf_5_n16g90qv_.log Mem# 1: /Standby_DB/FRA/STDBY/onlinelog/o1_mf_5_n16g910n_.log 2025-05-01T09:20:51.263052+00:00 ARC2 (PID:7470): Archived Log entry 691 added for B-1164519547.T-2.S-344 LOS:0x0000000000aa394b NXS:0x0000000000aa3b02 NAB:102 ID 0x46c5be03 LAD:1 2025-05-01T09:20:51.274060+00:00 rfs (PID:7640): Selected LNO:8 for T-2.S-345 dbid 1162136313 branch 1164519547 2025-05-01T09:20:51.285312+00:00 PR00 (PID:7486): Media Recovery Log /Standby_DB/FRA/STDBY/archivelog/2025_05_01/o1_mf_2_344_n16h7m85_.arc PR00 (PID:7486): Media Recovery Waiting for T-2.S-345 (in transit) 2025-05-01T09:20:51.387005+00:00 Recovery of Online Redo Log: Thread 2 Group 8 Seq 345 Reading mem 0 Mem# 0: /Standby_DB/oradata/STDBY/onlinelog/o1_mf_8_n16gb9wm_.log Mem# 1: /Standby_DB/FRA/STDBY/onlinelog/o1_mf_8_n16gbb4m_.log 2025-05-01T09:20:51.433894+00:00 ARC0 (PID:7462): Archived Log entry 692 added for B-1164519547.T-1.S-399 LOS:0x0000000000aa394e NXS:0x0000000000aa3b06 NAB:265 ID 0x46c5be03 LAD:1 2025-05-01T09:20:51.445431+00:00 rfs (PID:7642): Selected LNO:5 for T-1.S-400 dbid 1162136313 branch 1164519547 2025-05-01T09:20:51.514317+00:00 PR00 (PID:7486): Media Recovery Waiting for T-1.S-400 (in transit) 2025-05-01T09:20:51.514664+00:00 Recovery of Online Redo Log: Thread 1 Group 5 Seq 400 Reading mem 0 Mem# 0: /Standby_DB/oradata/STDBY/onlinelog/o1_mf_5_n16g90qv_.log Mem# 1: /Standby_DB/FRA/STDBY/onlinelog/o1_mf_5_n16g910n_.logI see that the SEQ# have already advanced to 399 and 345 for Thread 1 and 2 respectively.