Mallik034: CDB & PDB Recovery - Oracle Multitenant Recovery

CDB & PDB Recovery:

Cloning a Pluggable Database from an RMAN Container Database Backup (Doc ID 2042607.1)

Recovery:

Container Database (CDB) Complete/Full Recovery:

$ rman target=/

RUN {

SHUTDOWN IMMEDIATE; # use abort if this fails

STARTUP MOUNT;

RESTORE DATABASE;

RECOVER DATABASE;

ALTER DATABASE OPEN;

}

Root Container Complete/Full Recovery:

$ rman target=/

RUN {

SHUTDOWN IMMEDIATE; # use abort if this fails

STARTUP MOUNT;

RESTORE DATABASE ROOT;

RECOVER DATABASE ROOT;

# Consider recovering PDBs before opening.

ALTER DATABASE OPEN;

}

Pluggable Database (PDB) Recovery Scenario:

rman target /

RMAN> RUN {

ALTER PLUGGABLE DATABASE PDB1, PDB2 CLOSE;

RESTORE PLUGGABLE DATABASE PDB1, PDB2;

RECOVER PLUGGABLE DATABASE PDB1, PDB2;

ALTER PLUGGABLE DATABASE PDB1, PDB2 OPEN;

}

$ sqlplus sys@PDB1 as sysdba

SQL> CREATE USER mallik IDENTIFIED BY mallik;

SQL> GRANT CREATE SESSION, PDB_DBA, SYSDBA TO mallik;

rman target=mallik@PDB1

rman target=sys@PDB1

RMAN> SHUTDOWN IMMEDIATE;

RESTORE DATABASE;

RECOVER DATABASE;

STARTUP;

$ sqlplus sys@PDB2 as sysdba

SQL> CREATE USER mallik IDENTIFIED BY mallik;

SQL> GRANT CREATE SESSION, PDB_DBA, SYSDBA TO mallik;

rman target=mallik@PDB2

rman target=sys@PDB2

RMAN> SHUTDOWN IMMEDIATE;

RESTORE DATABASE;

RECOVER DATABASE;

STARTUP;

Tablespace Recovery of PDB:

rman target=sys@PDB1

RMAN> RUN {

ALTER TABLESPACE users OFFLINE;

RESTORE TABLESPACE users;

RECOVER TABLESPACE users;

ALTER TABLESPACE users ONLINE;

}

Tablespace Recovery of CDB:

rman target=sys@CDBDB

RMAN> RUN {

ALTER TABLESPACE users OFFLINE;

RESTORE TABLESPACE users;

RECOVER TABLESPACE users;

ALTER TABLESPACE users ONLINE;

}

Datafile Recovery of a PDB:

rman target=sys@PDB1

RMAN> RUN {

ALTER DATABASE DATAFILE 12 OFFLINE;

RESTORE DATAFILE 12;

RECOVER DATAFILE 12;

ALTER DATABASE DATAFILE 12 ONLINE;

}

Datafile Recovery of a CDB:

rman target=sys@CDBDB

RMAN> RUN {

ALTER DATABASE DATAFILE 7 OFFLINE;

RESTORE DATAFILE 7;

RECOVER DATAFILE 7;

ALTER DATABASE DATAFILE 7 ONLINE;

}

New Feature:

New SYSBACKUP privilege in RMAN 12c

create common user in CDB with sysbackup privilege.

SQL> create user c##dba_backup identified by test123;

SQL> grant sysbackup to c##dba_backup;

Backup whole database using sysbackup privilege

[oracle@rac1 ~]$ rman target '"c##dba_backup@CDBDB as sysbackup"'

RMAN> backup database;

18c Duplicate a Pluggable Database (PDB):

Duplicate a Pluggable Database (PDB) to an existing Container Database (CDB) in Oracle Database 18c

https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-duplicating-databases.html#GUID-539E89F6-C0BC-49CB-8D8C-CD8FF88BAF32

export ORACLE_SID=cdb1

export ORAENV_ASK=NO

. oraenv

export ORAENV_ASK=YES

rman target=sys/SysPassword1@cdb1 auxiliary=sys/SysPassword1@cdb3 <<EOF

DUPLICATE PLUGGABLE DATABASE pdb1 AS pdb2 TO cdb3

FROM ACTIVE DATABASE

SECTION SIZE 400M;

exit;

EOF

Logs:

[root@oraclelab1 ~]# ps -ef|grep smon

oracle 2533 1 0 Jun09 ? 00:00:01 ora_smon_CDBDB

root 9047 8869 0 22:48 pts/0 00:00:00 grep --color=auto smon

[root@oraclelab1 ~]# su - oracle

Last login: Fri Jun 10 10:48:59 IST 2022 on pts/0

[oracle@oraclelab1 ~]$

[oracle@oraclelab1 ~]$ . oraenv

ORACLE_SID = [oracle] ? CDBDB

The Oracle base has been set to /u01/app/oracle

[oracle@oraclelab1 ~]$

[oracle@oraclelab1 ~]$ env |grep ORA

ORACLE_SID=CDBDB

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

[oracle@oraclelab1 ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jun 10 22:49:25 2022

Version 19.3.0.0.0

connected to target database: CDBDB (DBID=619735200)

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name CDBDB are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/snapcf_CDBDB.f'; # default

RMAN> list backup;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1 Full 17.95M DISK 00:00:00 08-JUN-22

BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20220608T235916

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_08/o1_mf_s_1106870356_kb1tmwjw_.bkp

SPFILE Included: Modification time: 08-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2154504 Ckp time: 08-JUN-22

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

2 181.36M DISK 00:00:00 09-JUN-22

BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003233

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T003233_kb1wl9hr_.bkp

List of Archived Logs in backup set 2

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 6 2133375 08-JUN-22 2158339 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

3 Full 1.14G DISK 00:00:07 09-JUN-22

BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003236

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003236_kb1wlf28_.bkp

List of Datafiles in backup set 3

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

1 Full 2158356 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf

3 Full 2158356 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1s830r_.dbf

4 Full 2158356 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1s8w3g_.dbf

7 Full 2158356 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

4 Full 470.74M DISK 00:00:02 09-JUN-22

BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003236

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003236_kb1wlw4m_.bkp

List of Datafiles in backup set 4

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2158362 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

10 Full 2158362 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

11 Full 2158362 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

12 Full 2158362 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

5 Full 470.59M DISK 00:00:01 09-JUN-22

BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003236

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4CDBF489E6715E053B404260A1371/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003236_kb1wlz9p_.bkp

List of Datafiles in backup set 5

Container ID: 4, PDB Name: PDB2

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

13 Full 2158364 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_system_kb1t99cn_.dbf

14 Full 2158364 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_sysaux_kb1t99co_.dbf

15 Full 2158364 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_undotbs1_kb1t99co_.dbf

16 Full 2158364 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_users_kb1t99cp_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

6 Full 552.96M DISK 00:00:02 09-JUN-22

BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003236

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F49D96A8D75BBFE053B404260AAAA9/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003236_kb1wm2gn_.bkp

List of Datafiles in backup set 6

Container ID: 2, PDB Name: PDB$SEED

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

5 Full 2150484 08-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1shgr8_.dbf

6 Full 2150484 08-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1shgrj_.dbf

8 Full 2150484 08-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1shgrm_.dbf

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

7 41.00K DISK 00:00:00 09-JUN-22

BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003305

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T003305_kb1wm9wq_.bkp

List of Archived Logs in backup set 7

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 7 2158339 09-JUN-22 2158374 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

8 Full 17.95M DISK 00:00:00 09-JUN-22

BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003307

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872387_kb1wmc64_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2158387 Ckp time: 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

9 Full 1.14G DISK 00:00:07 09-JUN-22

BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003620

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003620_kb1wsdr8_.bkp

List of Datafiles in backup set 9

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

1 Full 2159321 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf

3 Full 2159321 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1s830r_.dbf

4 Full 2159321 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1s8w3g_.dbf

7 Full 2159321 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

10 Full 17.95M DISK 00:00:01 09-JUN-22

BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003627

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872587_kb1wsn1o_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2159342 Ckp time: 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

11 Full 1.14G DISK 00:00:06 09-JUN-22

BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003645

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003645_kb1wt5nn_.bkp

List of Datafiles in backup set 11

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

1 Full 2159372 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf

3 Full 2159372 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1s830r_.dbf

4 Full 2159372 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1s8w3g_.dbf

7 Full 2159372 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

12 Full 17.95M DISK 00:00:00 09-JUN-22

BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003652

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872612_kb1wtdx6_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2159382 Ckp time: 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

13 Full 470.74M DISK 00:00:01 09-JUN-22

BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003736

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003736_kb1wvrc4_.bkp

List of Datafiles in backup set 13

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2159432 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

10 Full 2159432 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

11 Full 2159432 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

12 Full 2159432 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

14 Full 17.95M DISK 00:00:00 09-JUN-22

BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003739

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872659_kb1wvvm6_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2159441 Ckp time: 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

15 Full 470.74M DISK 00:00:02 09-JUN-22

BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003803

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003803_kb1wwmyo_.bkp

List of Datafiles in backup set 15

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2159475 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

10 Full 2159475 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

11 Full 2159475 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

12 Full 2159475 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

16 Full 470.59M DISK 00:00:02 09-JUN-22

BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003803

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4CDBF489E6715E053B404260A1371/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003803_kb1wwq5k_.bkp

List of Datafiles in backup set 16

Container ID: 4, PDB Name: PDB2

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

13 Full 2159477 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_system_kb1t99cn_.dbf

14 Full 2159477 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_sysaux_kb1t99co_.dbf

15 Full 2159477 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_undotbs1_kb1t99co_.dbf

16 Full 2159477 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_users_kb1t99cp_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

17 Full 17.95M DISK 00:00:00 09-JUN-22

BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003814

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872694_kb1wwyc4_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2159487 Ckp time: 09-JUN-22

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

18 181.94M DISK 00:00:01 09-JUN-22

BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003839

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T003839_kb1wxqrf_.bkp

List of Archived Logs in backup set 18

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 6 2133375 08-JUN-22 2158339 09-JUN-22

1 7 2158339 09-JUN-22 2158374 09-JUN-22

1 8 2158374 09-JUN-22 2159529 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

19 Full 470.74M DISK 00:00:01 09-JUN-22

BP Key: 19 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003842

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003842_kb1wxv18_.bkp

List of Datafiles in backup set 19

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2159542 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

10 Full 2159542 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

11 Full 2159542 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

12 Full 2159542 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

20 3.50K DISK 00:00:00 09-JUN-22

BP Key: 20 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003846

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T003846_kb1wxy9b_.bkp

List of Archived Logs in backup set 20

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 9 2159529 09-JUN-22 2159549 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

21 Full 17.95M DISK 00:00:00 09-JUN-22

BP Key: 21 Status: AVAILABLE Compressed: NO Tag: TAG20220609T003847

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872727_kb1wxzj1_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2159562 Ckp time: 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

22 Full 470.69M DISK 00:00:01 09-JUN-22

BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004131

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004131_kb1x33qy_.bkp

List of Datafiles in backup set 22

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2159708 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

10 Full 2159708 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

11 Full 2159708 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

12 Full 2159708 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

23 Full 470.69M DISK 00:00:01 09-JUN-22

BP Key: 23 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004157

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004157_kb1x3x9k_.bkp

List of Datafiles in backup set 23

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2159748 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

10 Full 2159748 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

11 Full 2159748 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

12 Full 2159748 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

24 Full 217.63M DISK 00:00:00 09-JUN-22

BP Key: 24 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004338

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004338_kb1x72fm_.bkp

List of Datafiles in backup set 24

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2159846 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

25 Full 469.21M DISK 00:00:01 09-JUN-22

BP Key: 25 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004350

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004350_kb1x7g9y_.bkp

List of Datafiles in backup set 25

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2159872 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

10 Full 2159872 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

12 Full 2159872 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

26 Full 217.63M DISK 00:00:00 09-JUN-22

BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004515

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004515_kb1xb3n5_.bkp

List of Datafiles in backup set 26

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

9 Full 2159966 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

27 Full 217.70M DISK 00:00:01 09-JUN-22

BP Key: 27 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004515

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4CDBF489E6715E053B404260A1371/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004515_kb1xb6qf_.bkp

List of Datafiles in backup set 27

Container ID: 4, PDB Name: PDB2

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

13 Full 2159969 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_system_kb1t99cn_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

28 Full 17.95M DISK 00:00:01 09-JUN-22

BP Key: 28 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004521

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106873121_kb1xb9yo_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2159978 Ckp time: 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

29 Full 773.35M DISK 00:00:04 09-JUN-22

BP Key: 29 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004637

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004637_kb1xdong_.bkp

List of Datafiles in backup set 29

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

1 Full 2160059 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

30 Full 17.95M DISK 00:00:00 09-JUN-22

BP Key: 30 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004644

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106873204_kb1xdwv1_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2160069 Ckp time: 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

31 Full 773.38M DISK 00:00:02 09-JUN-22

BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004936

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004936_kb1xl91t_.bkp

List of Datafiles in backup set 31

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

1 Full 2160520 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

32 Full 1.62M DISK 00:00:00 09-JUN-22

BP Key: 32 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004936

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004936_kb1xlj53_.bkp

List of Datafiles in backup set 32

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

11 Full 2160524 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

33 Full 1.55M DISK 00:00:00 09-JUN-22

BP Key: 33 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004936

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4CDBF489E6715E053B404260A1371/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004936_kb1xlk89_.bkp

List of Datafiles in backup set 33

Container ID: 4, PDB Name: PDB2

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

15 Full 2160525 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_undotbs1_kb1t99co_.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

34 Full 17.95M DISK 00:00:00 09-JUN-22

BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20220609T004946

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106873386_kb1xllgq_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2160533 Ckp time: 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

35 Full 252.19M DISK 00:00:01 09-JUN-22

BP Key: 35 Status: AVAILABLE Compressed: NO Tag: TAG20220609T005042

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T005042_kb1xnby3_.bkp

List of Datafiles in backup set 35

Container ID: 3, PDB Name: PDB1

File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name

---- -- ---- ---------- --------- ----------- ------ ----

10 Full 2160610 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

11 Full 2160610 09-JUN-22 NO /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

36 182.31M DISK 00:00:00 09-JUN-22

BP Key: 36 Status: AVAILABLE Compressed: NO Tag: TAG20220609T005211

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T005211_kb1xq3kc_.bkp

List of Archived Logs in backup set 36

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 6 2133375 08-JUN-22 2158339 09-JUN-22

1 7 2158339 09-JUN-22 2158374 09-JUN-22

1 8 2158374 09-JUN-22 2159529 09-JUN-22

1 9 2159529 09-JUN-22 2159549 09-JUN-22

1 10 2159549 09-JUN-22 2160686 09-JUN-22

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

37 Full 17.95M DISK 00:00:00 09-JUN-22

BP Key: 37 Status: AVAILABLE Compressed: NO Tag: TAG20220609T005214

Piece Name: /u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106873534_kb1xq6qg_.bkp

SPFILE Included: Modification time: 09-JUN-22

SPFILE db_unique_name: CDBDB

Control File Included: Ckp SCN: 2160707 Ckp time: 09-JUN-22

RMAN>

RMAN> exit

Recovery Manager complete.

[oracle@oraclelab1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 10 22:54:31 2022

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> desc dba_data_files;

Name Null? Type

----------------------------------------- -------- ----------------------------

FILE_NAME VARCHAR2(513)

FILE_ID NUMBER

TABLESPACE_NAME VARCHAR2(30)

BYTES NUMBER

BLOCKS NUMBER

STATUS VARCHAR2(9)

RELATIVE_FNO NUMBER

AUTOEXTENSIBLE VARCHAR2(3)

MAXBYTES NUMBER

MAXBLOCKS NUMBER

INCREMENT_BY NUMBER

USER_BYTES NUMBER

USER_BLOCKS NUMBER

ONLINE_STATUS VARCHAR2(7)

LOST_WRITE_PROTECT VARCHAR2(7)

SQL> set pages 1000 lines 1000

SQL> dhow pdbs

SP2-0042: unknown command "dhow pdbs" - rest of line ignored.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB1 READ WRITE NO

4 PDB2 READ WRITE NO

SQL>

SQL> select FILE_ID, FILE_NAME from dba_data_files;

FILE_ID FILE_NAME

---------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

7 /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf

4 /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1s8w3g_.dbf

1 /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf

3 /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1s830r_.dbf

SQL> alter session set container=PDB1;

Session altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

3 PDB1 READ WRITE NO

SQL> select FILE_ID, FILE_NAME from dba_data_files;

FILE_ID FILE_NAME

9 /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf

10 /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf

11 /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf

12 /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

SQL> alter session set container=PDB2;

Session altered.

SQL> select FILE_ID, FILE_NAME from dba_data_files;

FILE_ID FILE_NAME

13 /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_system_kb1t99cn_.dbf

14 /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_sysaux_kb1t99co_.dbf

15 /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_undotbs1_kb1t99co_.dbf

16 /u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_users_kb1t99cp_.dbf

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oraclelab1 ~]$ rman target=sys@PDB1

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jun 10 22:56:46 2022

Version 19.3.0.0.0

target database Password:

connected to target database: CDBDB:PDB1 (DBID=2604719255)

RMAN> ALTER DATABASE DATAFILE 12 OFFLINE;

using target database control file instead of recovery catalog

Statement processed

RMAN> RESTORE DATAFILE 12;

Starting restore at 10-JUN-22

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=266 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 00012 to /u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004350_kb1x7g9y_.bkp

channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004350_kb1x7g9y_.bkp tag=TAG20220609T004350

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 10-JUN-22

RMAN> RECOVER DATAFILE 12;

Starting recover at 10-JUN-22

using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 10 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_10_kb1xq2qc_.arc

archived log for thread 1 with sequence 11 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_11_kb2zmyxx_.arc

archived log for thread 1 with sequence 12 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_12_kb3osm1x_.arc

archived log for thread 1 with sequence 13 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_13_kb3xp5ks_.arc

archived log for thread 1 with sequence 14 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_10/o1_mf_1_14_kb59gtgb_.arc

archived log file name=/u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_10_kb1xq2qc_.arc thread=1 sequence=10

archived log file name=/u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_11_kb2zmyxx_.arc thread=1 sequence=11

archived log file name=/u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_12_kb3osm1x_.arc thread=1 sequence=12

media recovery complete, elapsed time: 00:00:01

Finished recover at 10-JUN-22

RMAN> ALTER DATABASE DATAFILE 12 ONLINE;

Statement processed

RMAN> exit

Recovery Manager complete.

[oracle@oraclelab1 ~]$

[oracle@oraclelab1 ~]$ rman target=sys@CDBDB

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jun 10 22:59:13 2022

Version 19.3.0.0.0

target database Password:

connected to target database: CDBDB (DBID=619735200)

RMAN> ALTER DATABASE DATAFILE 7 OFFLINE;

using target database control file instead of recovery catalog

Statement processed

RMAN> RESTORE DATAFILE 7;

Starting restore at 10-JUN-22

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=4 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 00007 to /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003645_kb1wt5nn_.bkp

channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003645_kb1wt5nn_.bkp tag=TAG20220609T003645

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 10-JUN-22

RMAN> RECOVER DATAFILE 7;

Starting recover at 10-JUN-22

using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 8 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_8_kb1wxqm2_.arc

archived log for thread 1 with sequence 9 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_9_kb1wxy33_.arc

archived log for thread 1 with sequence 10 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_10_kb1xq2qc_.arc

archived log for thread 1 with sequence 11 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_11_kb2zmyxx_.arc

archived log for thread 1 with sequence 12 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_12_kb3osm1x_.arc

archived log for thread 1 with sequence 13 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_13_kb3xp5ks_.arc

archived log for thread 1 with sequence 14 is already on disk as file /u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_10/o1_mf_1_14_kb59gtgb_.arc

archived log file name=/u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_8_kb1wxqm2_.arc thread=1 sequence=8

archived log file name=/u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_9_kb1wxy33_.arc thread=1 sequence=9

archived log file name=/u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_10_kb1xq2qc_.arc thread=1 sequence=10

archived log file name=/u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_11_kb2zmyxx_.arc thread=1 sequence=11

archived log file name=/u01/app/oracle/fast_recovery_area/CDBDB/archivelog/2022_06_09/o1_mf_1_12_kb3osm1x_.arc thread=1 sequence=12

media recovery complete, elapsed time: 00:00:01

Finished recover at 10-JUN-22

RMAN> ALTER DATABASE DATAFILE 7 ONLINE;

Statement processed

RMAN> exit

Recovery Manager complete.

[oracle@oraclelab1 ~]$ rman target=sys@PDB1

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jun 10 23:00:50 2022

Version 19.3.0.0.0

target database Password:

connected to target database: CDBDB:PDB1 (DBID=2604719255)

RMAN> RUN {

ALTER TABLESPACE users OFFLINE;

RESTORE TABLESPACE users;

RECOVER TABLESPACE users;

ALTER TABLESPACE users ONLINE;

}2> 3> 4> 5> 6>

using target database control file instead of recovery catalog

Statement processed

Starting restore at 10-JUN-22

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=35 device type=DISK