1 Reply Latest reply: Jan 19, 2013 5:35 AM by Sebastian Solbach -Dba Community-Oracle RSS

    Oracle RMAN backup to disk on vbox4.2 shared folders

    seerdba
      [https://forums.virtualbox.org/viewtopic.php?f=7&t=53683]

      Cross posting a virtualbox forum post in case someone has this working.

      [posting snippet]
      Anyone successfully using Oracle 10.2/11.2 RMAN to backup to mounted vbox guest shared folder? I'm thinking there may be some special configuration requirement like there is with NFS share mount options.

      RMAN> backup incremental level = 0 database include current controlfile plus archivelog delete input;

      [lengthy output clipped]

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of backup plus archivelog command at 01/18/2013 00:03:14
      ORA-19504: failed to create file "/media/sf_backup/vux099/oracle/vux099db/dataS217_P1_T804988992"
      ORA-27040: file create error, unable to create file
      Linux-x86_64 Error: 22: Invalid argument
      Additional information: 2

      RMAN>

      Recovery Manager complete.
      oracle@vux099:vux099db1 [app/oracle]
      $ touch /media/sf_backup/vux099/oracle/vux099db/myfile; ls -l /media/sf_backup/vux099/oracle/vux099db/myfile
      -rw-r--r-- 1 oracle oinstall 0 Jan 18 00:04 /media/sf_backup/vux099/oracle/vux099db/myfile
      oracle@vux099:vux099db1 [app/oracle]
      $ touch /media/sf_backup/vux099/oracle/vux099db/myfile;
      oracle@vux099:vux099db1 [app/oracle]
      $ mount | grep sf_backup
      backup on /media/sf_backup type vboxsf (uid=51115,gid=51116,rw)
      oracle@vux099:vux099db1 [app/oracle/base/admin/vux099db1/bin]
      $ getent passwd 51115; getent group 51116
      oracle:*:51115:51116:Oracle Administrator:/app/oracle:/bin/bash
      oinstall:*:51116:grid,oracle
      oracle@vux099:vux099db1 [app/oracle/base/admin/vux099db1/bin]
      $ printf "show all;\nexit\n" | rman nocatalog target / | grep DISK
      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/media/sf_backup/vux099/oracle/vux099db/%F';
      CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/media/sf_backup/vux099/oracle/vux099db/dataS%s_P%p_T%t';
      oracle@vux099:vux099db1 [app/oracle/base/admin/vux099db1/bin]
      $
      [end]

      Edited by: user12130856 on Jan 18, 2013 8:08 PM