Creating backup using recovery catalog

  • Jagruti Jasleniya

In the previous article, we have created a recovery catalogue database and registered database.

Creation of Recovery Catalog and Registering Database

In this article, we will take incremental backup using a recovery catalog.

Step 1: Connect rman with target and catalog clause

Target: Database for which you want to create a backup

Catalog: Catalog database which will store your backup information

[oracle@localhost ~]$ rman target sys/oracle@demo catalog rcatown/rcat@rpdb1

Recovery Manager: Release 12.2.0.1.0 - Production on Thu Jan 3 11:47:58 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DEMO (DBID=3740643610)
connected to recovery catalog database

RMAN>

Step 2: Take an incremental level 0 backup

RMAN> backup incremental level 0 database;

Starting backup at 03-JAN-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=74 device type=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/oradata/DEMO/datafile/o1_mf_system_g2v3h4nx_.dbf
input datafile file number=00003 name=/u02/oradata/DEMO/datafile/o1_mf_sysaux_g2v3kjm5_.dbf
input datafile file number=00004 name=/u02/oradata/DEMO/datafile/o1_mf_undotbs1_g2v3lxr9_.dbf
input datafile file number=00007 name=/u02/oradata/DEMO/datafile/o1_mf_users_g2v3lywc_.dbf
channel ORA_DISK_1: starting piece 1 at 03-JAN-19
channel ORA_DISK_1: finished piece 1 at 03-JAN-19
piece handle=/u02/fast_recovery_area/demo/DEMO/backupset/2019_01_03/o1_mf_nnnd0_TAG20190103T114906_g2vbbvlk_.bkp tag=TAG20190103T114906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:16
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_sysaux_g2v4j0p1_.dbf
input datafile file number=00009 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_system_g2v4j0j1_.dbf
input datafile file number=00011 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_undotbs1_g2v4j0p2_.dbf
input datafile file number=00013 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_tbs_rcat_g2v5zj00_.dbf
input datafile file number=00012 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_users_g2v4mrlj_.dbf
channel ORA_DISK_1: starting piece 1 at 03-JAN-19
channel ORA_DISK_1: finished piece 1 at 03-JAN-19
piece handle=/u02/fast_recovery_area/demo/DEMO/7E8758AC5ED126B4E055000000000001/backupset/2019_01_03/o1_mf_nnnd0_TAG20190103T114906_g2vbf7v2_.bkp tag=TAG20190103T114906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u02/oradata/DEMO/datafile/o1_mf_sysaux_g2v3ot3q_.dbf
input datafile file number=00005 name=/u02/oradata/DEMO/datafile/o1_mf_system_g2v3ot3x_.dbf
input datafile file number=00008 name=/u02/oradata/DEMO/datafile/o1_mf_undotbs1_g2v3ot45_.dbf
channel ORA_DISK_1: starting piece 1 at 03-JAN-19
channel ORA_DISK_1: finished piece 1 at 03-JAN-19
piece handle=/u02/fast_recovery_area/demo/DEMO/7E872A11804F1BADE055000000000001/backupset/2019_01_03/o1_mf_nnnd0_TAG20190103T114906_g2vbgofw_.bkp tag=TAG20190103T114906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 03-JAN-19

Starting Control File and SPFILE Autobackup at 03-JAN-19
piece handle=/u02/fast_recovery_area/demo/DEMO/autobackup/2019_01_03/o1_mf_s_996580307_g2vbhzdx_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 03-JAN-19

RMAN>

Step 3: Take an incremental level 1 backup

RMAN> backup incremental level 1 database;

Starting backup at 03-JAN-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/oradata/DEMO/datafile/o1_mf_system_g2v3h4nx_.dbf
input datafile file number=00003 name=/u02/oradata/DEMO/datafile/o1_mf_sysaux_g2v3kjm5_.dbf
input datafile file number=00004 name=/u02/oradata/DEMO/datafile/o1_mf_undotbs1_g2v3lxr9_.dbf
input datafile file number=00007 name=/u02/oradata/DEMO/datafile/o1_mf_users_g2v3lywc_.dbf
channel ORA_DISK_1: starting piece 1 at 03-JAN-19
channel ORA_DISK_1: finished piece 1 at 03-JAN-19
piece handle=/u02/fast_recovery_area/demo/DEMO/backupset/2019_01_03/o1_mf_nnnd1_TAG20190103T115402_g2vbn4nq_.bkp tag=TAG20190103T115402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_sysaux_g2v4j0p1_.dbf
input datafile file number=00009 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_system_g2v4j0j1_.dbf
input datafile file number=00011 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_undotbs1_g2v4j0p2_.dbf
input datafile file number=00013 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_tbs_rcat_g2v5zj00_.dbf
input datafile file number=00012 name=/u02/oradata/DEMO/7E8758AC5ED126B4E055000000000001/datafile/o1_mf_users_g2v4mrlj_.dbf
channel ORA_DISK_1: starting piece 1 at 03-JAN-19
channel ORA_DISK_1: finished piece 1 at 03-JAN-19
piece handle=/u02/fast_recovery_area/demo/DEMO/7E8758AC5ED126B4E055000000000001/backupset/2019_01_03/o1_mf_nnnd1_TAG20190103T115402_g2vbo9l7_.bkp tag=TAG20190103T115402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u02/oradata/DEMO/datafile/o1_mf_sysaux_g2v3ot3q_.dbf
skipping datafile 00006 because it has not changed
input datafile file number=00005 name=/u02/oradata/DEMO/datafile/o1_mf_system_g2v3ot3x_.dbf
skipping datafile 00005 because it has not changed
input datafile file number=00008 name=/u02/oradata/DEMO/datafile/o1_mf_undotbs1_g2v3ot45_.dbf
skipping datafile 00008 because it has not changed
channel ORA_DISK_1: backup cancelled because all files were skipped
Finished backup at 03-JAN-19

Starting Control File and SPFILE Autobackup at 03-JAN-19
piece handle=/u02/fast_recovery_area/demo/DEMO/autobackup/2019_01_03/o1_mf_s_996580521_g2vbpkg7_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 03-JAN-19

RMAN>

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

I am 11g OCP and OCE(RAC and GRID Infrastructure). Currently working as Oracle Database Administrator at _VOIS and Blogger (Freelancer) at Oracle-help . Previously I worked with Acute Informatics pvt ltd. and Mobile Tornado where I handled Banking Data Migration , created DR using log shipping , Golden Gate and Data Guard. I have experience of handling planned and unplanned DB role switchover and failovers and monitoring and troubleshooting Database Performance. Key skills : RMAN , GG , DG , RAC , Virtualization in OVMM.I have experience in Banking and Telecom domain. Reach me at : https://www.linkedin.com/in/jagruti-jasleniya

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.