topic Re: Database Error after Offline backup in Operating System - HP-UX

Database Error after Offline backup

Kunju — Mon, 25 Feb 2008 21:29:39 GMT

ORA-01110: data file 866: '/oracle/CN3/sapdata49/btabd_122/btabd.data122'
ORA-01116: error in opening database file 866
ORA-01110: data file 866: '/oracle/CN3/sapdata49/btabd_122/btabd.data122'
ORA-27092: skgfofi: size of file exceeds file size limit of the process

I am getting this error after the offline backup in the alert log file. The Database is getting started properly after the backup normally.
Please let me know the solution.
Thanks in Advance.

Shaheer

Re: Database Error after Offline backup

Jeeshan — Tue, 26 Feb 2008 03:25:50 GMT

check that the data file btabd.data122 is exist or not.

check also permission.

Re: Database Error after Offline backup

klb — Tue, 26 Feb 2008 18:32:17 GMT

Check your ulimit setting. Set it to "unlimited" and try again...

27092, 00000, "skgfofi: size of file exceeds file size limit of the process"
// *Cause: an attempt was made to open a file that exceeds the process's
// file size limit (ulimit), additional information shows the current
// limit (logical blocks) and the size of the file (logical blocks)
// *Action: increase the processes file size limit (ulimit) and retry