DB12 no log backup

[Former Member]

Hi all!

We have a problem with Log of Oracle 10.2 Backup in DB12.

I try to execute a backup offline of an istance SAP NW 7.0 ABAP via brbackup.

The backup work fine and end without problem, but if I see into DB12 transaction, I can't see any log backup...

Is there anyone which halp me?

Best regards,

Davide BRUNO

Syskoplan Reply

[Former Member · Accepted solution]

Hi Davide,

Thanks for clarifying the actual issue. Please let me know what is the actual result of the DB12 command. Does it shows all empty. You are not getting the summary of the backup as well ? Also do you get any error message any where ?

Also would be interested on the history of the system. Is it a freshly installed or copied system.

Regards,

Sanujit

[Former Member · Accepted solution]

Hi!

When I go into DB12 transaction, I see nothing, an empty set. No error.

The system was installed with a new installation, it isn't a system copy.

Thank you very much

Davide

[Former Member · Accepted solution]

Hello the problem is solved.

I open an OSS message and a SAP Support sayd us:

Hello Davide,

The cause of this issue is that synonyms to SDBAH and SDBAD points to

tables in wrong schema -> 'SAPSR4DB'. Please run the following command

order to change synonyms back to SAPSR3 schema:

brconnect -u / -c -f crsyn -o sapsr3

Subsequent backups should be then visible in DB12.

Best regards,

Adriano Pimentel

SAP Active Global Support - Netweaver Web Application Server

Phone/fax numbers: note #560499

I execute the commandand the result was:

hostmachine:oraff1 12> brconnect -u / -c -f crsyn -o sapsr3
BR0801I BRCONNECT 7.00 (32)

BR0280I BRCONNECT time stamp: 2010-07-13 09.12.40
BR0833I Creating public synonyms for database log owner SAPSR3...

BR0925I Public synonym SAP_SDBAH created successfully for table SAPSR3.SDBAH
BR0925I Public synonym SAP_SDBAD created successfully for table SAPSR3.SDBAD
BR0925I Public synonym SAP_MLICHECK created successfully for table SAPSR3.MLICHECK
BR0925I Public synonym SAP_SAPLIKEY created successfully for table SAPSR3.SAPLIKEY
BR0925I Public synonym SAP_DBAML created successfully for table SAPSR3.DBAML
BR0925I Public synonym SAP_DBARCL created successfully for table SAPSR3.DBARCL
BR0925I Public synonym SAP_DBAFID created successfully for table SAPSR3.DBAFID
BR0925I Public synonym SAP_DBAEXTL created successfully for table SAPSR3.DBAEXTL
BR0925I Public synonym SAP_DBAREOL created successfully for table SAPSR3.DBAREOL
BR0925I Public synonym SAP_DBABARL created successfully for table SAPSR3.DBABARL
BR0925I Public synonym SAP_DBADFL created successfully for table SAPSR3.DBADFL
BR0925I Public synonym SAP_DBAOPTL created successfully for table SAPSR3.DBAOPTL
BR0925I Public synonym SAP_DBASPAL created successfully for table SAPSR3.DBASPAL
BR0925I Public synonym SAP_DBABD created successfully for table SAPSR3.DBABD
BR0925I Public synonym SAP_DBABL created successfully for table SAPSR3.DBABL
BR0925I Public synonym SAP_DBATL created successfully for table SAPSR3.DBATL
BR0925I Public synonym SAP_DBAOBJL created successfully for table SAPSR3.DBAOBJL
BR0925I Public synonym SAP_DBAPHAL created successfully for table SAPSR3.DBAPHAL
BR0925I Public synonym SAP_DBAGRP created successfully for table SAPSR3.DBAGRP
BR0925I Public synonym SAP_DBAERR created successfully for table SAPSR3.DBAERR
BR0925I Public synonym SAP_DBATRIAL created successfully for table SAPSR3.DBATRIAL
BR0925I Public synonym SAP_SVERS created successfully for table SAPSR3.SVERS
BR0925I Public synonym SAP_TGORA created successfully for table SAPSR3.TGORA
BR0925I Public synonym SAP_IGORA created successfully for table SAPSR3.IGORA
BR0925I Public synonym SAP_TSORA created successfully for table SAPSR3.TSORA
BR0925I Public synonym SAP_TAORA created successfully for table SAPSR3.TAORA
BR0925I Public synonym SAP_IAORA created successfully for table SAPSR3.IAORA
BR0925I Public synonym SAP_DD02L created successfully for table SAPSR3.DD02L
BR0925I Public synonym SAP_DD09L created successfully for table SAPSR3.DD09L
BR0925I Public synonym SAP_DDNTT created successfully for table SAPSR3.DDNTT
BR0925I Public synonym SAP_DBCHK created successfully for table SAPSR3.DBCHK
BR0925I Public synonym SAP_DBDIFF created successfully for table SAPSR3.DBDIFF
BR0925I Public synonym SAP_DBSTATC created successfully for table SAPSR3.DBSTATC
BR0925I Public synonym SAP_DBSTATTORA created successfully for table SAPSR3.DBSTATTORA
BR0925I Public synonym SAP_DBSTATIORA created successfully for table SAPSR3.DBSTATIORA
BR0925I Public synonym SAP_DBSTATHORA created successfully for table SAPSR3.DBSTATHORA
BR0925I Public synonym SAP_DBSTAIHORA created successfully for table SAPSR3.DBSTAIHORA
BR0925I Public synonym SAP_DBCHECKORA created successfully for table SAPSR3.DBCHECKORA
BR0925I Public synonym SAP_DBMSGORA created successfully for table SAPSR3.DBMSGORA

BR0280I BRCONNECT time stamp: 2010-07-13 09.12.41
BR0834I Public synonyms for database log owner SAPSR3 created successfully

BR0280I BRCONNECT time stamp: 2010-07-13 09.12.41
BR0802I BRCONNECT completed successfully

and after this activity, the logs backup are in DB12 transaction

Best regards all for your support

[Former Member]

Hi Davide,

Sorry for the delayed response. It seem slike only answer to your situation is

Check SAP Note 1081265 - DBACOCKPIT: Backup logs are not displayed "as suggested above.

If you are in the same patch level, would be good to raise a call with SAP.

Regards,

Sanujit

[Former Member]

Hi Davide,

Before suggesting any solution, please confirm, if we have understood your issue right.

You are taking the offline backup of you database using brbackup (OS Level/HP Data Protector).

When you are checking the Backup status in DB12, you are not able to display the log for the same.

Please let me know otherwise.

Also are you able to see the summary data of the Backups ?

Please check in the sapbackup directory if you are seeing any file with ".aff" extension, with the timestamp of the date when you have taken the backup.

Regards,

Sanujit

[Former Member]

Hello, thank you for your answer!

Yes, yoo say exactly my problem.

On OS level, via brbackup, when the backup finished, into sapbackup directory I find the .aff file

that finished with

BR0280I BRBACKUP time stamp: 2010-07-09 07.25.30
BR0232I 7 of 7 files saved by backup utility
BR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2010-07-09 07.25.35
BR0307I Shutting down database instance FF1 ...

BR0280I BRBACKUP time stamp: 2010-07-09 07.26.33
BR0308I Shutdown of database instance FF1 successful

BR0056I End of database backup: bedqblmr.aff 2010-07-09 07.25.30
BR0280I BRBACKUP time stamp: 2010-07-09 07.26.33
BR0052I BRBACKUP completed successfully

but into DB12 of the SAP system . I don't see any log backup.

best regards,

Davide BRUNO

[Former Member]

Hi,

Could you execute the script - sapdba_role.sql (check for Oracle version relevance) attached to the following Note and as advised in the same note:

-

---

SAP Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

-

---

Also execute the above script for ora<sid> , <sid>adm users as mentioned in the following note, under heading(Application-specific database role SAPDBA)

-

---

SAP Note 834917 - Oracle Database 10g: New database role SAPCONN

-

---

This should clear off any auth issues(if any).

cheers !

PRADi

[Former Member]

Than you very much for your suggestion about OSS Note, but I try to execute the script SQL and re-execute the backup, without any solution.

The backup work fine and end without any error

[Former Member]

Hi,

Similarly how you have scheduled the offline backup of database through BRBACKUP in the same way you need to schedule or take the backup of archive log files from BRTOOLS or through DB13 from SAP.

Regards,

Sharath

[Former Member]

We try to backup also with integration with HP Data Protector but the problem is the same.

I think that there is some configuration missing..

[Former Member]

Hi,

Do you mean that even though the log backup is scheduled its not happening. If so then what is the error you are getting. If not then try to schedule the archive log backup as per your backup setup.

Regards,

Sharath

[Former Member]

The problem is that I don't have any error..

On OS system, into logfile of backup offline, the backup is ended without problem, all datafile was backupped good.

The system is in NO ARCHIVE MODE, and I can't schedule the backup of archive log for test..

The only problem is that if I go into DB12 transaction, i don't find any backup session.

[Former Member]

Hi,

First bring your database to ARCHIVE LOG MODE and after that schedule the archive log backup from BRTOOLS at OS level or from DB13 tcode at SAP. Then once the backup is completed then you can see the logs or details in DB12

If its a live or running system take down time and bring the database to ARCHIVE MODE.

checking the current archive mode.

SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE

-

---

NOARCHIVELOG

Now startup the database in mount mode and put it in archivelog mode.

sqlplus sys/passwd as sysdba;

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Oct 15 16:00:58 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area xxxxxx bytes

Fixed Size xxxxxx bytes

Variable Size xxxxxxxx bytes

Database Buffers XXXXX bytes

Redo Buffers XXXXX bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

Verify that whether in ARCHIVELOG mode:

SQL> select log_mode from v$database;

LOG_MODE

-

---

ARCHIVELOG

Note: XXXX are nothing but the value of memory. Just removed the values and have put xxxx

Regards,

Sharath

Edited by: sharath Babu on Jul 9, 2010 2:42 PM

[sunny_pahuja2]

Hi,

Check SAP Note 1081265 - DBACOCKPIT: Backup logs are not displayed

Thanks

Sunny

[Former Member]

Sorry but, why do we set in ARCHIVE mode our system!? The system in this time cannot be shutdown.

The problem is not about the mode of archiving..

We have a lot of system in NO ARCHIVE MODE that is backupped in the same way, without problem.

[Former Member]

Thank you very much for the note, but our system is yet on

SAPKB70014 support package level.

SAP_BASIS 700 0014 SAPKB70014 SAP Basis Component