{"id":9753,"date":"2017-02-06T14:26:49","date_gmt":"2017-02-06T13:26:49","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/"},"modified":"2017-02-06T14:26:49","modified_gmt":"2017-02-06T13:26:49","slug":"oracle-rman-backups-to-cifs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/","title":{"rendered":"Oracle – RMAN Backups to CIFS"},"content":{"rendered":"

By William Sescu<\/h2>\n

Not to often, but sometimes you need to offload your RMAN backups and your DataPump exports to CIFS. You might run out of space on your NFS server, or you are a Windows shop who has only CIFS shares, and then you might need to put your RMAN backups to CIFS.<\/p>\n

One very important MOS Note regarding RMAN backups to CIFS is the following<\/p>\n

Is use of CIFS Protocol for RMAN backups supported? (Doc ID 444809.1)<\/p>\n

Running a RDBMS on CIFS is clearly not supported because of CIFS does not guarantee atomic write of 512 byte blocks. On the other hand, RMAN is not relying on 512-byte atomic writes, and so it is fine to use RMAN to CIFS.<\/p>\n

However, CIFS is not certified by Oracle and the RDBMS development team can not be involved is case there are any issue. The MOS note was last updated on November 2013, so it might be not a bad idea to double check it with Oracle again.<\/p>\n

In earlier OS and DB version, there used to be issues with filesystemio_options SETALL,DIRECT or ASYNCH, and so I wanted to double check if this is still the case with more recent releases.<\/p>\n

I have done the tests with Oracle 11.2.0.4 and 12.1.0.2 on OEL 6.8 with Samba 3.6.<\/p>\n

[root@oel001 ~]# cat \/etc\/oracle-release\nOracle Linux Server release 6.8\n[root@oel001 ~]# uname -a\nLinux oel001 4.1.12-61.1.25.el6uek.x86_64 #2 SMP Wed Jan 11 19:13:03 PST 2017 x86_64 x86_64 x86_64 GNU\/Linux\n[root@oel001 ~]# rpm -qa | grep samba-3.6.23\nsamba-3.6.23-36.0.1.el6_8.x86_64<\/pre>\n
I start with filesystemio_options SETALL and RMAN and Datapump with 18 parallel sessions, to make sure that I hit the CIFS share quite hard. Before we start the Test, we have to mount the CIFS share. All mount options are documented at the following link.<\/p>\n
https:\/\/www.samba.org\/samba\/docs\/man\/manpages-3\/mount.cifs.8.html<\/a><\/p>\n
For my case, the most important CIFS mount options are:<\/p>\n
user = M$ User to connect to the CIFS share
\nrw = mount read write
\nuid = sets the uid that will own all files or directories on the mounted filesystem
\ngid = sets the gid that will own all files or directories on the mounted filesystem
\nrsize = default network read size
\nwsize = default network write size<\/p>\n
Regarding the rsize\/wsize I have used the ones, which I usually take when using NFS mounts.<\/p>\n
[root@oel001 ~]# mount -t cifs \/\/10.0.2.2\/rman \/rman -o rsize=32768,wsize=32768,rw,user=wrs,uid=oracle,gid=dba --verbose\nPassword:\nmount.cifs kernel mount options: ip=10.0.2.2,unc=\\10.0.2.2rman,rsize=32768,wsize=32768,uid=54321,gid=54322,ver=1,user=wrs,pass=***                          *****\n\n[root@oel001 ~]# mount | grep rman\n\/\/10.0.2.2\/rman on \/rman type cifs (rw)<\/pre>\n
Before running any RMAN backups to it, make sure that you can create files with the oracle user. If it is failing at this step already, then you can stop here. This has to work before continuing any further.<\/p>\n
oracle@oel001:\/home\/oracle\/ [OCM121] cd \/rman\/backup\/\noracle@oel001:\/rman\/backup\/ [OCM121] touch new_file\noracle@oel001:\/rman\/backup\/ [OCM121] ls -l new_file\n-rwxr-xr-x 1 oracle dba 0 Feb  6 09:22 new_file\noracle@oel001:\/rman\/backup\/ [OCM121] rm new_file<\/pre>\n
Ok. Let’s start with 11.2.0.4 first. The database has filesystemio_options=SETALL, meaning that the database uses aynch and directio at the same time.<\/p>\n
My RMAN backup tests will be a regular backup with 16 parallel sessions to that share, and a backup of the Fast Recovery Area to the same share as well.<\/p>\n
CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO COMPRESSED BACKUPSET;\nBACKUP DATABASE FORMAT '\/rman\/backup\/%U';\nBACKUP RECOVERY AREA TO DESTINATION '\/rman\/backup';<\/pre>\n
My DataPump test will be a full backup with 16 parallel sessions.<\/p>\n
expdp system\/manager directory=rman dumpfile=rman%U.dmp parallel=16 full=y<\/pre>\n
ok. Let’s start doing the first backup.<\/p>\n
oracle@oel001:\/home\/oracle\/ [OCM112] rman target \/\n\nRecovery Manager: Release 11.2.0.4.0 - Production on Mon Feb 6 13:31:37 2017\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: OCM112 (DBID=177109848)\n\nRMAN> backup database format '\/rman\/backup\/%U';\n\nStarting backup at 06-FEB-2017 13:31:45\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=128 device type=DISK\nallocated channel: ORA_DISK_2\nchannel ORA_DISK_2: SID=249 device type=DISK\nallocated channel: ORA_DISK_3\nchannel ORA_DISK_3: SID=366 device type=DISK\nallocated channel: ORA_DISK_4\nchannel ORA_DISK_4: SID=12 device type=DISK\nallocated channel: ORA_DISK_5\nchannel ORA_DISK_5: SID=129 device type=DISK\nallocated channel: ORA_DISK_6\nchannel ORA_DISK_6: SID=250 device type=DISK\nallocated channel: ORA_DISK_7\nchannel ORA_DISK_7: SID=360 device type=DISK\nallocated channel: ORA_DISK_8\nchannel ORA_DISK_8: SID=14 device type=DISK\nallocated channel: ORA_DISK_9\nchannel ORA_DISK_9: SID=130 device type=DISK\nallocated channel: ORA_DISK_10\nchannel ORA_DISK_10: SID=251 device type=DISK\nallocated channel: ORA_DISK_11\nchannel ORA_DISK_11: SID=367 device type=DISK\nallocated channel: ORA_DISK_12\nchannel ORA_DISK_12: SID=15 device type=DISK\nallocated channel: ORA_DISK_13\nchannel ORA_DISK_13: SID=131 device type=DISK\nallocated channel: ORA_DISK_14\nchannel ORA_DISK_14: SID=252 device type=DISK\nallocated channel: ORA_DISK_15\nchannel ORA_DISK_15: SID=368 device type=DISK\nallocated channel: ORA_DISK_16\nchannel ORA_DISK_16: SID=16 device type=DISK\nchannel ORA_DISK_1: starting compressed full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=+DATA11G\/ocm112\/datafile\/system.261.927382121\nchannel ORA_DISK_1: starting piece 1 at 06-FEB-2017 13:31:48\nchannel ORA_DISK_2: starting compressed full datafile backup set\nchannel ORA_DISK_2: specifying datafile(s) in backup set\ninput datafile file number=00003 name=+DATA11G\/ocm112\/datafile\/undotbs1.263.927382145\nchannel ORA_DISK_2: starting piece 1 at 06-FEB-2017 13:31:48\nchannel ORA_DISK_3: starting compressed full datafile backup set\nchannel ORA_DISK_3: specifying datafile(s) in backup set\ninput datafile file number=00002 name=+DATA11G\/ocm112\/datafile\/sysaux.262.927382135\nchannel ORA_DISK_3: starting piece 1 at 06-FEB-2017 13:31:48\nchannel ORA_DISK_4: starting compressed full datafile backup set\nchannel ORA_DISK_4: specifying datafile(s) in backup set\ninput datafile file number=00004 name=+DATA11G\/ocm112\/datafile\/example.265.927382167\nchannel ORA_DISK_4: starting piece 1 at 06-FEB-2017 13:31:48\nchannel ORA_DISK_5: starting compressed full datafile backup set\nchannel ORA_DISK_5: specifying datafile(s) in backup set\ninput datafile file number=00005 name=+DATA11G\/ocm112\/datafile\/users.266.927382177\nchannel ORA_DISK_5: starting piece 1 at 06-FEB-2017 13:31:48\nchannel ORA_DISK_5: finished piece 1 at 06-FEB-2017 13:32:03\npiece handle=\/rman\/backup\/0krrtai4_1_1 tag=TAG20170206T133147 comment=NONE\nchannel ORA_DISK_5: backup set complete, elapsed time: 00:00:15\nchannel ORA_DISK_3: finished piece 1 at 06-FEB-2017 13:32:13\npiece handle=\/rman\/backup\/0irrtai4_1_1 tag=TAG20170206T133147 comment=NONE\nchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:25\nchannel ORA_DISK_4: finished piece 1 at 06-FEB-2017 13:32:13\npiece handle=\/rman\/backup\/0jrrtai4_1_1 tag=TAG20170206T133147 comment=NONE\nchannel ORA_DISK_4: backup set complete, elapsed time: 00:00:25\nchannel ORA_DISK_1: finished piece 1 at 06-FEB-2017 13:32:23\npiece handle=\/rman\/backup\/0grrtai4_1_1 tag=TAG20170206T133147 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35\nchannel ORA_DISK_2: finished piece 1 at 06-FEB-2017 13:32:23\npiece handle=\/rman\/backup\/0hrrtai4_1_1 tag=TAG20170206T133147 comment=NONE\nchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:35\nFinished backup at 06-FEB-2017 13:32:23\n\nStarting Control File and SPFILE Autobackup at 06-FEB-2017 13:32:23\npiece handle=+FRA11G\/ocm112\/autobackup\/2017_02_06\/s_935242343.266.935242347 comment=NONE\nFinished Control File and SPFILE Autobackup at 06-FEB-2017 13:32:30\n\nRMAN><\/pre>\n
Cool .. it seems to work perfectly. Ok. Let’s do the backup of the FRA to CIFS as well.<\/p>\n
RMAN> BACKUP RECOVERY AREA TO DESTINATION '\/rman\/backup';\n\nStarting backup at 06-FEB-2017 14:48:35\nusing channel ORA_DISK_1\nusing channel ORA_DISK_2\nusing channel ORA_DISK_3\nusing channel ORA_DISK_4\nusing channel ORA_DISK_5\nusing channel ORA_DISK_6\nusing channel ORA_DISK_7\nusing channel ORA_DISK_8\nusing channel ORA_DISK_9\nusing channel ORA_DISK_10\nusing channel ORA_DISK_11\nusing channel ORA_DISK_12\nusing channel ORA_DISK_13\nusing channel ORA_DISK_14\nusing channel ORA_DISK_15\nusing channel ORA_DISK_16\nspecification does not match any datafile copy in the repository\nspecification does not match any backup set in the repository\nchannel ORA_DISK_1: starting compressed archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=77 RECID=3 STAMP=935241746\nchannel ORA_DISK_1: starting piece 1 at 06-FEB-2017 14:48:36\nchannel ORA_DISK_2: starting compressed archived log backup set\nchannel ORA_DISK_2: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=78 RECID=4 STAMP=935241790\nchannel ORA_DISK_2: starting piece 1 at 06-FEB-2017 14:48:36\nchannel ORA_DISK_3: starting compressed archived log backup set\nchannel ORA_DISK_3: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=79 RECID=5 STAMP=935242521\nchannel ORA_DISK_3: starting piece 1 at 06-FEB-2017 14:48:36\nchannel ORA_DISK_4: starting compressed archived log backup set\nchannel ORA_DISK_4: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=80 RECID=6 STAMP=935242549\nchannel ORA_DISK_4: starting piece 1 at 06-FEB-2017 14:48:37\nchannel ORA_DISK_5: starting compressed archived log backup set\nchannel ORA_DISK_5: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=81 RECID=7 STAMP=935242639\nchannel ORA_DISK_5: starting piece 1 at 06-FEB-2017 14:48:37\nchannel ORA_DISK_6: starting compressed archived log backup set\nchannel ORA_DISK_6: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=82 RECID=8 STAMP=935242724\nchannel ORA_DISK_6: starting piece 1 at 06-FEB-2017 14:48:38\nchannel ORA_DISK_1: finished piece 1 at 06-FEB-2017 14:48:38\npiece handle=\/rman\/backup\/OCM112\/backupset\/2017_02_06\/o1_mf_annnn_TAG20170206T144835_d9jzond8_.bkp tag=TAG20170206T144835 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02\nchannel ORA_DISK_2: finished piece 1 at 06-FEB-2017 14:48:39\npiece handle=\/rman\/backup\/OCM112\/backupset\/2017_02_06\/o1_mf_annnn_TAG20170206T144835_d9jzondy_.bkp tag=TAG20170206T144835 comment=NONE\nchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:03\nchannel ORA_DISK_3: finished piece 1 at 06-FEB-2017 14:48:39\npiece handle=\/rman\/backup\/OCM112\/backupset\/2017_02_06\/o1_mf_annnn_TAG20170206T144835_d9jzonqf_.bkp tag=TAG20170206T144835 comment=NONE\nchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:03\nchannel ORA_DISK_4: finished piece 1 at 06-FEB-2017 14:48:39\npiece handle=\/rman\/backup\/OCM112\/backupset\/2017_02_06\/o1_mf_annnn_TAG20170206T144835_d9jzoop8_.bkp tag=TAG20170206T144835 comment=NONE\nchannel ORA_DISK_4: backup set complete, elapsed time: 00:00:02\nchannel ORA_DISK_5: finished piece 1 at 06-FEB-2017 14:48:39\npiece handle=\/rman\/backup\/OCM112\/backupset\/2017_02_06\/o1_mf_annnn_TAG20170206T144835_d9jzooxq_.bkp tag=TAG20170206T144835 comment=NONE\nchannel ORA_DISK_5: backup set complete, elapsed time: 00:00:02\nchannel ORA_DISK_6: finished piece 1 at 06-FEB-2017 14:48:39\npiece handle=\/rman\/backup\/OCM112\/backupset\/2017_02_06\/o1_mf_annnn_TAG20170206T144835_d9jzopqx_.bkp tag=TAG20170206T144835 comment=NONE\nchannel ORA_DISK_6: backup set complete, elapsed time: 00:00:01\nFinished backup at 06-FEB-2017 14:48:39\n\nStarting Control File and SPFILE Autobackup at 06-FEB-2017 14:48:39\npiece handle=+FRA11G\/ocm112\/autobackup\/2017_02_06\/s_935246919.286.935246921 comment=NONE\nFinished Control File and SPFILE Autobackup at 06-FEB-2017 14:48:46\n\nRMAN><\/pre>\n
Worked very well as well. Now lets do the DataPump Test.<\/p>\n
SQL> connect system\/manager\nConnected.\n\nSQL> create directory rman as '\/rman\/backup';\n\nDirectory created.\n\noracle@oel001:\/home\/oracle\/ [OCM112] expdp system\/manager directory=rman dumpfile=rman%U.dmp parallel=16 full=y\n\nExport: Release 11.2.0.4.0 - Production on Mon Feb 6 13:33:41 2017\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,\nData Mining and Real Application Testing options\nStarting \"SYSTEM\".\"SYS_EXPORT_FULL_01\":  system\/******** directory=rman dumpfile=rman%U.dmp parallel=16 full=y\nEstimate in progress using BLOCKS method...\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE_DATA\nTotal estimation using BLOCKS method: 351.8 MB\n. . exported \"SH\".\"COSTS\":\"COSTS_Q1_1999\"                183.5 KB    5884 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q2_2000\"                119.0 KB    3715 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q1_2001\"                227.8 KB    7328 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q1_2000\"                120.6 KB    3772 rows\n. . exported \"SH\".\"CUSTOMERS\"                            9.853 MB   55500 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q3_1998\"                131.1 KB    4129 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q2_1998\"                79.52 KB    2397 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q2_1999\"                132.5 KB    4179 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q1_1998\"                139.5 KB    4411 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q3_2000\"                151.4 KB    4798 rows\n. . exported \"SH\".\"COSTS\":\"COSTS_Q3_2001\"                234.4 KB    7545 rows\n...\n...\n...\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PUBLIC_SYNONYM\/SYNONYM\nProcessing object type DATABASE_EXPORT\/SCHEMA\/SYNONYM\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TYPE\/INC_TYPE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TYPE\/TYPE_SPEC\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TYPE\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PRE_SYSTEM_ACTIONS\/PROCACT_SYSTEM\n. . exported \"ORDDATA\".\"ORDDCM_MAPPING_DOCS\"             7.890 KB       1 rows\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PROCOBJ\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/POST_SYSTEM_ACTIONS\/PROCACT_SYSTEM\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PROCACT_SCHEMA\nProcessing object type DATABASE_EXPORT\/SCHEMA\/XMLSCHEMA\/XMLSCHEMA\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/PRE_TABLE_ACTION\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/COMMENT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PACKAGE\/PACKAGE_SPEC\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PACKAGE\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/FUNCTION\/FUNCTION\nProcessing object type DATABASE_EXPORT\/SCHEMA\/FUNCTION\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PROCEDURE\/PROCEDURE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PROCEDURE\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PACKAGE\/COMPILE_PACKAGE\/PACKAGE_SPEC\/ALTER_PACKAGE_SPEC\nProcessing object type DATABASE_EXPORT\/SCHEMA\/FUNCTION\/ALTER_FUNCTION\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PROCEDURE\/ALTER_PROCEDURE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/INDEX\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/FUNCTIONAL_INDEX\/INDEX\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/CONSTRAINT\/CONSTRAINT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/STATISTICS\/FUNCTIONAL_INDEX\/INDEX_STATISTICS\nProcessing object type DATABASE_EXPORT\/SCHEMA\/VIEW\/VIEW\nProcessing object type DATABASE_EXPORT\/SCHEMA\/VIEW\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/VIEW\/COMMENT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PACKAGE_BODIES\/PACKAGE\/PACKAGE_BODY\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TYPE\/TYPE_BODY\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/CONSTRAINT\/REF_CONSTRAINT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/BITMAP_INDEX\/INDEX\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/STATISTICS\/BITMAP_INDEX\/INDEX_STATISTICS\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/STATISTICS\/TABLE_STATISTICS\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/DOMAIN_INDEX\/INDEX\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/POST_TABLE_ACTION\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TRIGGER\nProcessing object type DATABASE_EXPORT\/SCHEMA\/VIEW\/TRIGGER\nProcessing object type DATABASE_EXPORT\/SCHEMA\/EVENT\/TRIGGER\nProcessing object type DATABASE_EXPORT\/SCHEMA\/MATERIALIZED_VIEW\nProcessing object type DATABASE_EXPORT\/SCHEMA\/JOB\nProcessing object type DATABASE_EXPORT\/SCHEMA\/DIMENSION\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/POST_INSTANCE\/PROCACT_INSTANCE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/POST_INSTANCE\/PROCDEPOBJ\nProcessing object type DATABASE_EXPORT\/SCHEMA\/POST_SCHEMA\/PROCOBJ\nProcessing object type DATABASE_EXPORT\/SCHEMA\/POST_SCHEMA\/PROCACT_SCHEMA\nProcessing object type DATABASE_EXPORT\/AUDIT\nMaster table \"SYSTEM\".\"SYS_EXPORT_FULL_01\" successfully loaded\/unloaded\n******************************************************************************\nDump file set for SYSTEM.SYS_EXPORT_FULL_01 is:\n  \/rman\/backup\/rman01.dmp\n  \/rman\/backup\/rman02.dmp\n  \/rman\/backup\/rman03.dmp\n  \/rman\/backup\/rman04.dmp\n  \/rman\/backup\/rman05.dmp\n  \/rman\/backup\/rman06.dmp\n  \/rman\/backup\/rman07.dmp\n  \/rman\/backup\/rman08.dmp\n  \/rman\/backup\/rman09.dmp\n  \/rman\/backup\/rman10.dmp\n  \/rman\/backup\/rman11.dmp\n  \/rman\/backup\/rman12.dmp\n  \/rman\/backup\/rman13.dmp\n  \/rman\/backup\/rman14.dmp\n  \/rman\/backup\/rman15.dmp\n  \/rman\/backup\/rman16.dmp\n\nJob \"SYSTEM\".\"SYS_EXPORT_FULL_01\" completed at Mon Feb 6 13:37:32 2017 elapsed 0 00:03:44<\/pre>\n
 <\/p>\n
Cool. That also worked perfectly.<\/p>\n
I have repeated the same test with 12.1.0.2 also with no issues. In earlier releases I had issues with the filesystemio_options=SETALL, where I had to disable directio, and sometimes direct and aynch io. But it is not the case anymore with more resent OEL and Samba releases.<\/p>\n
Conclusion<\/h3>\n
I would not use RMAN backups to CIFS as a permanent solution, but if you are running out of space on your NFS share, or maybe for migrations it is a good alternative.<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
By William Sescu Not to often, but sometimes you need to offload your RMAN backups and your DataPump exports to CIFS. You might run out of space on your NFS server, or you are a Windows shop who has only CIFS shares, and then you might need to put your RMAN backups to CIFS. One […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198],"tags":[1028,96,270],"type_dbi":[],"class_list":["post-9753","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","tag-cifs","tag-oracle","tag-rman"],"acf":[],"yoast_head":"\nOracle - RMAN Backups to CIFS - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle - RMAN Backups to CIFS\" \/>\n<meta property=\"og:description\" content=\"By William Sescu Not to often, but sometimes you need to offload your RMAN backups and your DataPump exports to CIFS. You might run out of space on your NFS server, or you are a Windows shop who has only CIFS shares, and then you might need to put your RMAN backups to CIFS. One […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-06T13:26:49+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle – RMAN Backups to CIFS\",\"datePublished\":\"2017-02-06T13:26:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/\"},\"wordCount\":584,\"commentCount\":0,\"keywords\":[\"CIFS\",\"Oracle\",\"RMAN\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/\",\"name\":\"Oracle - RMAN Backups to CIFS - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-02-06T13:26:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle – RMAN Backups to CIFS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle - RMAN Backups to CIFS - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/","og_locale":"en_US","og_type":"article","og_title":"Oracle - RMAN Backups to CIFS","og_description":"By William Sescu Not to often, but sometimes you need to offload your RMAN backups and your DataPump exports to CIFS. You might run out of space on your NFS server, or you are a Windows shop who has only CIFS shares, and then you might need to put your RMAN backups to CIFS. One […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/","og_site_name":"dbi Blog","article_published_time":"2017-02-06T13:26:49+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle – RMAN Backups to CIFS","datePublished":"2017-02-06T13:26:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/"},"wordCount":584,"commentCount":0,"keywords":["CIFS","Oracle","RMAN"],"articleSection":["Database Administration & Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/","name":"Oracle - RMAN Backups to CIFS - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-02-06T13:26:49+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rman-backups-to-cifs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle – RMAN Backups to CIFS"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9753"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9753\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9753"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}