Hi Experts,
I am currently running a backup that commences at 11pm each evening, Full on Sunday, Incrementally for Mon-Sat.
The FULL backup always crosses the midnight hour, the INCR occasionally does.
I have the following script that creates the backup:
RUN
{
configure controlfile autobackup on;
set command id to 'DATABASE_OnlineBackupFull';
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 DATABASE TAG DATABASE_FULL FORMAT '/data/fra/%d/backupset/%Y_%M_%D/%d_%T_%s_%p.FULL';
BACKUP TAG DATABASE_FULL_ARCHIVE format '/data/fra/%d/backupset/%Y_%M_%D/%d_%T_%s_%p_ARCHIVE' archivelog all delete all input;
BACKUP TAG DATABASE_FULL_CONTROL current controlfile format '/data/fra/%d/backupset/%Y_%M_%D/%d_%T_%s_%p_CONTROL';
RELEASE CHANNEL c1;
RELEASE CHANNEL c2;
RELEASE CHANNEL c3;
RELEASE CHANNEL c4;
}
I have /data/fra/%d with 'chmod 775' and sub-directories. Where %d is DATABASE.
With the backup crossing over the midnight hour, I receive the following messages:
RMAN-03009: failure of backup command on c1 channel at 03/15/2018 00:01:43
ORA-19504: failed to create file "/data/fra/DATABASE/backupset/2018_03_15/DATABASE_20180315_228_1_ARCHIVE"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
Additional information: 1
I create the 'today' directory, aka 2008_03_14, in the shell script, before calling the rman script above.
But I don't create the 'tomorrow' directory, aka 2018_03_15, in the shell script.
The calling script says:
/u01/app/oracle/product/11.2/db_1/bin/rman < rman_backup.full
This calls the RUN script above.
My questions are:
1. How do I get RMAN to create the 'next' day directory while it's performing the backup?
2. With the shell script creating the 'today' directory, does this cause RMAN concern?
Oracle Version: 11.2.0.4
Solaris Version: Solaris 11.3 SPARC
Thank you in advance
Craig.