on 04-16-2008 6:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.