Operating System - HP-UX
1752778 Members
6104 Online
108789 Solutions
New Discussion юеВ

Database Error after Offline backup

 
Kunju
Occasional Contributor

Database Error after Offline backup

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
2 REPLIES 2
Jeeshan
Honored Contributor

Re: Database Error after Offline backup

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

check also permission.
a warrior never quits
klb
Valued Contributor

Re: Database Error after Offline backup


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