DB14: BRBACKUP logs not generating

[Former Member]

Dear Team,

We have an ECC 6.0 Production system.

1--> In DB14 tcode while monitoring the BRBACKUP logs, we could find no logs generated since past 3 days.

Till now its not generating any logs.

2-->We have checked the Redo Log Backups logs, its uptodate till today.

3-->We had no maintainance activity or shutdown of the system.

4-->We have informed our DB team also.But they revert saying 'This is via BR tool and DBA do not have control on this'.

Pleas let us know if there is any setting that we need to look into...

Regards

Imaan

[Former Member · Accepted solution]

Hi,

Are the backup logs being written on the OS level usually under /oracle/<SID>/sapbackup?

Could you check if tables SDBAH and SDBAD are getting updated?

Regards,

Srikishan

[Former Member · Accepted solution]

Hi,
> 
> Are the backup logs being written on the OS level usually under /oracle/<SID>/sapbackup?
> Could you check if tables SDBAH and SDBAD are getting updated?
> 
> Regards,
> Srikishan

Hi,

1. No. we aren't able to see backup logs in /oracle/<SID>/sapbackup.....

2. Yes, tables are getting updated.........

[Former Member]

Hi,

Work around could be BRTOOLS* upgrade.

Regards,

Dinesh

[Former Member]

1)sudo su -  

7)Restart saposcol after saproot.sh has been restarted (saposcol -l -i60) 

8)After installation check the DBCHECK, CLEANUP and UPDATESTAT in DB13 

[Former Member]

Hi,

usually backup logs generating in /oracle/<SID>/sapbackup path . Can you please check the alert<sid>.log file any issues in database. and please chek the /oraarch files also is it archived successfully or not day by day.

may i know , any third party backup tools are you using ??

regards,

balaram

[Former Member]

Hi,
> 
> usually backup logs generating in /oracle/<SID>/sapbackup path . Can you please check the alert<sid>.log file any issues in database. and please chek the /oraarch files also is it archived successfully or not day by day.
> may i know , any third party  backup tools are you using ??
> 
> regards,
> balaram

Hi,

1. The last successful backup happened on 6-mar-2012 . we can see backup logs upto 6th march but after that logs aren't generating

2. could you tell me exact path for alert<sid>.log file

3. The redo log archive backup is successfully completed as of date

4. we are taking the backup using BACKINT file.

[Former Member]

Hi,

find below path for alert log. file will be like alert_<DBSID>.log

for Oracle 10g : /oracle/<DBSID>/saptrace/background

for Oracle 11g : /oracle/<DBSID>/saptrace/diag/rdbms/<dbsid>/<DBSID>/trace

Also please let me know if the backup is getting triggered.

Regards,

Venkata S Pagolu

[Former Member]

> Hi,
> > 
> > usually backup logs generating in /oracle/<SID>/sapbackup path . Can you please check the alert<sid>.log file any issues in database. and please chek the /oraarch files also is it archived successfully or not day by day.
> > may i know , any third party  backup tools are you using ??
> > 
> > regards,
> > balaram

>

>

> Hi,

>

> 1. The last successful backup happened on 6-mar-2012 . we can see backup logs upto 6th march but after that logs aren't generating

>

> 2. Here are some logs from alert<sid>.log file

Wed Mar 7 11:23:45 2012

Completed checkpoint up to RBA [0xfb8b.2.10], SCN: 7849883715886

Wed Mar 7 11:23:45 2012

Beginning log switch checkpoint up to RBA [0xfb8e.2.10], SCN: 7849883731013

Wed Mar 7 11:23:45 2012

Thread 1 advanced to log sequence 64398 (LGWR switch)

Current log# 2 seq# 64398 mem# 0: /oracle/PRD/origlogB/log_g12m1.dbf

Current log# 2 seq# 64398 mem# 1: /oracle/PRD/mirrlogB/log_g12m2.dbf

Thread 1 cannot allocate new log, sequence 64399

Checkpoint not complete

Current log# 2 seq# 64398 mem# 0: /oracle/PRD/origlogB/log_g12m1.dbf

Current log# 2 seq# 64398 mem# 1: /oracle/PRD/mirrlogB/log_g12m2.dbf

Wed Mar 7 11:24:00 2012

Completed checkpoint up to RBA [0xfb8c.2.10], SCN: 7849883721236

Wed Mar 7 11:24:00 2012

Beginning log switch checkpoint up to RBA [0xfb8f.2.10], SCN: 7849883735168

Wed Mar 7 11:24:00 2012

Thread 1 advanced to log sequence 64399 (LGWR switch)

Current log# 3 seq# 64399 mem# 0: /oracle/PRD/origlogA/log_g13m1.dbf

Current log# 3 seq# 64399 mem# 1: /oracle/PRD/mirrlogA/log_g13m2.dbf

Wed Mar 7 11:24:11 2012

Thread 1 cannot allocate new log, sequence 64400

Checkpoint not complete

Current log# 3 seq# 64399 mem# 0: /oracle/PRD/origlogA/log_g13m1.dbf

Current log# 3 seq# 64399 mem# 1: /oracle/PRD/mirrlogA/log_g13m2.dbf

Wed Mar 7 11:24:12 2012

Completed checkpoint up to RBA [0xfb8d.2.10], SCN: 7849883726339

Wed Mar 7 11:24:12 2012

Beginning log switch checkpoint up to RBA [0xfb90.2.10], SCN: 7849883739909

Wed Mar 7 11:24:12 2012

Thread 1 advanced to log sequence 64400 (LGWR switch)

Current log# 4 seq# 64400 mem# 0: /oracle/PRD/origlogB/log_g14m1.dbf

Current log# 4 seq# 64400 mem# 1: /oracle/PRD/mirrlogB/log_g14m2.dbf

Thread 1 cannot allocate new log, sequence 64401

Checkpoint not complete

Current log# 4 seq# 64400 mem# 0: /oracle/PRD/origlogB/log_g14m1.dbf

Current log# 4 seq# 64400 mem# 1: /oracle/PRD/mirrlogB/log_g14m2.dbf

Wed Mar 7 11:24:25 2012

Completed checkpoint up to RBA [0xfb8e.2.10], SCN: 7849883731013

Wed Mar 7 11:24:25 2012

Beginning log switch checkpoint up to RBA [0xfb91.2.10], SCN: 7849883743945

Wed Mar 7 11:24:25 2012

Thread 1 advanced to log sequence 64401 (LGWR switch)

Current log# 1 seq# 64401 mem# 0: /oracle/PRD/origlogA/log_g11m1.dbf

Current log# 1 seq# 64401 mem# 1: /oracle/PRD/mirrlogA/log_g11m2.dbf

Wed Mar 7 11:24:39 2012

Thread 1 cannot allocate new log, sequence 64402

Checkpoint not complete

Current log# 1 seq# 64401 mem# 0: /oracle/PRD/origlogA/log_g11m1.dbf

Current log# 1 seq# 64401 mem# 1: /oracle/PRD/mirrlogA/log_g11m2.dbf

Wed Mar 7 11:24:40 2012

Completed checkpoint up to RBA [0xfb8f.2.10], SCN: 7849883735168

Wed Mar 7 11:24:40 2012

Beginning log switch checkpoint up to RBA [0xfb92.2.10], SCN: 7849883749377

Wed Mar 7 11:24:40 2012

Thread 1 advanced to log sequence 64402 (LGWR switch)

Current log# 2 seq# 64402 mem# 0: /oracle/PRD/origlogB/log_g12m1.dbf

Current log# 2 seq# 64402 mem# 1: /oracle/PRD/mirrlogB/log_g12m2.dbf

>

> 3. The redo log archive backup is successfully completed as of date

>

> 4. we are taking the backup using BACKINT file.

[Former Member]

Hi,
> 
> find below path for alert log. file will be like alert_<DBSID>.log
> 
> for Oracle 10g : /oracle/<DBSID>/saptrace/background
> for Oracle 11g : /oracle/<DBSID>/saptrace/diag/rdbms/<dbsid>/<DBSID>/trace
> 
> Also please let me know if the backup is getting triggered.
> 
> Regards,
> Venkata S Pagolu

Hi,

Backup was triggered upto 6th march, but after that no triggering, logs etc visible from SAP/OS level....

[Former Member]

Hi,

Can I know how you are triggering backup. if possible can you please provide the full backup command you are using to trigger your backup.

As you said that you are triggering backup using backint directly, you can't see the logs in db14.

DB14 logs are only or brtools. if you run backup using brtools they will be visible in db14.

SAP recommends using BRTools for such kind of things to avoid errors and malfunctions.

why are you not using brtools for backup. brtools also calls backint to perform the backup.

Regards,

Venkata S Pagolu