ERROR- "Full database offline + redo log backup"

[Former Member]

Hi,

In DB13 when I am scheduling u201CFull database offline backupu201D, backup is successful. But when I am using u201CFull database offline + redo log backupu201D, the redo log backup is not successful. What might be the cause of the dump?

[Former Member · Accepted solution]

Hi,,

Please see the note 113747 - Permissions for DBA tools BRTools and SAPDBA.pdf for BRTools permission

then also check /oracle/<SID>/sapbackup and /oracle/<SID>/oraarch directory...

it should be like below : (755)

drwxr-xr-x   3 ora<sid>     dba             96 Oct 28 17:26 mirrlogA
drwxr-xr-x   3 ora<sid>     dba             96 Oct 28 17:26 mirrlogB
drwxr-xr-x   3 ora<sid>     dba          19456 Nov 11 14:04 oraarch
drwxr-xr-x   4 ora<sid>     dba             96 Oct 28 17:26 origlogA
drwxr-xr-x   4 ora<sid>     dba             96 Oct 28 17:26 origlogB
drwxr-xr-x   2 ora<sid>     dba             96 Oct 28 15:40 saparch
drwxr-xr-x   2 ora<sid>     dba           3072 Feb  5 01:43 sapbackup
drwxr-xr-x   2 ora<sid>     dba           1024 Feb  4 20:00 sapcheck
drwxr-xr-x  17 ora<sid>     dba           1024 Nov  4 15:33 sapdata1
drwxr-xr-x  13 ora<sid>     dba           1024 Oct 28 15:40 sapdata2
drwxr-xr-x  13 ora<sid>     dba           1024 Oct 28 15:40 sapdata3
drwxr-xr-x  18 ora<sid>     dba           1024 Jan 27 10:54 sapdata4
drwxr-xr-x   7 ora<sid>     dba           1024 Jan 27 15:40 sapreorg
drwxr-xr-x   4 ora<sid>     dba             96 Oct 28 15:40 saptrace

The reason is brbackup or brarchive is not able to read log and archive directories.

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi Rajesh,

Thanks for the note that you refer. I want to let you know when I am trying with "Full database offline + redo log backup", the BRBACKUP is successful and I can read log and archive directories(oracle\<SID>\sapbackup). But the BRARCHIVE is not successful and the detail log is not available also. I have checked the oracle\<SID>\ oraarch folder and it contains nothing. I am using <sid>adm id in os level. Please help me out.

Thanks in advance

Nabarun

[Former Member · Accepted solution]

Hi,

You should use BRTOOLs as ora<sid> not as <sid>adm on OS level.

Actually DB backup runs with "brbackup" and archive backup runs with "brarchive" commands, if I am not wrong...

You can see in DB13 logs after complete backup...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

HI Rajesh,

I agree with you. But I have no probs with BRBACKUP. The prob is that I canu2019t get the BRARCHIVE. Please guide me how can I get both of these successfully. The only ID I have <sid>adm. I think I have to work something in OS level. But what kind of changes I need to made?

[Former Member · Accepted solution]

Hi,

You can check in /etc/passwd file for user ora<sid> existance..

Login as a ROOT and give the below command.

#cat /etc/passwd

OR

#cat /etc/passwd | grep ora<sid>

Your output will be similar to below line..

ora<sid>:R3iN6wIcDd67M:114:108:SAP Database Administrator:/home/ora<sid>:/bin/csh

It must be their, as oracle is installed... (Oracle must be installed as a ora<sid> user...)

If you don't remember password of ora<sid>, you can change it with below command.

#passwd ora<sid>

It will ask you for new password... repeat again to confirm.

Then log in as ora<sid> and run BRTOOLs...

It will work...

Regards.

Rajesh Narkhede

[JPReyes · Accepted solution]

Did you follow the instructions on SAP Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

Regards

Juan

[Former Member]

Hi,

check the below links and notes.

Note 17163 - BRARCHIVE/BRBACKUP messages and codes

Regards,

Ravi

[Former Member]

Hi,

Let us know whats the database and also the error log you are receiving.

Regards,

Ravi

[Former Member]

Hi Ravi,

We are using oracle database. The return code for BRBACKUP is "0000 Success" but the return code of BRARCHIVE is "0003 Error during initialization". The system could not read the detail log file of BRARCHIVE.

[Former Member]

Hi goto detail logs and check what error is there?

log with proper reason would be written there.

tell those logs.

Regards,

Priya

[Former Member]

Hi,

When I am clicking on the Detail Log a popup comes with the message <Could not read detail log aecmgwvr.log>.

[nirmal_konchada]

permission issues in /oracle/<SID>/brarchive

nirmal.