Database RAC Dataguard RMAN Performance Tuning Feedback
Database Migration & Upgradation
DataGuard
ASM & RAC
Exadata
RMAN Backup & Recovery
Oracle Cloud AWS Azure Google Cloud
DevOps Ansible Kubernetes Terraform
Shell Scripting Powershell Scripting
Infomratica Others

Thursday, June 9, 2022

CDB & PDB Backups - Complete Understanding of CBD & PDB Backups - Oracle Multitenant backups

CDB & PDB Backups:

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

Backup:

Container Database (CDB) Backup:

$ rman target=/
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Root Container Backup:

$ rman target=/
RMAN> BACKUP DATABASE ROOT;

CDB root backup:

$ rman target=/
RMAN> backup pluggable database "CDB$ROOT";

Pluggable Database (PDB) Backup:

$ rman target=/
RMAN> BACKUP PLUGGABLE DATABASE PDB1;
RMAN> BACKUP PLUGGABLE DATABASE PDB1, PDB2;
RMAN> backup pluggable database PDB1 plus archivelog;

$ rman target=sys@PDB1
RMAN> BACKUP DATABASE;
RMAN> backup pluggable database PDB1 plus archivelog;

Tablespace Backups of a PDB:

$ rman target=sys@PDB1
RMAN> BACKUP TABLESPACE system, sysaux, users;
RMAN> BACKUP TABLESPACE system;

$ rman target=sys@CDBDB
RMAN> BACKUP TABLESPACE pdb1:system, pdb1:sysaux, pdb1:users, pdb2:system;
RMAN> BACKUP TABLESPACE PDB1:system, PDB2:system;

Tablespace Backups of a CDB:

RMAN> BACKUP TABLESPACE system, sysaux, users, system;
RMAN> BACKUP TABLESPACE system;

Datafile Backups of a PDB:

Datafiles have unique file numbers and fully qualified names, so they can be backed up from the root container or the individual PDB.
$ rman target=/
# Or
$ rman target=sys@PDB1
RMAN> BACKUP DATAFILE 8, 9, 10;


Archived Redo Log Backups of CDB: 

No archive logs are PDB level 
$ rman target=/
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
RMAN> BACKUP ARCHIVELOG ALL;

Logs:

[oracle@oraclelab1 admin]$ ps -ef|grep smon
oracle    7961     1  0 May16 ?        00:00:33 ora_smon_DEVDB
oracle   25655     1  0 Jun08 ?        00:00:00 ora_smon_CDBDB
oracle   28632 21422  0 00:29 pts/1    00:00:00 grep --color=auto smon
[oracle@oraclelab1 admin]$ cat /etc/oratab
#
# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
DEVDB:/u01/app/oracle/product/19.0.0.0/dbhome_1:N
CDBDB:/u01/app/oracle/product/19.0.0.0/dbhome_1:N
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$ 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 admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 9 00:30:15 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>
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> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_
                                                 area
db_recovery_file_dest_size           big integer 12732M
recovery_parallelism                 integer     0
remote_recovery_file_dest            string
SQL> alter system set db_recovery_file_dest_size=30G scope=both;

System altered.

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_
                                                 area
db_recovery_file_dest_size           big integer 30G
recovery_parallelism                 integer     0
remote_recovery_file_dest            string
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@oraclelab1 admin]$ rman target=/

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:32:06 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CDBDB (DBID=619735200)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
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

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;


Starting backup at 09-JUN-22
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=268 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=1 STAMP=1106872352
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T003233_kb1wl9hr_.bkp tag=TAG20220609T003233 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1s830r_.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1s8w3g_.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003236_kb1wlf28_.bkp tag=TAG20220609T003236 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003236_kb1wlw4m_.bkp tag=TAG20220609T003236 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00014 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_sysaux_kb1t99co_.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_system_kb1t99cn_.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_undotbs1_kb1t99co_.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_users_kb1t99cp_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4CDBF489E6715E053B404260A1371/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003236_kb1wlz9p_.bkp tag=TAG20220609T003236 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1shgrj_.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1shgr8_.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1shgrm_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F49D96A8D75BBFE053B404260AAAA9/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003236_kb1wm2gn_.bkp tag=TAG20220609T003236 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 09-JUN-22

Starting backup at 09-JUN-22
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=7 RECID=2 STAMP=1106872385
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T003305_kb1wm9wq_.bkp tag=TAG20220609T003305 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872387_kb1wmc64_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

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

RMAN> BACKUP DATABASE ROOT;

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1s830r_.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1s8w3g_.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003620_kb1wsdr8_.bkp tag=TAG20220609T003620 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872587_kb1wsn1o_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN> backup pluggable database "CDB$ROOT";

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1s830r_.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1s8w3g_.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003645_kb1wt5nn_.bkp tag=TAG20220609T003645 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872612_kb1wtdx6_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN> BACKUP PLUGGABLE DATABASE PDB1;

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003736_kb1wvrc4_.bkp tag=TAG20220609T003736 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872659_kb1wvvm6_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN> BACKUP PLUGGABLE DATABASE PDB1, PDB2;

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003803_kb1wwmyo_.bkp tag=TAG20220609T003803 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00014 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_sysaux_kb1t99co_.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_system_kb1t99cn_.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_undotbs1_kb1t99co_.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_users_kb1t99cp_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4CDBF489E6715E053B404260A1371/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003803_kb1wwq5k_.bkp tag=TAG20220609T003803 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872694_kb1wwyc4_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN> backup pluggable database PDB1 plus archivelog;


Starting backup at 09-JUN-22
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=1 STAMP=1106872352
input archived log thread=1 sequence=7 RECID=2 STAMP=1106872385
input archived log thread=1 sequence=8 RECID=3 STAMP=1106872719
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T003839_kb1wxqrf_.bkp tag=TAG20220609T003839 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T003842_kb1wxv18_.bkp tag=TAG20220609T003842 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

Starting backup at 09-JUN-22
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=4 STAMP=1106872726
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T003846_kb1wxy9b_.bkp tag=TAG20220609T003846 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106872727_kb1wxzj1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN> exit


Recovery Manager complete.
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$ rman target=sys@PDB1

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:39:37 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

target database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12154: TNS:could not resolve the connect identifier specified
[oracle@oraclelab1 admin]$ rman target=sys@PDB1

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:39:46 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

target database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12154: TNS:could not resolve the connect identifier specified
[oracle@oraclelab1 admin]$ tnsping PDB1

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 09-JUN-2022 00:39:53

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin
[oracle@oraclelab1 admin]$ ls -ltr
total 32
-rw-r--r--. 1 oracle oinstall 1536 Feb 14  2018 shrept.lst
drwxr-xr-x. 2 oracle oinstall   64 Apr 17  2019 samples
-rw-r--r--. 1 oracle oinstall  303 May  2 20:09 listener.ora_bkp
-rw-r--r--. 1 oracle oinstall  333 May  2 20:16 tnsnames.ora_bkp
-rw-r-----. 1 oracle oinstall  319 Jun  8 23:35 listener22060811PM3500.bak
-rw-r-----. 1 oracle oinstall  350 Jun  8 23:35 tnsnames22060811PM3500.bak
-rw-r-----. 1 oracle oinstall  204 Jun  8 23:35 sqlnet.ora
-rw-r--r--. 1 oracle oinstall  641 Jun  8 23:43 tnsnames.ora
-rw-r--r--. 1 oracle oinstall  351 Jun  8 23:52 listener.ora
[oracle@oraclelab1 admin]$ vi tnsnames.ora
[oracle@oraclelab1 admin]$ tnsping PDB1

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 09-JUN-2022 00:40:57

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PDB1)))
OK (10 msec)
[oracle@oraclelab1 admin]$ rman target=sys@PDB1

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:41:05 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

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

RMAN> BACKUP DATABASE;

Starting backup at 09-JUN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=275 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004131_kb1x33qy_.bkp tag=TAG20220609T004131 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

RMAN> backup pluggable database PDB1 plus archivelog;


Starting backup at 09-JUN-22
using channel ORA_DISK_1
skipping archived logs when connected to a PDB
backup cancelled because there are no files to backup
Finished backup at 09-JUN-22

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004157_kb1x3x9k_.bkp tag=TAG20220609T004157 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

Starting backup at 09-JUN-22
using channel ORA_DISK_1
skipping archived logs when connected to a PDB
backup cancelled because there are no files to backup
Finished backup at 09-JUN-22

RMAN> exit


Recovery Manager complete.
[oracle@oraclelab1 admin]$ rman target=sys@PDB1

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:43:08 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

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

RMAN> BACKUP TABLESPACE system;

Starting backup at 09-JUN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=268 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004338_kb1x72fm_.bkp tag=TAG20220609T004338 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

RMAN> BACKUP TABLESPACE system, sysaux, users;

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_users_kb1t1cnh_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004350_kb1x7g9y_.bkp tag=TAG20220609T004350 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

RMAN> exit


Recovery Manager complete.
[oracle@oraclelab1 admin]$ rman target=sys@CDBDB

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:44:49 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: CDBDB (DBID=619735200)

RMAN> BACKUP TABLESPACE PDB1:system, PDB2:system;

Starting backup at 09-JUN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=275 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_system_kb1t1415_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004515_kb1xb3n5_.bkp tag=TAG20220609T004515 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00013 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_system_kb1t99cn_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4CDBF489E6715E053B404260A1371/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004515_kb1xb6qf_.bkp tag=TAG20220609T004515 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106873121_kb1xb9yo_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN> BACKUP TABLESPACE system;

Starting backup at 09-JUN-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004637_kb1xdong_.bkp tag=TAG20220609T004637 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106873204_kb1xdwv1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN> exit


Recovery Manager complete.
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 9 00:47:26 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


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> select FILE_ID,FILE_NAME from dba_data_files;

   FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
         1
/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf

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

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


   FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
         7
/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf


SQL> set pages 10000 lines 10000
SQL> /

   FILE_ID FILE_NAME
---------- --------------------------------------------------------------------------------------------------------------------------         
1 /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf
         3 /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_sysaux_kb1s830r_.dbf
         4 /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_undotbs1_kb1s8w3g_.dbf
         7 /u01/app/oracle/oradata/CDBDB/datafile/o1_mf_users_kb1s8x6q_.dbf

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> alter session set container=PDB1;

Session altered.

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 admin]$ rman target=/

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:48:59 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CDBDB (DBID=619735200)

RMAN> BACKUP DATAFILE 1,11,15;

Starting backup at 09-JUN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=282 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/CDBDB/datafile/o1_mf_system_kb1s6zv5_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004936_kb1xl91t_.bkp tag=TAG20220609T004936 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004936_kb1xlj53_.bkp tag=TAG20220609T004936 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/u01/app/oracle/oradata/CDBDB/E0F4CDBF489E6715E053B404260A1371/datafile/o1_mf_undotbs1_kb1t99co_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4CDBF489E6715E053B404260A1371/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T004936_kb1xlk89_.bkp tag=TAG20220609T004936 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106873386_kb1xllgq_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN> exit


Recovery Manager complete.
[oracle@oraclelab1 admin]$ rman target=sys@PDB1

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:50:09 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

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

RMAN> BACKUP DATAFILE 10,11;

Starting backup at 09-JUN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=275 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_sysaux_kb1t141f_.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/CDBDB/E0F4BE2C2A70647BE053B404260A606F/datafile/o1_mf_undotbs1_kb1t141g_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/E0F4BE2C2A70647BE053B404260A606F/backupset/2022_06_09/o1_mf_nnndf_TAG20220609T005042_kb1xnby3_.bkp tag=TAG20220609T005042 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

RMAN> BACKUP DATAFILE 14,15;

Starting backup at 09-JUN-22
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/09/2022 00:51:01
RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: 14

RMAN> exit


Recovery Manager complete.
[oracle@oraclelab1 admin]$ rman target=/

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 9 00:52:03 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CDBDB (DBID=619735200)

RMAN> BACKUP ARCHIVELOG ALL;

Starting backup at 09-JUN-22
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=282 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=1 STAMP=1106872352
input archived log thread=1 sequence=7 RECID=2 STAMP=1106872385
input archived log thread=1 sequence=8 RECID=3 STAMP=1106872719
input archived log thread=1 sequence=9 RECID=4 STAMP=1106872726
input archived log thread=1 sequence=10 RECID=5 STAMP=1106873530
channel ORA_DISK_1: starting piece 1 at 09-JUN-22
channel ORA_DISK_1: finished piece 1 at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/backupset/2022_06_09/o1_mf_annnn_TAG20220609T005211_kb1xq3kc_.bkp tag=TAG20220609T005211 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-22

Starting Control File and SPFILE Autobackup at 09-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/CDBDB/autobackup/2022_06_09/o1_mf_s_1106873534_kb1xq6qg_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-22

RMAN>

Regards,
Mallik
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

-bash: oraenv: No such file or directory

-bash: oraenv: No such file or directory What Are Root.sh And OrainstRoot.sh Scripts In A Standalone RDBMS Installation? (Doc ID 1493121.1) ...