Backup as copy database to an other server with RMAN (Oracle 19c)

This tutorial explains how to make a full backup of an Oracle database (Oracle 19c in this example) to an other server with RMAN, so if you have a storage saturation or need to make a copy of Oracle database, may this can help you.

  • Production Server:
    • Hostname: wadodb1
    • Connection name: wadodb
    • db_unique_name: wadodb
  • Standby Server:
    • Hostname: wadodb2
    • Connection name: wadodbsb
    • db_unique_name: wadodbsb

Step 1: Connect to the primary as primary connection and to the second one as auxiliary connection, and make a full as copy Backup.

Note: You need just an instance with NOMOUNT State in the second server.

$ rman target sys/PASSWORD@wadodb auxiliary sys/PASSWORD@wadodbsb
Recovery Manager: Release 19.0.0.0.0 - Production on Fri May 19 07:30:44 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: WADODB (DBID=1714169206)
connected to auxiliary database: WADODB (not mounted)

Step 2: Make a full backup to the secondary server

RMAN> backup as copy database auxiliary format '/home/oracle/backup_SB/Full_%U';
Starting backup at 19-MAY-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=436 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/data/wadodb/system01.dbf
output file name=/home/oracle/backup_SB/Full_data_D-WADODB_I-1714169206_TS-SYSTEM_FNO-1_901sha5e tag=TAG20230519T073054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/data/wadodb/undotbs01.dbf
output file name=/home/oracle/backup_SB/Full_data_D-WADODB_I-1714169206_TS-UNDOTBS1_FNO-4_911sha5l tag=TAG20230519T073054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/data/wadodb/sysaux01.dbf
output file name=/home/oracle/backup_SB/Full_data_D-WADODB_I-1714169206_TS-SYSAUX_FNO-3_921sha5t tag=TAG20230519T073054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/data/wadodb/asyw_tbs01.dbf
output file name=/home/oracle/backup_SB/Full_data_D-WADODB_I-1714169206_TS-ASYW_TBS_FNO-2_931sha60 tag=TAG20230519T073054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/data/wadodb/users02.dbf
output file name=/home/oracle/backup_SB/Full_data_D-WADODB_I-1714169206_TS-USERS_FNO-5_941sha61 tag=TAG20230519T073054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/data/wadodb/WADODB/datafile/o1_mf_wado_tbs_l5skfdoz_.dbf
output file name=/home/oracle/backup_SB/Full_data_D-WADODB_I-1714169206_TS-WADO_TBS_FNO-8_951sha62 tag=TAG20230519T073054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=/data/wadodb/WADODB/datafile/o1_mf_wado_tbs_l5sldkgh_.dbf
output file name=/home/oracle/backup_SB/Full_data_D-WADODB_I-1714169206_TS-WADO_TBS_FNO-9_961sha64 tag=TAG20230519T073054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/data/wadodb/users01.dbf
output file name=/home/oracle/backup_SB/Full_data_D-WADODB_I-1714169206_TS-USERS_FNO-7_971sha65 tag=TAG20230519T073054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 19-MAY-23
RMAN>

Enjoy!

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply