- 23 Nov, 2023
- 0 Comments
- 3 Mins Read
RMAN Backup In Multitenant Database Oracle 12c
As multi-tenant feature introduced in oracle 12c, New commands are there for taking rman backup of pluggable database and root container database.
Now Connect to root container
Backup of complete container( ROOT + ALL PDBS ) :
1 2 3 4 5 6 7 8 9 10 | SQL> show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO3 PRIM READ WRITE NO5 PROD_MN READ WRITE NOSQL> exitDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | [oracle@localhost ~]$ rman target sys/oracle@cdb1Recovery Manager: Release 12.1.0.2.0 - Production on Thu Nov 23 22:46:04 2023Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.connected to target database: CDB1 (DBID=828012650)RMAN> backup database plus archivelog2> ;Starting backup at 23-NOV-23current log archivedusing target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=30 device type=DISKchannel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=165 RECID=1 STAMP=886318673input archived log thread=1 sequence=166 RECID=2 STAMP=886319099input archived log thread=1 sequence=167 RECID=3 STAMP=886320315input archived log thread=1 sequence=168 RECID=4 STAMP=886321194channel ORA_DISK_1: finished piece 1 at 23-NOV-23piece handle=/home/oracle/app/oracle/fast_recovery_area/CDB1/backupset/2023_08_28/o1_mf_annnn_TAG20230828T224727_by2kxold_.bkp tag=TAG20230828T224727 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:56Finished backup at 23-NOV-23Starting backup at 23-NOV-23using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00031 name=/home/oracle/app/oracle/oradata/cdb1/testencry.dbfinput datafile file number=00003 name=/home/oracle/app/oracle/oradata/cdb1/sysaux01.dbfinput datafile file number=00001 name=/home/oracle/app/oracle/oradata/cdb1/system01.dbfinput datafile file number=00004 name=/home/oracle/app/oracle/oradata/cdb1/undotbs01.dbfinput datafile file number=00034 name=/home/oracle/app/oracle/oradata/cdb1/dataconversion.dbfinput datafile file number=00037 name=/home/oracle/app/oracle/oradata/cdb1/testin1.dbfinput datafile file number=00006 name=/home/oracle/app/oracle/oradata/cdb1/users01.dbfchannel ORA_DISK_1: starting piece 1 at 23-NOV-23Starting backup at 23-NOV-23current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=268 RECID=104 STAMP=888965884channel ORA_DISK_1: starting piece 1 at 23-NOV-23channel ORA_DISK_1: finished piece 1 at 23-NOV-23piece handle=/home/oracle/app/oracle/fast_recovery_area/CDB1/backupset/2023_08_28/o1_mf_annnn_TAG20230828T225804_by2lhdwl_.bkp tag=TAG20230828T225804 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 23-NOV-23Starting Control File and SPFILE Autobackup at 23-NOV-23piece handle=/home/oracle/app/oracle/fast_recovery_area/CDB1/autobackup/2023_08_28/o1_mf_s_888965886_by2lhhc8_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 23-NOV-23 |
Taking backup of particular pluggable database:(backup pluggable database PRIM;)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | [oracle@node1 admin]$ rman target=sys@PRIMRecovery Manager: Release 12.1.0.2.0 - Production on Sat Aug 29 01:12:28 2023Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.target database Password:connected to target database: CDB1 (DBID=828012650)RMAN> backup tablespace USERS;Starting backup at 23-NOV-23using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00010 name=/home/oracle/app/oracle/oradata/cdb1/PRIM/SAMPLE_SCHEMA_users01.dbfchannel ORA_DISK_1: starting piece 1 at 23-NOV-23channel ORA_DISK_1: finished piece 1 at 23-NOV-23piece handle=/home/oracle/app/oracle/fast_recovery_area/CDB1/FF72AA85A0370D5BE045000000000001/backupset/2023_08_29/o1_mf_nnndf_TAG20230829T011323_by2tf3vl_.bkp tag=TAG20230829T011323 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07Finished backup at 23-NOV-23Starting Control File and SPFILE Autobackup at 23-NOV-23piece handle=/home/oracle/app/oracle/fast_recovery_area/CDB1/autobackup/2023_08_29/o1_mf_s_888974011_by2tfcd3_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 23-NOV-23 |