cancel
Showing results for 
Search instead for 
Did you mean: 

ARCHIVELOG back-up issue

Former Member
0 Kudos

Hi,

Recently, I have been bugged by a peculiar problem.

My system particulars:

OS: Solaris.

DB: Oracle

SAP: ECC 6.0 A+J

I have been taking archivelog backups regularly with no hassle. but previous day, when I took archive backup the BRARCHIVE throws a message that there is no files found for back-up.

I checked the ORAARCH and found 2 files registered for 25th Jan 2011, but they are not getting backed up.

I am taking an online backup of ARCHIVE LOG as I can't afford to downtime the Java part.

Please help.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you can't afford the downtime then you should be able to schedule the online backup (online_cons) option. If you see there are two archive logs are not getting backup then check then under saparch folder there will be a arch<SID>.log (check the log file name) file where you can see what are the logs backup completed. Have you checked the log numbers are the new logs getting backup?

Former Member
0 Kudos

Yes I've checked the arch<SID>.log and found that the files are not getting backed up.

Please take a look at the arch<SID>.log file...

#

#DISK..... 126 /oracle/BQJ/oraarch/BQJarch1_126_733428330.dbf 2010-11-23 23.23.19 45307392 1983707 1

#DISKSAV.. aefayzmz sve /backup/BQJ/archive/BQJarch1_126_733428330.dbf.Z 2011-01-20 13.17.31 2.4187:1 18732139

#DISKDEL.. ........ ... .......... ........

#DELDISK.. ........ ... .......... ........

#

#DISK..... 127 /oracle/BQJ/oraarch/BQJarch1_127_733428330.dbf 2010-11-25 23.13.39 45318656 2098464 1

#DISKSAV.. aefayzmz sve /backup/BQJ/archive/BQJarch1_127_733428330.dbf.Z 2011-01-20 13.17.38 2.4841:1 18243202

#DISKDEL.. ........ ... .......... ........

#DELDISK.. ........ ... .......... ........

#

#DISK..... 128 /oracle/BQJ/oraarch/BQJarch1_128_733428330.dbf 2010-11-26 09.32.41 9180160 2213406 1

#DISKSAV.. aefayzmz sve /backup/BQJ/archive/BQJarch1_128_733428330.dbf.Z 2011-01-20 13.17.39 2.3644:1 3882718

#DISKDEL.. ........ ... .......... ........

#DELDISK.. ........ ... .......... ........

#

#DISK..... 129 /oracle/BQJ/oraarch/BQJarch1_129_733428330.dbf 2010-11-26 12.34.09 41594880 2229416 1

#DISKSAV.. aefayzmz sve /backup/BQJ/archive/BQJarch1_129_733428330.dbf.Z 2011-01-20 13.17.45 2.9723:1 13994405

#DISKDEL.. ........ ... .......... ........

#DELDISK.. ........ ... .......... ........

#

    • BQJ disk aefayzmz sve 2011-01-20 13.07.25 2011-01-20 13.17.46 0 2.2604:1 36 129 0 0 -kc 7.00 (40) @0733428330

#

    • BQJ disk aefbtjgf sve 2011-01-24 16.35.49 2011-01-24 16.35.49 1 ........... 0 0 0 0 -kc 7.00 (40) @0733428330

#

    • BQJ disk aefbtjsu sve 2011-01-24 16.41.16 2011-01-24 16.41.16 1 ........... 0 0 0 0 -kc 7.00 (40) @0733428330

#

    • BQJ disk aefbtumv sve 2011-01-24 18.42.37 2011-01-24 18.42.38 1 ........... 0 0 0 0 -kc 7.00 (40) @0733428330

#

    • BQJ disk aefbyobr sve 2011-01-25 17.54.51 2011-01-25 17.54.52 1 ........... 0 0 0 0 -kc 7.00 (40) @0733428330

#

Former Member
0 Kudos

Well, the messages given are as follows:

First it reads the BRARCHIVE log file.

Then, it reads the SPFILE.

Then it gives the message..." No offline redo log files found for processing".

I manually performed the log-switch but to no avail.

I have found a SAP Note 490976. Please check the Point no 6. in this note which states:-

"If other warnings or errors occur in the brarchive log in the lines

before BR013W (for example, BR273W, BR382E, BR019W), BR013W is merely

a follow-up error and you must find a cause for the other messages

instead."

As told earlier i am also getting a warning during backup which goes like this :-

BR0335W Status of online redo log file /oracle/BQJ/mirrlogB/log_g12m2.dbf is INVALID

Now this file /oracle/BQJ/mirrlogB/log_g12m2.dbf is there in mirrorlogB and its dated 26-11.

Please Help.

nirmal_konchada
Active Contributor
0 Kudos

Hi,

Are you getting any error now????? Pease try to mention only 1 problem in this post.

You have clubbed 2 issues in a single question. Please read rules of engagement.

Regards,

Nirmal.K

Answers (1)

Answers (1)

former_member184473
Active Contributor
0 Kudos

Hello,

Which is the error message you are getting?

Regards,

Eduardo Rezende