cancel
Showing results for 
Search instead for 
Did you mean: 

DB12/DB14 now showing BRBACKUP logs

Former Member
0 Kudos

Hello,

In our R3 system with 46C, DB12 is not showing the logs for BRBACKUP.

It is, however, showing the logs for BRARCHIVE.

When I click on DB12 --> Overview of Database Backups, nothing happens and my session remains at the same screen. The session is not frozen or hung, it simply does not produce any results upon clicking this button.

If I click on DB12 --> Last Successful Backup, it shows the logs as follows:

Database backup log from / / : : .

Return code: 0000 Success Database host: <hostname>

No action log for this action found in the database

Check the detail log

Clicking on Detail Log, it shows:

Detail log: .

########.###########..#########

lost+found##########IPR#########bdvprvve.and############bdvragne.and############bdvrfeie.and############bdvrkcdp.and#######

####bdvrozyk.and############bdvrtrdj.and############restIPR.log#########bdvsireg.and############bdvsnozq.and############bdvssmuy.and############back<SID>.log######

I can't even see these logs from DB14.

At OS level, the directory /sapbackup shows the following files:

-rw-rw---- 1 oraipr sapsys 53019 Jul 22 2007 bdvthggi.and

.

.

.

-rw-rw---- 1 oraipr sapsys 52965 Jul 23 2007 bdvtmeas.and

-rw-rw---- 1 oraipr sapsys 52965 Jul 24 2007 bdvtrbvy.and

-rw-rr 1 oraipr dba 92 Feb 22 12:47 bdxibozf.pnt

-rw-rr 1 oraipr dba 137 Mar 3 14:03 bdxjyztd.pnt

What can be the issue? What can I do about this? Has this got anything to do with permissions?

Please help. This is very urgent.

Regards,

Shitij

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member185954
Active Contributor
0 Kudos

Hello Shitij,

I found that even I face the same problem exactly.

I debugged the DB12 program and found that on clicking the overview log button, the program reads an internal table backup_tab, which it fills up using a function module: DB_ORA_BACKUP_TAB

I checked the function module DB_ORA_BACKUP_TAB and found the following statements:

*"----------------------------------------------------------------------
*"*"Lokale Schnittstelle:
*"       EXPORTING
*"             VALUE(TABCNT) LIKE  SY-DBCNT
*"       TABLES
*"              BACKUP_TAB STRUCTURE  SDBAH OPTIONAL
*"----------------------------------------------------------------------
* tables sdbah.

  CLEAR BACKUP_TAB. REFRESH BACKUP_TAB.

  call function 'DB_DBNAME'
    importing dbname = dbname.

  SELECT * FROM SDBAH INTO TABLE BACKUP_TAB
     WHERE sysid = :dbname and FUNCT IN
     ('ant','aft','and','afd','anp','afp',
      'anf','aff','anr','afr','ans','afs',
      'pnt','pft','pnd','pfd','pnp','pfp',
      'pnf','pff','pnr','pfr','pns','pfs',
      'fnt','fft','fnd','ffd','fnp','ffp',
      'fnf','fff','fnr','ffr','fns','ffs',
      'int','ift','ind','ifd','inp','ifp',
      'inf','iff','inr','ifr','ins','ifs',
      'ANT','AFT','AND','AFD','ANP','AFP',
      'ANF','AFF','ANR','AFR','ANS','AFS',
      'PNT','PFT','PND','PFD','PNP','PFP',
      'PNF','PFF','PNF','PFF','PNS','PFS',
      'FNT','FFT','FND','FFD','FNP','FFP',
      'FNF','FFF','FNR','FFR','FNS','FFS',
      'INT','IFT','IND','IFD','INP','IFP',
      'INF','IFF','INF','IFF','INS','IFS')
     ORDER BY BEG DESCENDING.

  TABCNT = SY-DBCNT.

ENDFUNCTION.

And i think that for your and my system the table : SDBAH is empty

Regards,

Siddhesh

Edited by: Siddhesh Ghag on Apr 16, 2008 11:06 AM

Former Member
0 Kudos

Hello Shitij,

You can check the data base backup log in DB02.

Have you configure the database backup in db13 correctly?

Kindly award the points if issue solve.

Regards,

Rohit mehta