Large files spanning drives (RMAN)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Large files spanning drives (RMAN)

  1. #1
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    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

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  3. #3
    Join Date
    Nov 2001
    Posts
    335
    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
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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