RMAN backuo to VirtualBox shared directory
Date: Fri, 14 Aug 2020 13:22:33 -0400
Message-ID: <ab4f0b3d-d85e-b2fa-822c-0f35e466ba4f_at_gmail.com>
I tried backing up to a VirtualBox shared directory and it doesn't work:
channel t2: starting piece 1 at 14-AUG-20
RMAN-03009: failure of backup command on t1 channel at 08/14/2020 13:07:22
ORA-19502: write error on file
"/media/sf_tmp/DB_08-14-2020-01v7rcc9_1_1.bak", block number 1 (block
size=8192)
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 95: Operation not supported Additional information: 4294967295 Additional information: 1048576
channel t1 disabled, job failed on it will be run on another channel released channel: t1
released channel: t2
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-03009: failure of backup command on t2 channel at 08/14/2020 13:07:22 ORA-19502: write error on file
"/media/sf_tmp/DB_08-14-2020-02v7rcc9_1_1.bak", block number 1 (block size=8192)
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 95: Operation not supported Additional information: 4294967295 Additional information: 1048576
The idea is to create a standby DB from backup on a cloned VM. I know that I can copy it but I don't really like having to do an intermediate step. Is there anything I can do to have VBox shared directory as a backup target? Here are the directories that I have:
bash-4.2$ mount|grep media
Downloads on /media/sf_Downloads type vboxsf
(rw,nodev,relatime,iocharset=utf8,uid=0,gid=981,dmode=0770,fmode=0770,tag=VBoxAutomounter)
ORA-19.3 on /media/sf_ORA-19.3 type vboxsf
(rw,nodev,relatime,iocharset=utf8,uid=0,gid=981,dmode=0770,fmode=0770,tag=VBoxAutomounter)
tmp on /media/sf_tmp type vboxsf
(rw,nodev,relatime,iocharset=utf8,uid=0,gid=981,dmode=0770,fmode=0770,tag=VBoxAutomounter)
It looks like the problem is the support for async I/O that is missing from VBox shared directories. Does anyone know how to solve this? Another idea is to have NFS server on the host but that is a lot of work.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 14 2020 - 19:22:33 CEST