RMAN backup in Multitenant database (CDB) Oracle 12c

 

Backup full database (CDB + all PDBs):

It is similar to non-CDB database. Connect to root container and run the below commands.

rman target /

backup database;  ---- this will backed up CDB and all PDBs

backup archivelog all;

backup database plus archivelog;


[oracle@oracle12c rman_backup]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Sat Jun 11 17:24:01 2022
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
connected to target database: PRDCDB (DBID=3622167870)
RMAN> backup database;
Starting backup at 11-JUN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=73 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=00020 name=/u01/app/oracle/oradata/dupdb/undotbs01.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/dupdb/system01.dbf
input datafile file number=00019 name=/u01/app/oracle/oradata/dupdb/sysaux01.dbf
input datafile file number=00021 name=/u01/app/oracle/oradata/dupdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUN-22
channel ORA_DISK_1: finished piece 1 at 11-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0f0vq61n_1_1 tag=TAG20220611T172407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
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/prdcdb/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/prdcdb/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/prdcdb/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/prdcdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUN-22
channel ORA_DISK_1: finished piece 1 at 11-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0g0vq63e_1_1 tag=TAG20220611T172407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
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/prdcdb/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/prdcdb/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/prdcdb/pdb1/undotbs01.dbf
input datafile file number=00022 name=/u01/app/oracle/oradata/prdcdb/pdb1/hr01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUN-22
channel ORA_DISK_1: finished piece 1 at 11-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0h0vq656_1_1 tag=TAG20220611T172407 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=00028 name=/u01/app/oracle/oradata/prdcdb/pdb5sysaux01.dbf
input datafile file number=00027 name=/u01/app/oracle/oradata/prdcdb/pdb5system01.dbf
input datafile file number=00029 name=/u01/app/oracle/oradata/prdcdb/pdb5undotbs01.dbf
input datafile file number=00030 name=/u01/app/oracle/oradata/prdcdb/pdb5hr01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUN-22
channel ORA_DISK_1: finished piece 1 at 11-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0i0vq65l_1_1 tag=TAG20220611T172407 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=00032 name=/u01/app/oracle/oradata/prdcdb/pdb4/sysaux01.dbf
input datafile file number=00031 name=/u01/app/oracle/oradata/prdcdb/pdb4/system01.dbf
input datafile file number=00033 name=/u01/app/oracle/oradata/prdcdb/pdb4/undotbs01.dbf
input datafile file number=00034 name=/u01/app/oracle/oradata/prdcdb/pdb4/hr01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUN-22
channel ORA_DISK_1: finished piece 1 at 11-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0j0vq664_1_1 tag=TAG20220611T172407 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=00013 name=/u01/app/oracle/oradata/prdcdb/pdb2sysaux01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/prdcdb/pdb2system01.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/prdcdb/pdb2undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUN-22
channel ORA_DISK_1: finished piece 1 at 11-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0k0vq66j_1_1 tag=TAG20220611T172407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
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/prdcdb/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/prdcdb/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/prdcdb/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUN-22
channel ORA_DISK_1: finished piece 1 at 11-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0l0vq67d_1_1 tag=TAG20220611T172407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 11-JUN-22
Starting Control File and SPFILE Autobackup at 11-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/prdcdb/PRDCDB/autobackup/2022_06_11/o1_mf_s_1107106044_kbb25wfr_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 11-JUN-22



Backup PDBs:

rman target /    ------------- Connect to root container and run the below command to backup PDB

backup pluggable database pdb1;

backup pluggable database pdb1,pdb2;   ---------------- multiple PDBs

RMAN> backup pluggable database pdb1;
Starting backup at 11-JUN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=72 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/prdcdb/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/prdcdb/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/prdcdb/pdb1/undotbs01.dbf
input datafile file number=00022 name=/u01/app/oracle/oradata/prdcdb/pdb1/hr01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUN-22
channel ORA_DISK_1: finished piece 1 at 11-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0c0vq5vb_1_1 tag=TAG20220611T172251 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 11-JUN-22
Starting Control File and SPFILE Autobackup at 11-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/prdcdb/PRDCDB/autobackup/2022_06_11/o1_mf_s_1107105775_kbb1xj0c_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 11-JUN-22

Backup only container database excluding PDBs:


rman target /

RMAN> backup database root;


RMAN> backup database root;
Starting backup at 12-JUN-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=52 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/prdcdb/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/prdcdb/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/prdcdb/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/prdcdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 12-JUN-22
channel ORA_DISK_1: finished piece 1 at 12-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0n0vrh5n_1_1 tag=TAG20220612T054005 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:51
Finished backup at 12-JUN-22
Starting Control File and SPFILE Autobackup at 12-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/prdcdb/PRDCDB/autobackup/2022_06_12/o1_mf_s_1107150179_kbcf93vy_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 12-JUN-22


Backup Tablespace:

rman target /

RMAN> backup tablespace pdb1:system, pdb1:sysaux, pdb2:system;


RMAN> backup tablespace pdb1:system, pdb1:sysaux, pdb2:system;
Starting backup at 12-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/prdcdb/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/prdcdb/pdb1/system01.dbf
channel ORA_DISK_1: starting piece 1 at 12-JUN-22
channel ORA_DISK_1: finished piece 1 at 12-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0p0vrhc4_1_1 tag=TAG20220612T054331 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00012 name=/u01/app/oracle/oradata/prdcdb/pdb2system01.dbf
channel ORA_DISK_1: starting piece 1 at 12-JUN-22
channel ORA_DISK_1: finished piece 1 at 12-JUN-22
piece handle=/u01/rman_backup/PRDCDB_backup_0q0vrhdi_1_1 tag=TAG20220612T054331 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 12-JUN-22
Starting Control File and SPFILE Autobackup at 12-JUN-22
piece handle=/u01/app/oracle/fast_recovery_area/prdcdb/PRDCDB/autobackup/2022_06_12/o1_mf_s_1107150275_kbcfd433_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 12-JUN-22

Connect CDB: rman target /

[oracle@oracle12c ~]$ rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Sun Jun 12 05:51:07 2022
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
connected to target database: PRDCDB (DBID=3622167870)
RMAN>

Connect PDB: rman target sys@pdb1


[oracle@oracle12c ~]$ rman target sys@pdb1
Recovery Manager: Release 12.2.0.1.0 - Production on Sun Jun 12 05:50:38 2022
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
target database Password:
connected to target database: PRDCDB:PDB1 (DBID=3525986521)

Comments

Post a Comment

Popular posts from this blog

Auditing in Oracle database

Unified Auditing: Oracle Database 12c Release 1 introduces a new auditing feature called Unified Auditing (12.1). Oracle Unified Auditing modifies the database's fundamental auditing capabilities. In earlier versions of Oracle, each component has its own audit trail. With unified auditing, all auditing is compiled into a single repository and view. Due to the fact that all audit data is now in a single location and a single format, there is a double simplification as a result. This data is made available in a consistent format in the UNIFIED AUDIT TRAIL data dictionary view, which is made possible by the unified audit trail, which is stored in a read-only table in the AUDSYS schema in the SYSAUX tablespace.  DBAs can build audit rules and then assign them to various users using Oracle 12c Unified Auditing, which has the same advantages as giving users varying system capabilities based on their responsibilities. The unified_audit_trail database will contain all of the audit records....
Read more

rs.stepDown() in MongoDB replication

It instructs the primary of the replica set to become a secondary. After the primary steps down,the eligible secondaries will hold an election for primary. Generally, the rs.stepDown() does not immediately step down the primary. If no electable secondaries are up to date with the primary, the primary waits up to secondaryCatchUpPeriodSecs (by default 10 seconds)  for a secondary to catch up. Once an electable secondary is available, the method steps down the priamry.  Once stepped down, the original primary becomes a secondary and is ineligible from becoming primary again for the remainder of time specified by stepDownSecs. The rs.stepDown() method attempts to terminate long-running user's operations that block the primary from stepping down, such as an index build, a write operation, or a map-reduce job. Syntax: rs.stepDown(stepDownSecs, secondaryCatchUpPeriodSecs)
Read more

Tuples in Python

 Tuples Basically Tuples in Python are very similar to Lists, but, Tuples are immutable which means that they can not be modified/changed. We generally use Tuples to make sure the values are not changed like, dates, Year, and days of the week or dates on a Calendar.  Creating a Tuple: >>> my_t1=(1,2,3) >>> my_t2=('one','two','three') >>> my_t1 (1, 2, 3) >>> my_t2 ('one', 'two', 'three') -- check the length of tupple: >>> len(my_t1) 3 >>> len(my_t2) 3 -- Tuples can have mixed objects as like Lists. >>> my_t3=(1,'two',3,'four') >>> my_t3 (1, 'two', 3, 'four') -- indexing with tuples  >>> my_t3=(1,'two',3,'four') >>> my_t3[2] 3 Immutable Tuples We can not modify the value. Here is the example: >>> my_t3=(1,'two',3,'four') >>> my_t3[2]=4 Traceback (most recent call last):  ...
Read more