Skip to Content
author's profile photo Former Member
Former Member

Backup hanging Oracle 10.2.0.2 ECC600

Hello,

We are running on Windows 64 bit with Oracle 10.2.0.2 installed SAP version ECC 600.

While backing up the Oracle database from DB13 the backups constantly hangs on the same specific point. It is while writing the BTABI.DATA2 from tablespace PSAPBTABI to our backup server. We backup to disk and exactly at the same point it hangs. First I used disk_copy_cmd cpio and later I changed it to dd but still the same error. I updated the BRTOOLS to its latest versions, and tried to backup this specific tablespace from brtools. Everytime the same problem. After a while the whole operating system then hangs.

Can anyone give me any advise where to look? Some log or trace files. I haven't got a clue at this moment. Could it be this file is corrupt or something? Did anyone run into this problem before? Any help would be appreciated.

Kind regards,

Dave Arends

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Nov 28, 2007 at 04:20 PM

    Do you mean both back to tape and backup to disk hang at the same time?

    try a DBVERIFY on the database first.

    if that works, try an export of that tablespace.

    Do you have any datafile belong to this tablespace exceeds 4GB? Most cpio and dd implementation has a limit of 4GB of file size.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 29, 2007 at 11:27 AM

    Hello,

    backing up an tablespace/datafile copies only the blocks to another location.

    The backup utility dont know any Oracle internals like Index PCL2~0.

    So use dbverify to check if the OS can read the complete file and then export the Tablespace like Alans proposal.

    regards

    Uwe Theisinger

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Alan Tan

      Issue solved.

      It had something to do with a NIC that was deleted.

      There were 2 NIC's in it in the past, we deleted one we didn't need and the system got unstable.

      We have installed it back and now it is running fine.

      I still find this strange behaviour of Windows but for now it solved my issue.

      Kind regards,

      Dave Arends

  • Posted on Nov 28, 2007 at 04:14 PM

    it just hangs... or do you get an error message?

    how big is PSAPBTABI? a complete reorg of this tablespace might be a solution.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 06:36 PM

    So can you copy the datafile using just the Windows utilities?

    Does that hang?

    What do you see in the Windows event log viewer?

    It would probably be easiest to eliminate 1 layer at a time to isolate the issue.

    It's very suspicious when you say the whole OS eventually hangs.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks all for your replies.

      I am a little further in my investigation.

      It seems it is hanging on index PCL2~0.

      I have dropped it and created it again but still the problem exists.

      This index has 15616448 rows.

      Is it too big maybe?

      Thanks,

      Dave

  • Posted on Nov 29, 2007 at 02:26 PM

    Hi,

    try to check the file BTABI.DATA2 only

    You can start dbverify command line with different parameter,

    so you can check the file from block x to block y.

    Through this procedure you can determine bad blocks,

    or set the TS in Backup Mode and copy the file with ocopy

    (this tool was available on Oracle 8/9 i never used this with Oracle 10g).

    If the error occour, i think the datafile ist corrupt

    Or try a fsck on OS

    regards

    Uwe

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.