-
Large files spanning drives (RMAN)
Hiedo Ho,
As part of B&R we want to use RMAN to backup to disk and then to tape. We do this so that we maintain recent backps on disk in the event we nee to recover fast.
Anyway, we're on win 2k using an EMC SAN on DELL. The Windooze admins
have created a 250GB LUN through the array that I have assigned a drive letter to so that windows sees a 250gb drive. The LUN is composed of 36GB physical drives.
Now, our rman backups end up being 2 backup peices of 20gb each. Problem is, 1 in 5 times the backup fails with the ol' 'no space left on device' error event though there is clearly lots of space on the LUN. Could this be a problem where in RMAN begins to write the backup peice, writes part of the backup peice and then fails
because there is no more space left on the actual physical device it is writing to? The admin says that this config will allow large files
to spanned over several physical devices however the error I am seeing seems to indicate otherwise.
Any thoughts?
tks
steve
I'm stmontgo and I approve of this message
-
Steve,
If the SAs have properly configured the RAID then logically there shouldn't be any problem in backing-up to that drive. Do you get error after the backup file reaches to a scpecific size ?
If you have any big datafile (or any other big file) try copying the file manually (witout using RMAN) and check the copy is successful.
HTH
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
How much space left no device when backup fails?
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
Hmmm. Either sounds like the RAID is not working the way they think it should or you have hit a windoz bug. You might try having your backup pieces limited to 2000M to rule out a Windoz bug with big files. (You could also reboot, but it wouldn't help anyway )
Jeff Hunter
-
oodles of space,
the backup peices take 20gb each and there is approx 180 gb leff on the lun
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|