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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)