DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002

    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?


    I'm stmontgo and I approve of this message

  2. #2
    Join Date
    Feb 2000
    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.

    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Nov 2001
    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!

  4. #4
    Join Date
    Nov 2000
    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Aug 2002
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.