• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Oracle Database: How to catalog tape backup pieces

by admin

Starting with 10g, it’s possible to use the RMAN CATALOG command to add backuppieces stored in the disk to the RMAN repository. You may need to catalog backup pieces in the following situations:

  • You copy or move a backup piece with an operating system utility and want it to be usable by RMAN.
  • The RMAN metadata for the backup piece was removed, but the backup piece still exists. This situation can occur if you ran the DELETE command on a backup piece that was only temporarily unavailable.
  • You make a NOCATALOG backup on one database host in a Data Guard environment and move the backup piece to the same location on a different database host. In this case, the recovery catalog has no record of the original backup piece.
  • You do not use a recovery catalog and must re-create the control file, thereby losing all RMAN repository data. Cataloging your backups makes them available again.
  • When control file autobackup is disabled, you back up the control file and then back up the archived redo logs. You can restore and mount the control file but must catalog the backup pieces containing the archived redo logs backed up after the control file.

But it’s not possible to use the CATALOG command for backup pieces stored in TAPE. This post explains how to add backuppieces stored in disk to the repository. From 10.1, there is an undocumented command that allows to catalog tape backup pieces:

RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE '[handle]';

Prerequisites

1. Use automatic channel configuration. It’s mandatory to configure one sbt_tape device channel in your rman automatic configuration parameters:

RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS '[MM parameters]'

2. It’s necessary to know the backup piece file name in the tape and the backup piece file needs to be available and accessible.

Steps

Once there is a tape channel configured for accessing to the tape, the rman CATALOG command can be used to insert in RMAN catalog the tape backup piece:

RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE '[handle]';

Examples

This is an example using Oracle Secure Backup (OSB):

1. Define a tape channel in the RMAN automatic configuration:

RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE'
  PARMS 'SBT_LIBRARY=/usr/local/oracle/backup/lib/libobk.so,ENV=(OB_MEDIA_FAMILY=RMAN-DEFAULT)';

2. Check that channel configuration is correct

RMAN> show all;
....
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/usr/local/oracle/backup/lib/libobk.so,ENV=(OB_MEDIA_FAMILY=RMAN-DEFAULT)';
....

3. Catalog the backup piece:

RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE '0pivagf8_1_1';

– The following will catalog a backuppiece on netbackup:

RMAN>CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' 
  PARMS 'ENV=(NB_ORA_CLASS=oraclebkup, SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so)';
RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE 'lij1qaa3_1_1';

Filed Under: oracle, RMAN

Some more articles you might also be interested in …

  1. DNS and DHCP Setup Example for Oracle Grid Infrastructure GNS
  2. Oracle RAC instabilities due to firewall (netfilter/iptables) enabled on the cluster interconnect
  3. How to Clone PDB With Oracle Key Vault (OKV)
  4. How to determine which user is using what rollback segment?
  5. How to Termibate a Session on a Specific Instance of Oracle RAC
  6. How to Define PDB Listeners With Different Ports In a Oracle database Multitenant Setup
  7. Create Password file for database in ASM Diskgroup – Oracle 12c RAC only
  8. Auto Space Management for Flashback Logs in the Fast Recovery Area – Oracle 19c New Feature
  9. Script to verify the Oracle DataPump Data Dictionary Catalog
  10. How To Find Creation Time of Oracle Pluggable Database (PDB)

You May Also Like

Primary Sidebar

Recent Posts

  • qm Command Examples in Linux
  • qm wait Command Examples in Linux
  • qm start Command Examples in Linux
  • qm snapshot Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright