How RMAN Set Backup Location

  • by

By default, all backup pieces of RMAN go to Fast Recovery Area (FRA), but we can change it. In RMAN, we can set different backup location for fitting different backup strategies in different conditions.

In this post, we will see 3 different ways to set backup location.

  1. Global Backup Location
  2. Run Block Backup Location
  3. Single Command Backup Location

A. Global Backup Location

For using the backup location globally, we can configure the backup location on the default channel of disk type.

First of all, let's make sure the default device type is disk.

RMAN> show default device type;

RMAN configuration parameters for database with db_unique_name ORCLCDB are:
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

Next, we configure and format destination on channels of disk, this makes all generated channels of disk go to the destination.

RMAN> configure channel device type disk format '/backup1/ORCLCDB/%U';

using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup1/ORCLCDB/%U';
new RMAN configuration parameters are successfully stored

Also, we can optionally set the degree of parallelism to 4 in order to speed up the backup at all-time.

Make sure all settings are correctly configured.

RMAN> show channel;

RMAN configuration parameters for database with db_unique_name ORCLCDB are:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup1/ORCLCDB/%U';

RMAN> show device type;

RMAN configuration parameters for database with db_unique_name ORCLCDB are:
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;

If you got confused about the values you set, you can always go back to the default values of RMAN configuration and start it over.

Perform a full backup.

RMAN> backup database plus archivelog;


Starting backup at 05-JAN-21
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=592 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1154 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1721 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=3 STAMP=1059269445
input archived log thread=1 sequence=4 RECID=4 STAMP=1059270134
channel ORA_DISK_1: starting piece 1 at 05-JAN-21
channel ORA_DISK_2: starting archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=1 STAMP=1045783185
input archived log thread=1 sequence=2 RECID=2 STAMP=1045793980
channel ORA_DISK_2: starting piece 1 at 05-JAN-21
channel ORA_DISK_3: starting archived log backup set
channel ORA_DISK_3: specifying archived log(s) in backup set
input archived log thread=1 sequence=5 RECID=5 STAMP=1061072629
channel ORA_DISK_3: starting piece 1 at 05-JAN-21
channel ORA_DISK_3: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/05vjtbnn_1_1 tag=TAG20210105T222351 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/03vjtbnn_1_1 tag=TAG20210105T222351 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_2: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/04vjtbnn_1_1 tag=TAG20210105T222351 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:35
Finished backup at 05-JAN-21

Starting backup at 05-JAN-21
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCLCDB/system01.dbf
channel ORA_DISK_1: starting piece 1 at 05-JAN-21
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCLCDB/sysaux01.dbf
channel ORA_DISK_2: starting piece 1 at 05-JAN-21
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/sysaux01.dbf
channel ORA_DISK_3: starting piece 1 at 05-JAN-21
channel ORA_DISK_4: starting full datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/sysaux01.dbf
channel ORA_DISK_4: starting piece 1 at 05-JAN-21
channel ORA_DISK_2: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/07vjtbos_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:26
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/system01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf
channel ORA_DISK_2: starting piece 1 at 05-JAN-21
channel ORA_DISK_3: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/08vjtbos_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:27
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00013 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/example01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/undotbs01.dbf
channel ORA_DISK_3: starting piece 1 at 05-JAN-21
channel ORA_DISK_4: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/09vjtbos_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:27
channel ORA_DISK_4: starting full datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/system01.dbf
channel ORA_DISK_4: starting piece 1 at 05-JAN-21
channel ORA_DISK_1: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/06vjtbos_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:32
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCLCDB/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 05-JAN-21
channel ORA_DISK_2: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/0avjtbpn_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:13
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00008 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/undotbs01.dbf
channel ORA_DISK_2: starting piece 1 at 05-JAN-21
channel ORA_DISK_3: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/0bvjtbpo_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:12
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCLCDB/users01.dbf
channel ORA_DISK_3: starting piece 1 at 05-JAN-21
channel ORA_DISK_4: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/0cvjtbpp_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:12
channel ORA_DISK_1: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/0dvjtbpt_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_2: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/0evjtbq4_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_3: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/0fvjtbq5_1_1 tag=TAG20210105T222428 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01
Finished backup at 05-JAN-21

Starting backup at 05-JAN-21
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=6 STAMP=1061072711
channel ORA_DISK_1: starting piece 1 at 05-JAN-21
channel ORA_DISK_1: finished piece 1 at 05-JAN-21
piece handle=/backup1/ORCLCDB/0gvjtbq7_1_1 tag=TAG20210105T222511 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 05-JAN-21

Starting Control File and SPFILE Autobackup at 05-JAN-21
piece handle=/u01/app/oracle/fast_recovery_area/ORCLCDB/autobackup/2021_01_05/o1_mf_s_1061072712_hzbcdryz_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 05-JAN-21

As we can see, all output files are in the destination we configured.

B. Run Block Backup Location

We also can set the backup location for entire run block.

RMAN> run {
        allocate channel c1 type disk format '/backup1/ORCLCDB/%U';
        allocate channel c2 type disk format '/backup1/ORCLCDB/%U';
        allocate channel c3 type disk format '/backup1/ORCLCDB/%U';
        allocate channel c4 type disk format '/backup1/ORCLCDB/%U';
        backup database plus archivelog;
}
2> 3> 4> 5> 6> 7>
allocated channel: c1
channel c1: SID=585 device type=DISK

allocated channel: c2
channel c2: SID=1158 device type=DISK

allocated channel: c3
channel c3: SID=1729 device type=DISK

allocated channel: c4
channel c4: SID=24 device type=DISK


Starting backup at 06-JAN-21
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=3 STAMP=1059269445
input archived log thread=1 sequence=4 RECID=4 STAMP=1059270134
channel c1: starting piece 1 at 06-JAN-21
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=1 STAMP=1045783185
input archived log thread=1 sequence=2 RECID=2 STAMP=1045793980
channel c2: starting piece 1 at 06-JAN-21
channel c3: starting archived log backup set
channel c3: specifying archived log(s) in backup set
input archived log thread=1 sequence=5 RECID=5 STAMP=1061079104
channel c3: starting piece 1 at 06-JAN-21
channel c3: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/05vjti21_1_1 tag=TAG20210106T001144 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:15
channel c1: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/03vjti21_1_1 tag=TAG20210106T001144 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:35
channel c2: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/04vjti21_1_1 tag=TAG20210106T001144 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:35
Finished backup at 06-JAN-21

Starting backup at 06-JAN-21
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCLCDB/system01.dbf
channel c1: starting piece 1 at 06-JAN-21
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCLCDB/sysaux01.dbf
channel c2: starting piece 1 at 06-JAN-21
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/sysaux01.dbf
channel c3: starting piece 1 at 06-JAN-21
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/sysaux01.dbf
channel c4: starting piece 1 at 06-JAN-21
channel c3: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/08vjti36_1_1 tag=TAG20210106T001221 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:16
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/system01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf
channel c3: starting piece 1 at 06-JAN-21
channel c4: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/09vjti37_1_1 tag=TAG20210106T001221 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:24
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00013 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/example01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/undotbs01.dbf
channel c4: starting piece 1 at 06-JAN-21
channel c2: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/07vjti36_1_1 tag=TAG20210106T001221 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:26
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/system01.dbf
channel c2: starting piece 1 at 06-JAN-21
channel c3: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0avjti3n_1_1 tag=TAG20210106T001221 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:17
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCLCDB/undotbs01.dbf
channel c3: starting piece 1 at 06-JAN-21
channel c1: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/06vjti35_1_1 tag=TAG20210106T001221 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:43
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00008 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/undotbs01.dbf
channel c1: starting piece 1 at 06-JAN-21
channel c2: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0cvjti41_1_1 tag=TAG20210106T001221 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:15
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCLCDB/users01.dbf
channel c2: starting piece 1 at 06-JAN-21
channel c3: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0dvjti49_1_1 tag=TAG20210106T001221 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:08
channel c4: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0bvjti3v_1_1 tag=TAG20210106T001221 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:17
channel c1: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0evjti4g_1_1 tag=TAG20210106T001221 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c2: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0fvjti4h_1_1 tag=TAG20210106T001221 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:01
Finished backup at 06-JAN-21

Starting backup at 06-JAN-21
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=6 STAMP=1061079186
channel c1: starting piece 1 at 06-JAN-21
channel c1: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0gvjti4j_1_1 tag=TAG20210106T001307 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 06-JAN-21

Starting Control File and SPFILE Autobackup at 06-JAN-21
piece handle=/u01/app/oracle/fast_recovery_area/ORCLCDB/autobackup/2021_01_06/o1_mf_s_1061079188_hzbkq4ld_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 06-JAN-21
released channel: c1
released channel: c2
released channel: c3
released channel: c4

As you can see, we allocated 4 channel for parallel backups to the same destination in the run block. Of course, you can also set different destinations to spread backup pieces across several disks.

Please note that, the destination we specified only affects in the run block. Once we're out of the run block, the settings are gone. All values go back to the global settings.

C. Single Command Backup Location

We can set customized and different locations for each backup type. For example, the backup of database goes to /backup1 and the backup of archived logs goes to /backup2.

RMAN> run {
        allocate channel c1 type disk;
        allocate channel c2 type disk;
        allocate channel c3 type disk;
        allocate channel c4 type disk;
        backup database format '/backup1/ORCLCDB/%U' plus archivelog format '/backup2/ORCLCDB/%U';
}
2> 3> 4> 5> 6> 7>
allocated channel: c1
channel c1: SID=586 device type=DISK

allocated channel: c2
channel c2: SID=1158 device type=DISK

allocated channel: c3
channel c3: SID=1727 device type=DISK

allocated channel: c4
channel c4: SID=24 device type=DISK


Starting backup at 06-JAN-21
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=3 STAMP=1059269445
input archived log thread=1 sequence=4 RECID=4 STAMP=1059270134
channel c1: starting piece 1 at 06-JAN-21
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=1 STAMP=1045783185
input archived log thread=1 sequence=2 RECID=2 STAMP=1045793980
channel c2: starting piece 1 at 06-JAN-21
channel c3: starting archived log backup set
channel c3: specifying archived log(s) in backup set
input archived log thread=1 sequence=5 RECID=5 STAMP=1061081946
channel c3: starting piece 1 at 06-JAN-21
channel c3: finished piece 1 at 06-JAN-21
piece handle=/backup2/ORCLCDB/05vjtkqr_1_1 tag=TAG20210106T005907 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:15
channel c2: finished piece 1 at 06-JAN-21
piece handle=/backup2/ORCLCDB/04vjtkqr_1_1 tag=TAG20210106T005907 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:36
channel c1: finished piece 1 at 06-JAN-21
piece handle=/backup2/ORCLCDB/03vjtkqr_1_1 tag=TAG20210106T005907 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:46
Finished backup at 06-JAN-21

Starting backup at 06-JAN-21
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCLCDB/system01.dbf
channel c1: starting piece 1 at 06-JAN-21
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCLCDB/sysaux01.dbf
channel c2: starting piece 1 at 06-JAN-21
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/sysaux01.dbf
channel c3: starting piece 1 at 06-JAN-21
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/sysaux01.dbf
channel c4: starting piece 1 at 06-JAN-21
channel c2: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/07vjtksa_1_1 tag=TAG20210106T005954 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:26
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/system01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf
channel c2: starting piece 1 at 06-JAN-21
channel c3: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/08vjtksb_1_1 tag=TAG20210106T005954 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:26
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00013 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/example01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/undotbs01.dbf
channel c3: starting piece 1 at 06-JAN-21
channel c4: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/09vjtksb_1_1 tag=TAG20210106T005954 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:27
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/system01.dbf
channel c4: starting piece 1 at 06-JAN-21
channel c1: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/06vjtksa_1_1 tag=TAG20210106T005954 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:44
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCLCDB/undotbs01.dbf
channel c1: starting piece 1 at 06-JAN-21
channel c2: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0avjtkt5_1_1 tag=TAG20210106T005954 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:17
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00008 name=/u01/app/oracle/oradata/ORCLCDB/pdbseed/undotbs01.dbf
channel c2: starting piece 1 at 06-JAN-21
channel c3: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0bvjtkt6_1_1 tag=TAG20210106T005954 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:17
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCLCDB/users01.dbf
channel c3: starting piece 1 at 06-JAN-21
channel c4: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0cvjtkt7_1_1 tag=TAG20210106T005954 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:16
channel c1: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0dvjtktm_1_1 tag=TAG20210106T005954 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:04
channel c2: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0evjtktn_1_1 tag=TAG20210106T005954 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:03
channel c3: finished piece 1 at 06-JAN-21
piece handle=/backup1/ORCLCDB/0fvjtktn_1_1 tag=TAG20210106T005954 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:03
Finished backup at 06-JAN-21

Starting backup at 06-JAN-21
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=6 STAMP=1061082042
channel c1: starting piece 1 at 06-JAN-21
channel c1: finished piece 1 at 06-JAN-21
piece handle=/backup2/ORCLCDB/0gvjtktr_1_1 tag=TAG20210106T010043 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 06-JAN-21

Starting Control File and SPFILE Autobackup at 06-JAN-21
piece handle=/u01/app/oracle/fast_recovery_area/ORCLCDB/autobackup/2021_01_06/o1_mf_s_1061082044_hzbnjdo6_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 06-JAN-21
released channel: c1
released channel: c2
released channel: c3
released channel: c4

As you can see, I allocated 4 channels for backing up database and archived logs, they go to different disk drives.

In summary, we introduced 3 different ways to set backup locations in this post, which may fit into different scenarios. The more ways we know, the more flexible backup strategies we can design.

Leave a Reply

Your email address will not be published. Required fields are marked *