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