Copy database file directly across network using RMAN in 11g including Primary and Standby
Last updated on JANUARY 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
**** Checked for relevance on 27-NOV-2015 ****
By copying files directly across network, we can not just eliminate several steps, but also, reduce time by several factors due to reduced I/O calls:
- Take backup at Source (I/O call)
- Copy backup files across network to destination using OS commands, e.g. scp, ftp, etc. (I/O call and Network call)
- Catalog the backup files at destination
- Restore files at destination (I/O call)
Above method requires 3 I/O calls.
Copying files directly across network reduces to Single I/O & Network call to achieve same goal.
In 12c, this is a new native feature and much easier and efficient. Refer 12c Documentation :
For versions prior to 11g (e..g 10gR2), refer below Article:
Recovering the primary database's datafile using the physical standby, and vice versa (Doc ID 453153.1)
- TNS Entry for source (target) and destination (auxiliary)
- RMAN executable which is compatible with Source and Destination Oracle Home version. It can be from any 3rd Oracle Home remotely from source and destination.
- Only Image Backup format can be used.
- RMAN compression can not be used to utilize network efficiently.
- MULTI-SECTION can not be used as this is not applicable to Image Backup in 11g.
- Level 1 backup FROM SCN can not be taken from Primary directly over to Standby for rollforward, as this is a Backupset not a Image Backup.
- Copy datafile from Primary to Standby
- Copy datafile from Standby to Primary
- Copy datafile from any source to any destination, e.g. failed DUPLICATE auxiliary destination
- Copy controlfile from any source to any destination, e.g. from Primary to Physical Standby
- Copy archivelog from any source to any destination
- Copy spfile from any source to any destination
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms