BW backup failing

[Former Member]

Hello Experts,

BW backup is failing continuously with error 0003 in SAP. Below is the detail log:

File Size Group Device Status Link Type

/oracle/BWP/origlogA/log_g11m1.dbf 52429824 1 1073807379 INUSE NOLINK FILE

/oracle/BWP/mirrlogA/log_g11m2.dbf 52429824 1 1073807381 INUSE NOLINK FILE

/oracle/BWP/origlogB/log_g12m1.dbf 52429824 2 1073807380 INUSE NOLINK FILE

/oracle/BWP/mirrlogB/log_g12m2.dbf 52429824 2 1073807382 INUSE NOLINK FILE

/oracle/BWP/origlogA/log_g13m1.dbf 52429824 3 1073807379 INUSE NOLINK FILE

/oracle/BWP/mirrlogA/log_g13m2.dbf 52429824 3 1073807381 INUSE NOLINK FILE

/oracle/BWP/origlogB/log_g14m1.dbf 52429824 4 1073807380 INUSE NOLINK FILE

/oracle/BWP/mirrlogB/log_g14m2.dbf 52429824 4 1073807382 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/BWP/origlogA/cntrl/cntrlBWP.dbf 13492224 0 1073807379 NOLINK FILE

/oracle/BWP/sapdata1/system_1/cntrl/cntrlBWP.dbf 13492224 0 1073807363 NOLINK FILE

/oracle/BWP/saparch/cntrl/cntrlBWP.dbf 13492224 0 1073807385 NOLINK FILE

BR0066E For online backup, the database must be in ARCHIVELOG mode

BR0056I End of database backup: bebrukye.anf 2009-10-15 22.46.21

BR0280I BRBACKUP time stamp: 2009-10-15 22.46.21

BR0054I BRBACKUP terminated with errors

we have big number of redo logs accumulated because of failed backups.

I think the system will hang any time because of archive full

pls suggest what do I need to change

Edited by: Learning SAP on Oct 16, 2009 6:42 PM

[Former Member · Accepted solution]

Thank you all for your help!

Parameter LOG_ARCHIVE_START is set as true in the system , but when I checked at the OS level , the database was in noarchive mode.

I understood from the notes that the redo logs are not generated in this mode.

I believe that the system has previous logs that were not backed up earlier.

I have taken the offline backup of the system and will discuss it with my seniors to put the database back to archive mode so that it is possible to take the online backup.

Even when I took the offline backup the previous redo logs were not saved and deleted from the system?

This is how it works or the redo should be saved and deleted during the offline backup?

Thanks once again for all of you help!!

[ashish_vikas · Accepted solution]

Hi,

I understood from the notes that the redo logs are not generated in this mode.
I believe that the system has previous logs that were not backed up earlier. 

If your system in no arcive mode, there should not be any new arechivelog. Please verify in oraarch..check date when they got created.

I have taken the offline backup of the system and will discuss it with my seniors to put the database back to archive mode so that it is possible to take the online backup.

Your offline backup is of no use if still databse is running in no archive mode ..you can not perform full recovery as you do not have redos after backup.

Even when I took the offline backup the previous redo logs were not saved and deleted from the system?
This is how it works or the redo should be saved and deleted during the offline backup?

When you perform offlibe databse backup, it will only take backup of datafiles, in offline mode. So it never backups redos..Redos r never deleted by running databse backup. You need to run archive log backup for this.

Also, if you have offline backup and redos of older date, you can safely clean them. Please check with your seniors..

ashish

[Former Member · Accepted solution]

Thanks Ashish

When you perform offlibe databse backup, it will only take backup of datafiles, in offline mode. So it never backups redos..Redos r never deleted by running databse backup. You need to run archive log backup for this.

Also, if you have offline backup and redos of older date, you can safely clean them. Please check with your seniors..

I checked oraarch directory and the last time redo logs were generated was in march.

I have one more question..I was running archive log backup with offline backup but still archive failed

BR0280I BRARCHIVE time stamp: 2009-10-19 11.30.04

BR0229I Calling backup utility...

BR0278I Command output of '/usr/sap/BWP/SYS/exe/run/backint -u BWP -f backup -i /oracle/BWP/saparch/.aebsludt.lst -t file -p /oracle/BWP/102_64/dbs/initBWP_ARCH.utl -c':

ERROR: couldn't open param_file: /oracle/BWP/102_64/dbs/initBWP_ARCH.utl

ERROR: incorrect format or option in .utl file (-p)

BR0280I BRARCHIVE time stamp: 2009-10-19 11.30.05

BR0279E Return code from '/usr/sap/BWP/SYS/exe/run/backint -u BWP -f backup -i /oracle/BWP/saparch/.aebsludt.lst -t file -p /oracle/BWP/102_64/dbs/initBWP_ARCH.utl -c': 2

BR0232E 0 of 637 files saved by backup utility

BR0280I BRARCHIVE time stamp: 2009-10-19 11.30.05

BR0231E Backup utility call failed

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: aebsludt.svd 2009-10-19 11.30.05

BR0280I BRARCHIVE time stamp: 2009-10-19 11.30.05

BR0005I BRARCHIVE terminated with errors

So what I understood is that no matter if you run your archive with offline or online backup it will fail if your database is in no archive mode.

Hope i"m right.

[ashish_vikas · Accepted solution]

Hi,

I checked oraarch directory and the last time redo logs were generated was in march. 

So its clear now, new redos r not getting generated. And now u have to decide if you really need to keep these older files in oraarch ..if yes why ?

Yes, If you are running in no archive log mode, your archivelog backup and online databse backup will fail. However you can take offline back.. please run db in archive log mode only if not business requirement.

Once in archiving mode, immediately take a full consistent backup with regular archivelog backup.

ashish

[Former Member · Accepted solution]

Thank you Ashish for all your help!!

I'll change the database mode back to archive mode.

Thanks again!!

[former_member227283]

Hi,

Login to oracle using sqlplus "/as sysdba"

and paste the output of command :-

archive log list

Thanks

Anil

[Former Member]

Let's try to learn SAP using SAP Notes

Note 17163 - BRARCHIVE/BRBACKUP messages and codes

[Former Member]

Thanks for the note.

IT says "Start the database system with the ARCHIVELOG mode active."

How to check in which mode the database is and to change the databse system to archive mode ?

Thanks for your help!!

[Former Member]

Again, let's take some help from SAP Notes

Note 8438 - Activating/deactivating ARCHIVELOG mode

Note 863417 - FAQ: Database Archive modes and redo logs

[Former Member]

Thanks again for your reply!

I've checked parameter LOG_ARCHIVE_START and it is set as TRUE in the system.

This means that database is in Archive mode.

but I'm still getting the message "BR0066E For online backup, the database must be in ARCHIVELOG mode"

Do I need to chk few more things.

[Former Member]

Restart the database.

[Former Member]

LOG_ARCHIVE_START doesn't mean that database is in ARCHIVE mode

'Do I need to chk few more things'

Yes, obviously !

Let's Read the Points 07 & 08 of 'Note 863417 - FAQ: Database Archive modes and redo logs' thoroughly

[ashish_vikas]

Hi,

If your DB is running in no archive mode, how can new archive logs are accumulating .. please check there should not be any new off line redo log file in /oracle/SID/oraarch. If you have quite old log files, you can clean them as they are not useful for you as you are already running system in no archive mode.

I f you are new to SAP/oracle, i would suggest you to use BRTOOLS to change parameters in system. Using brtools also you can eaisly changed to archiving mode for database.

Call BRTOOLS and choose Instance management u2192 Instance

status (confirm twice with “continue”).

Information about the status of database instance DEV

1 - Instance number (number) ........... 1

2 - Instance thread (thread) ........... 1

3 - Instance status (status) ........... OPEN

4 - Instance start time (start) ........ 2009-10-11 12.14.00

5 - Oracle version (version) ........... 10.2.0.2.0

6 - Database creation time (create) ....

7 - Last resetlogs time (resetlogs) ....

8 - Archivelog mode (archmode) ......... NOARCHIVELOG

9 - Archiver status (archiver) ......... STOPPED

10 - Current redolog sequence (redoseq) . 54

11 - Current redolog SCN (redoscn) ...... 2123

12 - Number of SAP connections (sapcon) . 0

Call BRGUI or BRTOOLS and choose Instance management u2192 Alter

database instance u2192 Set archivelog mode.

Your database instance will be stopped and restarted into mount state, archive log mode will be turned on, and the database will be opened.

ashish