Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Huge Files to Restore

Status
Not open for further replies.

marcymarc

Technical User
Oct 2, 2001
32
US
Does anyone have an idea what the deal is with restoring huge files (in this case Oracle files) from backup. I'm getting the following error, the file is about 25Gb!


10:13:21 (58362.001) Could only write 30719 of 38912 bytes to file /oracle/u01/oradata/ukprd117/ukprd117_enb_prd_index_2.dbf at file offset 1 gigabytes + 1073711104 bytes
10:13:22 (58362.001) Couldn't write to file /oracle/u01/oradata/ukprd117/ukprd117_enb_prd_index_2.dbf: File too large
10:13:22 (58362.001) Removing /oracle/u01/oradata/ukprd117/ukprd117_enb_prd_index_2.dbf
 
What options do you select right before you click to start the restore?

When I restore Oracle databases which happens often I usually select overwrite existing files and I uncheck the two boxes on the right side.

Almost look's like the file your restoring is smaller than the file it is expecting to overwrite?


Ryan
 
Assuming that there is indeed enough space in the filesystem to hold this oracle data file, there could be another reason it's not working. Your sys admin guy (or gal) may need to make sure he has the filesytem large file enabled.
 
marcymarc,

did you backup with MPX on? Are you pre NBU DC4.5 FP7? Unix environment?

If Yes, yes and yes, then;

touch /usr/openv/netbackup/NON_MPX_RESTORE

give it a shot.. may not resolve your problem, but did a similar one for me.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top