HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to change the backup and archive destination to a network drive in oracle 11g windows

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
destination11gthearchivenetworkwindowshowandoraclechange

Problem

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

Solution

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.

Context

StackExchange Database Administrators Q#174315, answer score: 2

Revisions (0)

No revisions yet.