Offline backup scheduled in DB13 failed

[Santanu]

Hello everybody,

Whole database offline + redo log backup scheduled in DB13 failed. We are running SAP on Oracle 10.2.0.2 on HP UX B.11.23

Here is the portion of log mentioning the error.

BR0202I Saving /oracle/TU4/sapbackup/.tape.hdr0

BR0203I to /dev/rmt/10mn ...

BR0209I Volume in device /dev/rmt/10mn has name TU4B05

BR0202I Saving init_ora

BR0203I to /dev/rmt/10mn ...

BR0202I Saving /oracle/TU4/102_64/dbs/initTU4.sap

BR0203I to /dev/rmt/10mn ...

BR0280I BRBACKUP time stamp: 2009-02-03 03.00.58

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2009-02-03 03.00.58

BR0307I Shutting down database instance TU4 ...

BR0278E Command output of '/oracle/TU4/102_64/bin/sqlplus /nolog < /oracle/TU4/sapbackup/.bdzvnffe.spi':

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Feb 3 03:00:58 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> Connected.

SQL>

SQL> ORA-01013: user requested cancel of current operation

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

BR0280I BRBACKUP time stamp: 2009-02-03 04.01.04

BR0279E Return code from '/oracle/TU4/102_64/bin/sqlplus /nolog < /oracle/TU4/sapbackup/.bdzvnffe.spi': 0

BR0302E SQLPLUS call for database instance TU4 failed

BR0309E Shutdown of database instance TU4 failed

BR0056I End of database backup: bdzvnffe.aft 2009-02-03 04.01.04

BR0280I BRBACKUP time stamp: 2009-02-03 04.01.05

BR0054I BRBACKUP terminated with errors

Any input will be highly appreciated.

Regards

Santanu

[Former Member · Accepted solution]

Hi

Are u taking the offline backup on disk or tape. Your log seems to be mentioning it to be on tape. Anyways, have you set the /oracle/SID/102_64/dbs/initSID.sap file parameters accordingly. Also the log says that there has been a user intervention to stop the backup. Did you press Cntrl C in the process. Offline backups to tape is a bit tricky aand even we are fighting on this. I would suggest taking it on disk and then transferring it to tape.

Lokesh

[Santanu · Accepted solution]

Hi Lokesh ,

We are taking offline backup thru DB13 regularly from long back without having any problem.

Yesterday we face this problem and unable to find out the error.

There is no way for cancellation thru Cntrl+C as this is scheduled from DB13 at 03:00:00 hrs.

Regards

Santanu

[Former Member · Accepted solution]

Dear Santanu

Please check the initSID.sap file for any cahnge of parameter. Also try shutting and starting up the database manually to check for any errors. Also check if everything is being done as it used to be done earlier. Has someone changed some file or parameter. Is the backup being taken up on tape or disk.

Lokesh

[Santanu · Accepted solution]

Hi

We are taking backup on tape. init<sid>.sap file not modified .

I found one thing sapbackup filesystem was 92% full. I clear that filesystem.

I cannot check database shut and start now as this is a production server.

Regards

Santanu

[Former Member · Accepted solution]

Hi, are you trying to read Note 618861 - Composite SAP Note: ORA-01013 ?

Check 5 -->

As of Oracle 9i, if a shutdown takes longer than an hour, it is terminated with an ORA-01013 error (refer to Oracle Bug 2850797).

Regards.

[Santanu · Accepted solution]

Thanks Sergo

It seems that the shutdown was taking longer time. Some bakground job was running .

Next day backup was successfull

Regards

Santanu