Database backup problem in DB13

[Former Member]

Dear All,

<b>When we take backup from the command prompt using Brbackup or Brarchive it executes the backup process successfully, but when I schedule the same thing in the DBA calendar it shows that job finished but it actually does not take the backup. I have given all parameter required for the backup in the DBA calendar like eg, the scheduled time, the tape generic name, archive type.</b>

Can anybody guide what is going wrong ...because of that I am not able to schedule backup using DB13 tcode.

At present I am using Brtools( Brbackup) to take the backup.

Thanks in adv.

Bhaskar

[andreas_herzog · Accepted solution]

-> sap release?

-> brtools release?

-> any error message?

-> log files?

GreetZ, AH

[Former Member · Accepted solution]

Dear Andreas Herzog ,

Thanks for the reply.

I am using:

BRTOOLS release 7.00(13)

SAP ECC 6.0.

This is log file :-

Job log

Job started

Step 001 started (program RSDBAJOB, variant &0000000000075, user ID CORETEAM)

Execute logical command BRBACKUP On host sappro

Parameters:-u / -jid FLLOG20070713171348 -c force -t online -m full -p initMRP.sap -v SCRATCH -a -c force -p in

itMRP.sap -cds

BR0051I BRBACKUP 7.00 (13)

BR0055I Start of database backup: bdvrrffc.fnt 2007-07-13 17.15.20

BR0252W Function remove() failed for 'E:\oracle\MRP\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file E:\oracle\MRP\102\database\initMRP.ora - default assumed

BR0165E Parameter 'control_file_record_keep_time'is not set in E:\oracle\MRP\102\database\initMRP.ora

BR0056I End of database backup: bdvrrffc.fnt 2007-07-13 17.15.21

BR0280I BRBACKUP time stamp: 2007-07-13 17.15.21

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

Thanks

[Former Member]

can you please check the Security Settings for.

1: %ORACLE_HOME%\database. you need to include a group where your SAPServiceMRP user is member in (ORA_MRP_DBA, ORA_MRP_OPER, SAP_MRP_LocalAdmin) with full access.

2: repeat the same for the oraarch directory.

peter

[Former Member]

Dear Mr. Peter,

Thanks for your reply.

Could you please guide me how to do that. This has to be checked at database level or at OS level.

Please suggest me...

Thanks

[Former Member]

interesting, somebody a little familiar with SAP/Oracle administration will normaly know, that I was talking about operating system level.

SAPServiceMRP is a operating system user, ORA_MRP_DBA, ORA_MRP_OPER, SAP_MRP_LOCALADMIN are operating system groups created by sapinst during the installtion.

If you are not able to handel security settings on file system level, you should better first visit a windows administrations course before starting complex stuff like adminstrating SAP systems or Oracle databases.

regards

Peter

[Former Member]

Dear Peter,

I have checked the user group for SAPServiceMRP, it belongs to following groups:

Backup Operators

ORA_MRP_DBA

ORA_MRP_OPER

SAP_Localadmin

SAP_MRP_Globaladmin

SAP_MRP_Localadmin

Thanks

[sivakumar_kilari3]

Hi

in DB13 they run under SAPService<SID>, you need configure the file access permissions for this account too

Regards

siva

<Post was moderated>

[Former Member]

well that is fine,

what are defined in the Security Setting of folder %ORACLE_HOME%\database?

Peter

[Former Member]

Dear Peter,

My oracle home directory is E:\oracle\MRP\102

Earlier %ORACLE_HOME%\database was having following Groups/user names:

1 Administrators

2 Authenticated Users

3 SYSTEM.

Now I have added

1 MRPADM

2 SAPServiceMRP

After adding these to user, I started backup in DB13 immediately. It has started taking backup of the data file.

But I see some warning messages in the initial line of the action logs.

Which is :-----

BR0051I BRBACKUP 7.00 (13)

BR0055I Start of database backup: bdvspucy.ant 2007-07-18 17.13.48

BR0252W Function remove() failed for 'E:\oracle\MRP\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file E:\oracle\MRP\102\database\initMRP.ora - default assumed

BR0274W File 'E:\oracle\MRP\102\database\CTL1MRP.ORA' not found

BR0280I BRBACKUP time stamp: 2007-07-18 17.14.00

BR0319I Control file copy created: G:\oracle\MRP\sapbackup\CNTRLMRP.DBF 20103168

It is giving warning as permission denied, but both the user (eg mrpadm and sapservicemrp) have the access to the folder.

Is there anything to worry.

Thanks for your cooperation and support

Bhaskar

[Former Member]

and this is exactly what I asked you two replies above:

SAPServiceMRP is not member of Administrators (but MRPadm is).

Therefore it is a common practice not to add the User but a group in which SAPServiceSID is member of to the ACL of the database directory.

This would be one or two of the groups I already listed.

there are different scopes possible for Windows Security.

You can define a security setting to be inherited by underlying directories and files and subfolders, as well as neary any combination of them. see security tab's Advanced button.

Depending on the security settings you choosed and the one existing at the time when sap.ora was created you may need to set the security also on sap.ora.

regards

Peter

[Former Member]

Thanks A lot.

Thanks for your support..... I have recently joined this company I need to check it.

[fidel_vales]

Operating system?

If you are in Windows, taking a backup at OS level means nothing

-> OS level -> user <SID>adm

-> DB13 -> User SAPService<SID>

If you are in Unix, what user have you used to perform the backup at OS level? There are two posibilities

-> ora<SID>

-> <SID>adm

DB13 uses -> <SID>adm

If you use the first one to test the backup, you also get a not valid test

[Former Member]

Dear Mr. Fidel,

Thanks for your reply.

My operating system is Windows 2003.

I am loged in with <SID>adm.

When I use DB13 to schedule the backup (online full database backup) it completes sucussfully......but if I choose to schedule backup(online full database + redo logs file) after taking backup of the database when it to take redo logs file give an error message as:-----

<b>I am giving lines where the error occurs...</b>

BR0280I BRBACKUP time stamp: 2007-06-27 19.32.19

BR0063I 43 of 43 files processed - 120279.500 MB of 120279.500 MB done

BR0204I Percentage done: 100.00%, estimated end time: 19:32

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2007-06-27 19.32.23

BR0340I Switching to next online redo log file for database instance MRP ...

BR0321I Switch to next online redo log file for database instance MRP successful

BR0117I ARCHIVE LOG LIST after backup for database instance MRP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination F:\oracle\MRP\oraarch\MRParch

Archive format ARC%S_%R.%T

Oldest online log sequence 3173

Next log sequence to archive 3176

Current log sequence 3176 SCN: 33992945

Database block size 8192 Thread: 1

BR0018I Waiting for the next offline redo log file...

BR0017E Offline redo log file E:\oracle\MRP\102\RDBMS\ARC03175_0603728372.001 not found

BR0056I End of database backup: bdvoqpkp.ant 2007-06-27 19.32.28

BR0280I BRBACKUP time stamp: 2007-06-27 19.32.28

BR0054I BRBACKUP terminated with errors

thanks.