Location of RMAN backup

oracleoracle-12crman

I have two servers. One is DB server another is RMAN Catalog DB server. From my RMAN Catalog, I connect to my remote DB server and I run the backup. Where will the backup files be stored? Will it be in my RMAN catalog db server or the source db?

Best Answer

The backup operation will run on the database server, and the backup pieces may be created on the database server, attached storage disk, a backup server through a 3rd party library (Networker, TSM, etc.), or any other server through network shares (NFS, samba), depending on your configuration.

Related Solutions

How to change default backup location for oracle11g using RMAN

Some things which might help:

Don't backup into a single file.

allocate CHANNEL d1 DEVICE TYPE disk maxpiecesize 32768M format some_backup_path

Use as many channels as you can stand.

allocate CHANNEL d2 DEVICE TYPE disk maxpiecesize 32768M format some_backup_path

allocate CHANNEL d3 DEVICE TYPE disk maxpiecesize 32768M format some_backup_path

allocate CHANNEL d4 DEVICE TYPE disk maxpiecesize 32768M format some_backup_path

RMAN parallelizes based on the number of channels you allocate; each channel takes part of the work to do.

Have faster disks - both on the system being backed up AND on the system to which backups are being written. Are you backing up the database over the network? If so, you're limited by the transmission speed of the network and competing network traffic - probably database-related activity.

How to have RMAN treat the restored data files like they are originals

Issue switch to copy, then crosscheck.

Best Answer

Related Solutions

How to change default backup location for oracle11g using RMAN

How to have RMAN treat the restored data files like they are originals

Related Question