RMAN-20045: must specify FORMAT for BACKUP INCREMENTAL FROM SCN command-continuing other job steps, job failed will not be re-run

Cause:

I was trying to take incremental scn backup using RMAN to ASM diskgroup. But ASM is not up and running.

RMAN> backup incremental from scn 15059215 database;

Starting backup at 24-JUN-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device type=DISK
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=+DATA/ORCL/DATAFILE/undotbs1.259.103150189              9
channel ORA_DISK_1: starting piece 1 at 24-JUN-21
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/24/2021 18:28:              16
RMAN-20045: must specify FORMAT for BACKUP INCREMENTAL FROM SCN command
continuing other job steps, job failed will not be re-run
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=+DATA/ORCL/DATAFILE/system.257.1031501823
channel ORA_DISK_1: starting piece 1 at 24-JUN-21
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/24/2021 18:28:              17
RMAN-20045: must specify FORMAT for BACKUP INCREMENTAL FROM SCN command
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/home/oracle/rcat.tbs
input datafile file number=00002 name=+DATA/ORCL/DATAFILE/system.265
input datafile file number=00006 name=+DATA/ORCL/users.new
input datafile file number=00007 name=+DATA/ORCL/DATAFILE/users.272.1040745563
input datafile file number=00008 name=+DATA/ORCL/DATAFILE/users.274.1040915137
channel ORA_DISK_1: starting piece 1 at 24-JUN-21
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/24/2021 18:28:              17
RMAN-20045: must specify FORMAT for BACKUP INCREMENTAL FROM SCN command
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/ORCL/DATAFILE/example.265.1031501993
channel ORA_DISK_1: starting piece 1 at 24-JUN-21
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/24/2021 18:28:              17
RMAN-20045: must specify FORMAT for BACKUP INCREMENTAL FROM SCN command
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ORCL/DATAFILE/sysaux.256.1031501729
channel ORA_DISK_1: starting piece 1 at 24-JUN-21
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/24/2021 18:28:              17
RMAN-20045: must specify FORMAT for BACKUP INCREMENTAL FROM SCN command
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 24-JUN-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/24/2021 18:28:              21
RMAN-20045: must specify FORMAT for BACKUP INCREMENTAL FROM SCN command

Workaround:

Use ‘format’ option to specify the directory which exist to take backup

RMAN> backup incremental from scn 15059215 database format '/u01/%f';

Starting backup at 24-JUN-21
using channel ORA_DISK_1
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=+DATA/ORCL/DATAFILE/undotbs1.259.1031501899
channel ORA_DISK_1: starting piece 1 at 25-JUN-21
channel ORA_DISK_1: finished piece 1 at 25-JUN-21
piece handle=/u01/4 tag=TAG20210625T000217 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
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=+DATA/ORCL/DATAFILE/system.257.1031501823
channel ORA_DISK_1: starting piece 1 at 25-JUN-21
channel ORA_DISK_1: finished piece 1 at 25-JUN-21
piece handle=/u01/1 tag=TAG20210625T000217 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/home/oracle/rcat.tbs
input datafile file number=00002 name=+DATA/ORCL/DATAFILE/system.265
input datafile file number=00006 name=+DATA/ORCL/users.new
input datafile file number=00007 name=+DATA/ORCL/DATAFILE/users.272.1040745563
input datafile file number=00008 name=+DATA/ORCL/DATAFILE/users.274.1040915137
channel ORA_DISK_1: starting piece 1 at 25-JUN-21
channel ORA_DISK_1: finished piece 1 at 25-JUN-21
piece handle=/u01/8 tag=TAG20210625T000217 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/ORCL/DATAFILE/example.265.1031501993
channel ORA_DISK_1: starting piece 1 at 25-JUN-21
channel ORA_DISK_1: finished piece 1 at 25-JUN-21
piece handle=/u01/5 tag=TAG20210625T000217 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/ORCL/DATAFILE/sysaux.256.1031501729
channel ORA_DISK_1: starting piece 1 at 25-JUN-21
channel ORA_DISK_1: finished piece 1 at 25-JUN-21
piece handle=/u01/3 tag=TAG20210625T000217 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 25-JUN-21
channel ORA_DISK_1: finished piece 1 at 25-JUN-21
piece handle=/u01/0 tag=TAG20210625T000217 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 24-JUN-21

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s