2

Due to space issue I want to change the backup and archive destination from FRA to a network drive in my system (I'm using windows). I've done the following steps to change the destination:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO '\\192.168.20.200\HOME\DEVELOPMENT\JOE';

RMAN> configure channel device type sbt parms 

sbt_library='//192.168.20.200/Home/Development/Joe/';

Now, when I'm trying to BACKUP DATABASE I'm getting the following error:

ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

  • You're setting the backups to go to tapes. You want to backup to tapes? – Renato Afonso May 23 '17 at 16:00
  • @RenatoAfonso : Can please explain me what you meant by tapes? – Joe Joy Valiyaveettil May 26 '17 at 10:09
2

Network drives are managed by system as a drive, then for rman, it should be a disk device :

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\192.168.20.200\HOME\DEVELOPMENT\JOE';

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

I have never tested something like that, but I think it should work.

  • I done the changes as per your suggestion and I'm getting error like this -----------------------RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/24/2017 11:41:07 ORA-19504: failed to create file "\\192.168.20.200\HOME\DEVELOPMENT\JOE" ORA-27040: file create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 5) Access is denied. – Joe Joy Valiyaveettil May 24 '17 at 7:08
  • The user running the rman command or the service account running the Oracle service is not allowed to write to the share. – Guillaume R. May 24 '17 at 10:05
  • R : Can you please suggest me the steps to overcome it? – Joe Joy Valiyaveettil May 26 '17 at 10:09
  • I think rman run under the oracle service account, so you have to grant write access on the share to the Windows account running the oracle service. BEWARE ! It MUST be a domain account, not a local machine one. – Guillaume R. May 29 '17 at 12:58
  • @ Guillaume R. I've given Administrative account password and when I restarted the service it showing error: ** Windows could not start the Oracle ServicePROD service on local computer. Error 1069: The service did not start due to a logon failure.** – Joe Joy Valiyaveettil Jun 20 '17 at 6:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.