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