Backup Error Need Help

[pawan_sharma9]

BRBACKUP GIVING ERROR says file does not exist. Need Help

Detail log: bdxgvwkj . and

BR0051I BRBACKUP 7.00 (11)

BR0055I Start of database backup: bdxgvwkj.and 2008-02-16 12.27.49

BR0477I Oracle pfile /oracle/DEV/102_64/dbs/initDEV.ora created from spfile /oracle/DEV/102_64/dbs/spfileDEV.ora

BR0280I BRBACKUP time stamp: 2008-02-16 12.27.51

BR0319I Control file copy created: /oracle/DEV/sapbackup/cntrlDEV.dbf 13189120

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home /oracle/DEV/102_64

oracle_profile /oracle/DEV/102_64/dbs/initDEV.ora

sapdata_home /oracle/DEV

sap_profile /oracle/DEV/102_64/dbs/initDEV.sap

backup_mode ALL

backup_type online

backup_dev_type disk

backup_root_dir /nfshare

compress yes

compress_cmd compress -c $ > $

exec_parallel 0

system_info oradev/oradev sakatadev00 SunOS 5.10 Generic_118833-17 sun4u

oracle_info DEV 10.2.0.2.0 8192 4767 67322176

sap_info 700 SAPSR3 DEV TEMPLICENSE R3_ORA INITIAL

make_info sun_64 OCI_101 Feb 28 2006

command_line /usr/sap/DEV/SYS/exe/run/brbackup -p initDEV.sap -d disk -t online -m all -k yes -e 0 -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance DEV

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/DEV/oraarch/DEVarch

Archive format %t_%s_%r.dbf

Oldest online log sequence 4764

Next log sequence to archive 4767

Current log sequence 4767 SCN: 67322176

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

File Size Group Device Status Link Type

/oracle/DEV/origlogA/log_g11m1.dbf 52429312 1 5570563 INUSE NOLINK FILE

/oracle/DEV/mirrlogA/log_g11m2.dbf 52429312 1 5570565 INUSE NOLINK FILE

/oracle/DEV/origlogB/log_g12m1.dbf 52429312 2 5570564 INUSE NOLINK FILE

/oracle/DEV/mirrlogB/log_g12m2.dbf 52429312 2 5570566 INUSE NOLINK FILE

/oracle/DEV/origlogA/log_g13m1.dbf 52429312 3 5570563 INUSE NOLINK FILE

/oracle/DEV/mirrlogA/log_g13m2.dbf 52429312 3 5570565 INUSE NOLINK FILE

/oracle/DEV/origlogB/log_g14m1.dbf 52429312 4 5570564 INUSE NOLINK FILE

/oracle/DEV/mirrlogB/log_g14m2.dbf 52429312 4 5570566 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/DEV/origlogA/cntrl/cntrlDEV.dbf 13189120 0 5570563 NOLINK FILE

/oracle/DEV/origlogB/cntrl/cntrlDEV.dbf 13189120 0 5570564 NOLINK FILE

/oracle/DEV/sapdata1/cntrl/cntrlDEV.dbf 13189120 0 2097171 NOLINK FILE

BR0616I Tablespaces in tables TAORA and IAORA for owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0280I BRBACKUP time stamp: 2008-02-16 12.27.52

BR0301E SQL error -8103 at location BrSapTspList-9

ORA-08103: object no longer exists

BR0056I End of database backup: bdxgvwkj.and 2008-02-16 12.27.52

BR0280I BRBACKUP time stamp: 2008-02-16 12.27.52

BR0054I BRBACKUP terminated with errors

[fidel_vales]

Hi,

Can you reproduce the problem?

I mean, each time you execute the backup do you get the same error?

If NO -> then, as Juan indicated, the object could have been deleted while it was being read

If YES -> May be you have a corrupted object in your database. Perform a consistency check.

You can increase the trace level of the backup to see exactly what object is giving you the error. I do not think it is TAORA or IAORA, but better be sure

[Former Member]

This message was moderated.

[Former Member]

Hello daspeac,

I am not going to decide whether your reply is spam.

But in any case a Recovery Toolbox for SQL Server will be completely useless for an Oracle database.

Did you notice what the title of this forum is, or what this thread is about?

regards

[former_member204746]

check in tables TAORA and IAORA. you have tablespaces references.

make sure this matches real active tablespaces.

[JPReyes]

That usually means that whatever object BRBACKUP was looking for was deleted since the operation began.

Have you tried to execute the backup again?

Regards

Juan