cancel
Showing results for 
Search instead for 
Did you mean: 

Backup through script

Former Member
0 Kudos

Is there any script to schedule backup ,daily for linux system for sap oracle database.

for eg

Enter the daily schedule every night at 11:30 PM, you would enter:

#sudo crontab -e

@daily 30 23 * * * /usr/sap/<sid>/SYS/exe/run/brbackup -p init<sid>.sap -d disk -t online -m all -k yes -e 0 -1 E -u /

If there is any other script to schedule backup daily for sap in linux system.

Thanks in advance,

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182657
Active Contributor
0 Kudos

Hi,


So, want to know the script for scheduling backup daily.

Yes there is no OS script to take SAP level backup,as already suggested by

there is "no" script to run a backup.

For daily scheduling / backup yes there could be scripts but only available with third party backup tools (For exp .Symantec Veritas Net backup ). Tool itself have scripts for both online,offline SAP backup daily scheduling can be operated through Symantec NB.

Hope this will help you.

Regards,

Former Member
0 Kudos

I have tried to use db13 and got the error .

I have taken backup with BRTools and it is worked fine with successfully completed.

But when i am trying to schedule with db13 in linux with options available it is through error.

I have used "whole database online +redo log backup" and used thed options like "using DBVERIFY" or "standard verify" for BRBACKUP backup verification and Options for Redo log Backup(BRARCHIVE) used "standard verify"

Thanks in advance.

former_member207186
Contributor
0 Kudos

Hi,

Regarding this "ORA-01031:insufficient privileges" issue, you can re-execute  the sapconn_role.sql and sapdba_role.sql as per SAP Notes 134592 and 480266. Please also check SAP Note1028220 and ensure that BR*Tools permissions are set correctly as per SAP Note 113747 and update us on the status of the issue.

Regards,

Bíborka

former_member207186
Contributor
0 Kudos

Hi,

Regarding this "insufficient privileges" issue, you can also check SAP Notes

776505 - "ORA-01017/ORA-01031 in BR*Tools on Linux and Solaris 11"

700548 - "FAQ: Oracle authorizations"

562863 - "FAQ: Logon mechanisms"

Regards,

Bíborka

0 Kudos

why don't you use the DB13 transaction?

Former Member
0 Kudos

I did use DB13 transaction for EHP4 Unix server but want to use script for EHP7 linux server.

So, want to know the script for scheduling backup daily.

0 Kudos

indranil roy wrote:

I did use DB13 transaction for EHP4 Unix server but want to use script for EHP7 linux server.

So, want to know the script for scheduling backup daily.

but why?

there is "no" script to run a backup.

you have a command line, like the one you have written, that you adapt to your needs.

then you schedule that command as you like. in unix typical is with cron