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
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)