RMAN Backups - Can more than one media management software solution be used?

Database Administrators Asked by Franco on August 21, 2020

Does anyone know if it’s possible for two different backup utilities to be used to backup the same Oracle database? Both utilities would use RMAN.

So, for example, take an Oracle 11g standby DB with a daily online backup to tape via Netbackup (using the RMAN recovery catalog) and then also take another separate daily backup via TIVOLI (also using the RMAN catalog), could they co-exist in some way? Obviously it’s a not a sensible approach, this is just a question of what is or is not possible. Many thanks.

One Answer

Creating the symlink $ORACLE_HOME/lib/ pointing to the media management library is not a strict requirement. As part of RMAN channel allocation, the path of vendor speficic library can be specified in the SBT_LIBRARY parameter.

I never tried this, but just by allocating the SBT channels with different parameters should make this work.


For your other question about restoring backup pieces from different media:

RMAN has a feature called Autolocation. The RMAN SET AUTOLOCATE ON command is deprecated since 10.2 because this feature is enabled by default. RMAN only needs to track that for example the backup of datafile 1 is included in backuppiece vlv6su4u_1_1 with channel type SBT_TAPE. Using this information and the autolocation feature, RMAN is able to recognize which channel it should use from multiple channels allocated with different options, simply by querying all channels for this backuppiece. This feature was invented for handling backups taken on different RAC nodes, but I was able to use it in another scenario as well: for example after a TSM backup server was migrated (e.g full backup from old TSM server + file space, incremental and archivelog backups from new TSM server + file space, channels allocated with different tdpo.opt files pointing to old and new TSM servers).

The same may work with 2 different MMLs as well.

Answered by Balazs Papp on August 21, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP