[Oracle 12c] BACKUP DATABASE ROOT

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

 

 

Related posts

Leave a Comment