Application Error on brbackup and brarchive

[Former Member]

Hi,

Our backup failes with no error message in the log. The backup status stays at "starting". The same status also shows in archive log.

Error below are reported in the server application event logs:

Faulting application brbackup.exe, version 6400.256.15.35965, faulting module orannts9.dll, version 9.2.0.2, fault address 0x0000000000004fb0.

I already triend replacing orannts9.dll from other servers with the same os and db version but the problem still exist.

I have also tried applying the latest brtools but the problem is still there.

We are in ECC5, Win Server 2003 Itanium, and Oracle 9.2.0.5.

thanks,

kbas

[Former Member]

Dear K Bas

Just a thought. As you mentioned that other servers are also storing tehir backups on the same directory, can you please check if the said location has enough space to store new backups. Maybe the error might be caused because of low disk space.

Lokesh.

[Former Member]

Also the parameter backup_root_dir should point to the directory where you want the backup to be stored. It is currently poiniting to T:/oracle/DEV/sapbackup. This is the default setting. Change it to the directory where you have to store the backup files.

Lokesh

[Former Member]

Hi,

I have already checked all of that before running the backup. All datafile are not in backup mode. I have also deleted the .lock.bra file from the archive and the backup directories before running the backup. The backup_root_dir is also pointing to the backup directory.

There is a consistent error message in the Windows Event Viewer.

Error Log entry 1:

Faulting application brbackup.exe, version 6400.256.15.35965, faulting module orannts9.dll, version 9.2.0.2, fault address 0x0000000000004fb0.

Error Log entry 2:

Faulting application tp.exe, version 6400.221.14.45770, faulting module orannts9.dll, version 9.2.0.2, fault address 0x0000000000004fb0.

Error Log entry 3:

Reporting queued error: faulting application tp.exe, version 6400.221.14.45770, faulting module orannts9.dll, version 9.2.0.2, fault address 0x0000000000004fb0.

I have already tried replacing the orannts9.dll but the error is still there.

Any more idea on what's causing this error?

thanks,

kbas

[Former Member]

Where exactly is this T:/oracle/sapbackup directory on which you are trying to store the backup. Is it on network. Is the DB server able to reach the said directory, in the sense, it should be mapped on DB server. I still suggest try changing the backup_root_dir path.

Lokesh

[Former Member]

Your archive files maybe in backup mode. Look for a file .lock.bra in /oracle/SID/oraarch. In case you find it delete it. Also check if your tablespaces are already in backup mode. In case, yes then through SQL command "Alter tablespace <tablespace name> end backup, make them come out of it. Try taking the backup again. Maybe this works.

Lokesh

[former_member603052]

Hi

Are u taking backup to disk or Tape......

Regards,

Kalyan

[Former Member]

We are using disk for backup. Here is the backup log.

###=========Start of Log==============###

Detail log: bdzvfrve.fnd

BR0051I BRBACKUP 6.40 (50)

BR0055I Start of database backup: bdzvfrve.fnd 2009-02-01 19.49.06

BR0484I BRBACKUP log file: D:\oracle\DEV\sapbackup\bdzvfrve.fnd

BR0477I Oracle pfile D:\oracle\DEV\920\database\initDEV.ora created from spfile D:\oracle\DEV\920\database\spfileDEV.ora

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home D:\oracle\DEV\920

oracle_profile D:\oracle\DEV\920\database\initDEV.ora

sapdata_home D:\oracle\DEV

sap_profile D:\oracle\DEV\920\database\initDEV.sap

backup_mode FULL

backup_type online

backup_dev_type disk

backup_root_dir T:\oracle\DEV\sapbackup

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

exec_parallel 0

system_info SAPServiceDEV S11D001E Windows 5.2 Build 3790 Service Pack 2 IA64

oracle_info DEV 9.2.0.5.1 8192 25106 451537171

sap_info 640 SAPDEV DEV K0582976183 R3_ORA 0020193585

make_info NTia64 OCI_920_SHARE Oct 21 2008

command_line brbackup -u / -jid FLLOG20090201194850 -c force -t online -m full -p initDEV.sap -a -c force -p initDEV.sap -sd

BR0116I ARCHIVE LOG LIST before backup for database instance DEV

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination E:\oracle\DEV\oraarch\DEVarch

Archive format ARC%S.%T

Oldest online log sequence 25103

Next log sequence to archive 25106

Current log sequence 25106 SCN: 451537171

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_10\DEV.DATA10 10737426432 12 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_11\DEV.DATA11 5242888192 27 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_12\DEV.DATA12 10485768192 28 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_1\DEV.DATA1 5263859712 3 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_2\DEV.DATA2 5075116032 4 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_3\DEV.DATA3 5138030592 5 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_4\DEV.DATA4 4949286912 6 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_5\DEV.DATA5 4907343872 7 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_6\DEV.DATA6 4886372352 8 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_7\DEV.DATA7 5054144512 9 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_8\DEV.DATA8 5200945152 10 7 NOLINK FILE 0 0

PSAPDEV ONLINE* ONLINE H:\ORACLE\DEV\SAPDATA3\DEV_9\DEV.DATA9 5284831232 11 7 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_10\DEV640.DATA10 3334479872 22 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_11\DEV640.DATA11 3271565312 23 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_12\DEV640.DATA12 10737426432 24 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_1\DEV640.DATA1 3313508352 13 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_2\DEV640.DATA2 3460308992 14 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_3\DEV640.DATA3 3418365952 15 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_4\DEV640.DATA4 3649052672 16 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_5\DEV640.DATA5 3690995712 17 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_6\DEV640.DATA6 3439337472 18 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_7\DEV640.DATA7 3292536832 19 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_8\DEV640.DATA8 3376422912 20 6 NOLINK FILE 0 0

PSAPDEV640 ONLINE* ONLINE G:\ORACLE\DEV\SAPDATA2\DEV640_9\DEV640.DATA9 3313508352 21 6 NOLINK FILE 0 0

PSAPDEVDB ONLINE* ONLINE F:\ORACLE\DEV\SAPDATA4\DEVDB_1\DEVDB.DATA1 524296192 26 5 NOLINK FILE 0 0

PSAPDEVUSR ONLINE* ONLINE F:\ORACLE\DEV\SAPDATA1\DEVUSR_1\DEVUSR.DATA1 20979712 25 5 NOLINK FILE 0 0

PSAPDEVUSR ONLINE* ONLINE F:\ORACLE\DEV\SAPDATA1\DEVUSR_2\DEVUSR.DATA2 20979712 29 5 NOLINK FILE 0 0

PSAPDEVUSR ONLINE* ONLINE F:\ORACLE\DEV\SAPDATA1\DEVUSR_3\DEVUSR.DATA3 1048584192 31 5 NOLINK FILE 0 0

PSAPDEVUSR ONLINE* ONLINE+ F:\ORACLE\DEV\SAPDATA1\DEVUSR_4\DEVUSR.DATA4 1048584192 32 5 NOLINK FILE 10485760000 1048576000

PSAPTEMP ONLINE# ONLINE F:\ORACLE\DEV\SAPDATA1\TEMP_1\TEMP.DATA1 10485768192 -1 5 NOLINK FILE 0 0

PSAPUNDO ONLINE- ONLINE F:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1 10485768192 2 5 NOLINK FILE 0 0

SYSTEM ONLINE* SYSTEM+ F:\ORACLE\DEV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 629153792 1 5 NOLINK FILE 34359721984 20971520

SYSTEM ONLINE* SYSTEM F:\ORACLE\DEV\SAPDATA1\SYSTEM_2\SYSTEM.DATA2 209723392 30 5 NOLINK FILE 0 0

BR0119I Redo log files

File Size Group Device Status Link Type

E:\ORACLE\DEV\MIRRLOGA\LOG_G11M2.DBF 52429312 1 4 INUSE NOLINK FILE

D:\ORACLE\DEV\ORIGLOGA\LOG_G11M1.DBF 52429312 1 3 INUSE NOLINK FILE

E:\ORACLE\DEV\MIRRLOGB\LOG_G12M2.DBF 52429312 2 4 INUSE NOLINK FILE

D:\ORACLE\DEV\ORIGLOGB\LOG_G12M1.DBF 52429312 2 3 INUSE NOLINK FILE

E:\ORACLE\DEV\MIRRLOGA\LOG_G13M2.DBF 52429312 3 4 INUSE NOLINK FILE

D:\ORACLE\DEV\ORIGLOGA\LOG_G13M1.DBF 52429312 3 3 INUSE NOLINK FILE

E:\ORACLE\DEV\MIRRLOGB\LOG_G14M2.DBF 52429312 4 4 INUSE NOLINK FILE

D:\ORACLE\DEV\ORIGLOGB\LOG_G14M1.DBF 52429312 4 3 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

D:\oracle\DEV\origlogA\cntrl\cntrlDEV.dbf 12460032 0 3 NOLINK FILE

F:\oracle\DEV\sapdata1\system_1\cntrl\cntrlDEV.dbf 12460032 0 5 NOLINK FILE

D:\oracle\DEV\saparch\cntrl\cntrlDEV.dbf 12460032 0 3 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPDEV:

PSAPDEV, PSAPDEV640, PSAPDEVUSR

###=========End of Log==============###

thanks,

Kbas

[former_member204746]

Update BRBACKUP to latest patch level

patch Oracle 9 to 9.2.0.8 with latest opatch and run post-processing scripts after.

[Former Member]

Hi

The backup_root_dir is pointing to the correct backup directory (t:\oracle\ADE\sapbackup). Drive T is a network drive and this has been this way for 2 years now. Othe servers (Test and prod) are also saving the backup in the same network drive and both systems are okay.

Eric, I do not think updating oracle to 9.2.0.8 is the right solution because our Test and Production servers have the same version of oracle and patches and the backup is working on those systems.

This problem only started on november. It was running perfectly before that (for 2 years). There was no update on the OS and DB before this error occured.

Any more ideas?

thanks,

KBas

[former_member204746]

check on your disk if you can find a directory named found.000 on the root of the disk. if so, this means you had an NTFS corruption.

in your case, I would uninstall Oracle 9i and re-install again with all necessary Oracle patches. This would clear any kind of corruption.

[Former Member]

Hi,

There is no found.000 in drive T and we have enough disk space to backup all servers.

SAP OSS reply says its because our oracle version is old already But I do not buy it because our other servers (Test and Prod) are using the same oracle version and both are okay.

thanks,

kbas

[fidel_vales]

Hi,

May be you did not understood Oracle Support.

There are some facts:

1) Oracle ended its customer support for 9i some years ago

2) Oracle ended its "free" extended support for 9i last year.

Therefore, if you get an error that is not documented then, it does not matter that you do not get the error in a different machine with the same oracle version. You do not get support.

Cannot be reproduced and a bug will not be opened, because it is an old version

[Former Member]

Hi Fidel,

OSS still gave us support for 9i. In fact they remote connected (via WTS) to our server 2 times already to try to solve the problem.

Since they cannot resolve this problem, they then say that its because oracle was old.

rgds,

Karl

[former_member204746]

Maybe the OSS guys were a bit lazy, but Fidel is right. you are running an unsupported Oracle version, so, don't expect to get great support on it.