RMAN CONNECTIONS:
[oracle@ram ~]$ export ORACLE_SID=dbwr [oracle@ram ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Tue Oct 9 02:56:50 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 2516582400 bytes Fixed Size 8795904 bytes Variable Size 671090944 bytes Database Buffers 1828716544 bytes Redo Buffers 7979008 bytes Database mounted. Database opened. SQL> ! [oracle@ram ~]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Tue Oct 9 02:57:12 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: DBWR (DBID=1322876759) RMAN>
Container Database (CDB) Backup:
A full backup of the CDB you are also doing a full backup of all PDBs.
Connect to RMAN using OS authentication and take a full backup using the following command. This means you are connecting to the root container with “AS SYSDBA” privilege.
[oracle@ram ~]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Tue Oct 9 02:57:12 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: DBWR (DBID=1322876759) RMAN>
The datafiles associated with the CBD and all the PDBs (pdb5, pdb6, pdb$seed) are included in the backup.
RMAN> backup database plus archivelog; Starting backup at 09-OCT-18 current log archived using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=53 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=9 RECID=1 STAMP=989032088 channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/backupset/2018_10_09/o1_mf_annnn_TAG20181009T030809_fvqml1tn_.bkp tag=TAG20181009T030809 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 09-OCT-18 Starting backup at 09-OCT-18 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/DBWR/datafile/o1_mf_system_fvgqv1n6_.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvgqxhq9_.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_undotbs1_fvgqyx60_.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvgqyy96_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T030811_fvqml3k6_.bkp tag=TAG20181009T030811 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00022 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvhgn44v_.dbf input datafile file number=00021 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_system_fvhgn44z_.dbf input datafile file number=00023 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_undotbs1_fvhgn452_.dbf input datafile file number=00024 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvhgn454_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/77813D4B379738F5E0536501A8C05864/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T030811_fvqmp18w_.bkp tag=TAG20181009T030811 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56 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/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_sysaux_fvgzclb4_.dbf input datafile file number=00013 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_system_fvgzcl9q_.dbf input datafile file number=00015 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_undotbs1_fvgzclb5_.dbf input datafile file number=00016 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_users_fvgzd8cs_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/777D95E41A572D82E053DD971D40E224/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T030811_fvqmqsfz_.bkp tag=TAG20181009T030811 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/DBWR/datafile/o1_mf_sysaux_fvgr1m08_.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_system_fvgr1m0c_.dbf input datafile file number=00008 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_undotbs1_fvgr1m0f_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/777BDA91F244116BE053DD971D400082/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T030811_fvqmrlvp_.bkp tag=TAG20181009T030811 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 Finished backup at 09-OCT-18 Starting backup at 09-OCT-18 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=10 RECID=2 STAMP=989032324 channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/backupset/2018_10_09/o1_mf_annnn_TAG20181009T031204_fvqmsdc7_.bkp tag=TAG20181009T031204 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 09-OCT-18 Starting Control File and SPFILE Autobackup at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/autobackup/2018_10_09/o1_mf_s_989032325_fvqmsgbb_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 09-OCT-18
Root Container Backup
A backup of the root container is a backup of the CDB, excluding any of the PDBs.
Connect to RMAN using OS authentication and backup the root container using the following command. This means you are connecting to the root container with “AS SYSDBA” privilege.
RMAN>rman target / RMAN> backup database root; Starting backup at 09-OCT-18 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/DBWR/datafile/o1_mf_system_fvgqv1n6_.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvgqxhq9_.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_undotbs1_fvgqyx60_.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvgqyy96_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T031649_fvqn2b13_.bkp tag=TAG20181009T031649 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56 Finished backup at 09-OCT-18 Starting Control File and SPFILE Autobackup at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/autobackup/2018_10_09/o1_mf_s_989032666_fvqn42vl_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 09-OCT-18 RMAN>
Pluggable Database (PDB) Backup
There are two ways to backup pluggable databases. When connected to RMAN as the root container, you can backup one or more PDBs
- backup pluggable database pdb5,pdb6;
- backup database; (Alternatively, connect to a specific PDB)
RMAN> rman target / RMAN> backup pluggable database pdb5,pdb6; Starting backup at 09-OCT-18 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=00022 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvhgn44v_.dbf input datafile file number=00021 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_system_fvhgn44z_.dbf input datafile file number=00023 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_undotbs1_fvhgn452_.dbf input datafile file number=00024 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvhgn454_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/77813D4B379738F5E0536501A8C05864/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T032310_fvqng76b_.bkp tag=TAG20181009T032310 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26 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/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_sysaux_fvgzclb4_.dbf input datafile file number=00013 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_system_fvgzcl9q_.dbf input datafile file number=00015 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_undotbs1_fvgzclb5_.dbf input datafile file number=00016 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_users_fvgzd8cs_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/777D95E41A572D82E053DD971D40E224/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T032310_fvqnh1n5_.bkp tag=TAG20181009T032310 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:31 Finished backup at 09-OCT-18 Starting Control File and SPFILE Autobackup at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/autobackup/2018_10_09/o1_mf_s_989033048_fvqnj0n4_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 09-OCT-18 RMAN>
Alternative way,
SQL> alter session set container = pdb5; Session altered. SQL> !
[oracle@ram ~]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Tue Oct 9 03:26:42 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: DBWR (DBID=1322876759) RMAN> backup database; Starting backup at 09-OCT-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=58 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/DBWR/datafile/o1_mf_system_fvgqv1n6_.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvgqxhq9_.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_undotbs1_fvgqyx60_.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvgqyy96_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T032653_fvqno5rt_.bkp tag=TAG20181009T032653 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:50 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00022 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvhgn44v_.dbf input datafile file number=00021 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_system_fvhgn44z_.dbf input datafile file number=00023 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_undotbs1_fvhgn452_.dbf input datafile file number=00024 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvhgn454_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/77813D4B379738F5E0536501A8C05864/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T032653_fvqnpr4p_.bkp tag=TAG20181009T032653 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26 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/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_sysaux_fvgzclb4_.dbf input datafile file number=00013 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_system_fvgzcl9q_.dbf input datafile file number=00015 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_undotbs1_fvgzclb5_.dbf input datafile file number=00016 name=/u01/app/oracle/oradata/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_users_fvgzd8cs_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/777D95E41A572D82E053DD971D40E224/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T032653_fvqnqk88_.bkp tag=TAG20181009T032653 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/DBWR/datafile/o1_mf_sysaux_fvgr1m08_.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_system_fvgr1m0c_.dbf input datafile file number=00008 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_undotbs1_fvgr1m0f_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/777BDA91F244116BE053DD971D400082/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T032653_fvqnrbgm_.bkp tag=TAG20181009T032653 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:30 Finished backup at 09-OCT-18 Starting Control File and SPFILE Autobackup at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/autobackup/2018_10_09/o1_mf_s_989033344_fvqns92k_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 09-OCT-18 RMAN>
Tablespace and Datafile Backups
Multiple PDBs in the same CDB can have a tablespace with the same name, for example SYSTEM, SYSAUX and USERS.
we can remove that through directly connect to the appropriate PDB.
Once RMAN is connected to the PDB, the tablespace backup commands is unchanged like previous versions.
[oracle@ram admin]$ rman target=sys/pdb5 Recovery Manager: Release 12.2.0.1.0 - Production on Tue Oct 9 18:21:25 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: DBWR (DBID=1322876759)
RMAN> BACKUP TABLESPACE system, sysaux, users; Starting backup at 09-OCT-18 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=00001 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_system_fvgqv1n6_.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvgqxhq9_.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvgqyy96_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T182505_fvs999th_.bkp tag=TAG20181009T182505 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:52 Finished backup at 09-OCT-18 Starting Control File and SPFILE Autobackup at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/autobackup/2018_10_09/o1_mf_s_989087157_fvs9bxpr_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 09-OCT-18
Either way is we can connect to the CDB and take directly backup of the particular PDB.
[oracle@ram admin]$ rman target=sys/dbwr Recovery Manager: Release 12.2.0.1.0 - Production on Tue Oct 9 18:28:37 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: DBWR (DBID=1322876759)
RMAN> backup tablespace pdb5:system,pdb5:sysaux,pdb5:users,pdb6:system; Starting backup at 09-OCT-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=83 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=00022 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvhgn44v_.dbf input datafile file number=00021 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_system_fvhgn44z_.dbf input datafile file number=00024 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvhgn454_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/77813D4B379738F5E0536501A8C05864/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T183030_fvs9mgjy_.bkp tag=TAG20181009T183030 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:30 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/DBWR/777D95E41A572D82E053DD971D40E224/datafile/o1_mf_system_fvgzcl9q_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/777D95E41A572D82E053DD971D40E224/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T183030_fvs9nf4n_.bkp tag=TAG20181009T183030 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15 Finished backup at 09-OCT-18 Starting Control File and SPFILE Autobackup at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/autobackup/2018_10_09/o1_mf_s_989087476_fvs9nwwy_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 09-OCT-18
Datafiles have unique file numbers and fully qualified names, so they can be backed up from the root container or the individual PDB.
[oracle@ram admin]$ rman target =sys/pdb5 Recovery Manager: Release 12.2.0.1.0 - Production on Tue Oct 9 18:36:26 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: DBWR (DBID=1322876759)
Datafiles have unique file numbers so they can be backed up from the root container or the individual PDB.
RMAN> backup datafile 5,6,7; Starting backup at 09-OCT-18 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=00006 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_sysaux_fvgr1m08_.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_system_fvgr1m0c_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/777BDA91F244116BE053DD971D400082/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T183709_fvs9zy5o_.bkp tag=TAG20181009T183709 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:28 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00007 name=/u01/app/oracle/oradata/DBWR/datafile/o1_mf_users_fvgqyy96_.dbf channel ORA_DISK_1: starting piece 1 at 09-OCT-18 channel ORA_DISK_1: finished piece 1 at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/backupset/2018_10_09/o1_mf_nnndf_TAG20181009T183709_fvsb0to6_.bkp tag=TAG20181009T183709 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 09-OCT-18 Starting Control File and SPFILE Autobackup at 09-OCT-18 piece handle=/u01/app/oracle/fast_recovery_area/dbwr/DBWR/autobackup/2018_10_09/o1_mf_s_989087859_fvsb0w26_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 09-OCT-18
If you are connecting to a PDB, only the files belonging to that PDB can be backed up.
So when connected as PDB5, we get an error if we try to backup the SYSAUX datafile from the root container.
RMAN> backup datafile 2; Starting backup at 09-OCT-18 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 10/09/2018 18:42:39 RMAN-20201: datafile not found in the recovery catalog RMAN-06010: error while looking up datafile: 2
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba