Backing up the Oracle database is always very important. In version 12c, there is a possibility of backing up the ROOT database that has important metadata for the CDB.
So, in this post I’ll be illustrating how to backup the ROOT database:
1. Connect to the RMAN catalog:
[oracle@dbdg backupset]$ rman Recovery Manager: Release 12.1.0.2.0 - Production on Fri May 4 12:58:55 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. RMAN> connect target / connected to target database: SEIS (DBID=2199653114) RMAN> connect catalog <user>/<password>@<string> connected to recovery catalog database
2- Execute the command BACKUP DATABASE ROOT:
RMAN> BACKUP DATABASE ROOT; Starting backup at 04-MAY-18 starting full resync of recovery catalog full resync complete allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=99 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/SEIS/datafile/o1_mf_system_ffjmm4fn_.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/SEIS/datafile/o1_mf_sysaux_fdt0m4xg_.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/SEIS/datafile/o1_mf_undotbs1_fdt0p0vy_.dbf input datafile file number=00011 name=/u01/app/oracle/oradata/SEIS/datafile/rcat01.dbf input datafile file number=00006 name=/u01/app/oracle/oradata/SEIS/datafile/o1_mf_users_fdt0ozmn_.dbf channel ORA_DISK_1: starting piece 1 at 04-MAY-18 channel ORA_DISK_1: finished piece 1 at 04-MAY-18 piece handle=/u01/app/oracle/fast_recovery_area/SEIS/backupset/2018_05_04/o1_mf_nnndf_TAG20180504T125951_fgs4d9lo_.bkp tag=TAG20180504T125951 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 Finished backup at 04-MAY-18 Starting Control File and SPFILE Autobackup at 04-MAY-18 piece handle=/u01/app/oracle/fast_recovery_area/SEIS/autobackup/2018_05_04/o1_mf_s_975243619_fgs4f3rm_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 04-MAY-18
Efetuar o backup do banco de dados Oracle é sempre muito importante. Na versao 12c, há a possibilidade de se efetuar o backup do banco de dados ROOT que possui possui metadados importantes para o CDB.
Sendo assim, neste post estarei exemplificando como se efetuar o backup do banco de dados ROOT:
1. Conecte no catálago do RMAN:
[oracle@dbdg backupset]$ rman Recovery Manager: Release 12.1.0.2.0 - Production on Fri May 4 12:58:55 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. RMAN> connect target / connected to target database: SEIS (DBID=2199653114) RMAN> connect catalog <user>/<password>@<string> connected to recovery catalog database
2- Execute o comando BACKUP DATABASE ROOT:
RMAN> BACKUP DATABASE ROOT; Starting backup at 04-MAY-18 starting full resync of recovery catalog full resync complete allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=99 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/SEIS/datafile/o1_mf_system_ffjmm4fn_.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/SEIS/datafile/o1_mf_sysaux_fdt0m4xg_.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/SEIS/datafile/o1_mf_undotbs1_fdt0p0vy_.dbf input datafile file number=00011 name=/u01/app/oracle/oradata/SEIS/datafile/rcat01.dbf input datafile file number=00006 name=/u01/app/oracle/oradata/SEIS/datafile/o1_mf_users_fdt0ozmn_.dbf channel ORA_DISK_1: starting piece 1 at 04-MAY-18 channel ORA_DISK_1: finished piece 1 at 04-MAY-18 piece handle=/u01/app/oracle/fast_recovery_area/SEIS/backupset/2018_05_04/o1_mf_nnndf_TAG20180504T125951_fgs4d9lo_.bkp tag=TAG20180504T125951 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 Finished backup at 04-MAY-18 Starting Control File and SPFILE Autobackup at 04-MAY-18 piece handle=/u01/app/oracle/fast_recovery_area/SEIS/autobackup/2018_05_04/o1_mf_s_975243619_fgs4f3rm_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 04-MAY-18
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.