Hello,
I am trying to save the backups on a software, running on windows, that creates a winfsp mount point that has case sensitive paths.
When running my RMAN backup script, it converts my disk backup locations to uppercase, which causes an error "O/S-Error: (OS 3) The system cannot find the path specified." because the mount point returns a Path Not Found error code.
Is it possible to disable this uppercase feature?
My script (backup.rman):
run {
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = "C:\Users\user\Vawlt\folder\ORACLE_BACKUP\ora_df_%d_%c_%D%M%Y_%t_s%s_s%p";
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "C:\Users\user\Vawlt\folder\ORACLE_BACKUP\ora_cf_%F";
CONFIGURE BACKUP OPTIMIZATION ON;
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
CROSSCHECK BACKUP;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
}
Thanks in advance.
Edit:
**********************************
************* .bat file: *************
**********************************
set oracle_sid=orcl
rman target / cmdfile='C:\Users\OracleUser\Documents\orcl_backup\backup.rman' log='C:\Users\OracleUser\Documents\orcl_backup\backup.log'
**********************************
*********** Backup Log: ***********
**********************************
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Aug 19 18:26:46 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1608699119)
RMAN> run {
2> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
3> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = "C:\Users\user\Vawlt\folder\ORACLE_BACKUP\ora_df_%d_%c_%D%M%Y_%t_s%s_s%p";
4> CONFIGURE CONTROLFILE AUTOBACKUP ON;
5> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "C:\Users\user\Vawlt\folder\ORACLE_BACKUP\ora_cf_%F";
6> CONFIGURE BACKUP OPTIMIZATION ON;
7>
8> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
9>
10> CROSSCHECK BACKUP;
11> DELETE NOPROMPT EXPIRED BACKUP;
12> DELETE NOPROMPT OBSOLETE;
13> CROSSCHECK ARCHIVELOG ALL;
14> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
15>
16> }
17>
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT "C:\Users\user\Downloads\ORACLE_BACKUP\ora_df_%d_%c_%D%M%Y_%t_s%s_s%p";
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT "C:\Users\user\Vawlt\folder\ORACLE_BACKUP\ora_df_%d_%c_%D%M%Y_%t_s%s_s%p";
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "C:\Users\user\Downloads\ORACLE_BACKUP\ora_cf_%F";
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "C:\Users\user\Vawlt\folder\ORACLE_BACKUP\ora_cf_%F";
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
Starting backup at 19-AUG-21
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=138 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=257 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=41 RECID=44 STAMP=1081016808
channel ORA_DISK_1: starting piece 1 at 19-AUG-21
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/19/2021 18:26:49
ORA-19504: failed to create file "C:\USERS\USER\VAWLT\FOLDER\ORACLE_BACKUP\ORA_DF_ORCL_1_19082021_1081016808_S140_S1"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
channel ORA_DISK_1 disabled, job failed on it will be run on another channel
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=41 RECID=44 STAMP=1081016808
channel ORA_DISK_2: starting piece 1 at 19-AUG-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 08/19/2021 18:26:50
ORA-19504: failed to create file "C:\USERS\USER\VAWLT\FOLDER\ORACLE_BACKUP\ORA_DF_ORCL_1_19082021_1081016809_S141_S1"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
Recovery Manager complete.