Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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