Operating System - HP-UX
1748241 Members
3737 Online
108759 Solutions
New Discussion юеВ

Re: oracle backup is hanging up on one datafile

 
Ashraf_1
Frequent Advisor

oracle backup is hanging up on one datafile

Hi Experts,

When we are making a backup of SAP/oracle database it hangs up in only one data file ├в /oracle//sapdata6/es30fd_1/es30fd.data1├в and it doesn't accept to back it up. Any body knows:
1. How to resolve this?
2. Is this file corrupted taking into his account that the database is running with no problem.

Thanks with best regards,
A
ASHRAFM
15 REPLIES 15
Michael Schulte zur Sur
Honored Contributor

Re: oracle backup is hanging up on one datafile

Hi,

how are you doing the backup?

greetings,

Michael
Ashraf_1
Frequent Advisor

Re: oracle backup is hanging up on one datafile

Hi,

I tried two different methods of backup:
One is using sapdba brbackup utility which is utilizing dd and cpio commands and the other is using offline fbackup.

Both of them failed on this file.

Regards,
Ashraf
ASHRAFM
Michael Schulte zur Sur
Honored Contributor

Re: oracle backup is hanging up on one datafile

Hi,

any error messages in syslog.log? Try a cat failingfile > /dev/null to see, if you have disk problems.

greetings,

Michael
Ashraf_1
Frequent Advisor

Re: oracle backup is hanging up on one datafile

Hi Michaele,


In the syslog.log there are no indication for certain problems in regards of this file. However, i tried the command cat failingfile> /dev/null and it reports
cat: Cannot open failingfile: No such file or directory

Regards,
Ashraf
ASHRAFM
Michael Schulte zur Sur
Honored Contributor

Re: oracle backup is hanging up on one datafile

Hi,

with failingfile I meant the file, the backup got stuck with:
/oracle//sapdata6/es30fd_1/es30fd.data1

Michael
Ashraf_1
Frequent Advisor

Re: oracle backup is hanging up on one datafile

Hi,

All files that i tried cat on was OK except this file it hangs up with no result and it is not possible even to kill the process using unsafe kill.

Ashraf
ASHRAFM
Michael Schulte zur Sur
Honored Contributor

Re: oracle backup is hanging up on one datafile

Hi,

is this file on another lvol than the others?
Can you umount all lvols and then mount them again? Maybe you will have to reboot the machine. The hanging cat process seems to point to some more serious disk error.

Michael
Ashraf_1
Frequent Advisor

Re: oracle backup is hanging up on one datafile

Yes, this datafile is on the same logical volume i tried cat on them. Now to kill the process i restarted the system.

Ashraf
ASHRAFM
Michael Schulte zur Sur
Honored Contributor

Re: oracle backup is hanging up on one datafile

Hi,

any errors in /var/adm/messages or /var/adm/syslog/syslog.log?
run dmesg.

Michael