Question Re: DB13 Online Backup in Technology Q&A

DB13 Online Backup

Former Member — Thu, 16 Oct 2008 06:42:45 GMT

Hi,

I am taking daily online backup from BRTOOLS on a disk(BACKUP SEVER).If I want to take the online backup through DB13 in the disk what is the procedure to be used(step by step)

Server ECC5.0

ORACLE 9.2.0.7.0

Regards

AAA

Re: DB13 Online Backup

Former Member — Thu, 16 Oct 2008 06:52:32 GMT

Hi,

search SDN or help.sap.com

also check http://help.sap.com/saphelp_nw04s/helpdata/en/ff/3b8e6a5e094e57b8eff618e95938a9/frameset.htm

regards,

kaushal

Re: DB13 Online Backup

Former Member — Thu, 16 Oct 2008 09:49:33 GMT

hello,

first you have to change the init<SID> file accordingly, set/change the required parameters (ie. backup_type, backup_dev_type, compress, backup_root_dir etc...) and then schedule the backup job in DB13,

cheers,

-Sunil

Re: DB13 Online Backup

Former Member — Fri, 17 Oct 2008 03:35:04 GMT

Hello AAA,

You have to change some parameters in your backup profile like example these...

backup_dev_type = disk

backup_root_dir = <disk target>

stage_root_dir = <disk target>

But before making changes take a copy backup of that profile. After making changes, when you will schedule backup in DB13, you have to give " disk " in place of tape name.

I think it willl help you.

Regards,

Ankit

Re: DB13 Online Backup

Former Member — Fri, 17 Oct 2008 06:30:57 GMT

Hi Ankit,

Thanks for your reply

During the offline backup which function i have to select

like -cds without deleting any old archive files in the SAP server.

Regards

AAA

Re: DB13 Online Backup

Former Member — Sun, 19 Oct 2008 08:47:12 GMT

Hi AAA,

Select -CDS option only

Cds option to be select (Copy, save and delete)

Thanks,

Bhanu Pratap Singh

Re: DB13 Online Backup

Former Member — Tue, 21 Oct 2008 08:57:57 GMT

Hi Bhanu,

Thanks for your reply.

When i tried with option -cds, system shows the error like

option '-cds' not supported for"disk".

Please let me know which option to be seleted without deleting old archive files in sap server

-s Create the first copy of offline redo log files

-sd Create the first copy and delete

-ss Create the first and the second copy in parallel

-ssd Create the first, second copy in parallel and delete

-sc Create the second copy of offline redo log files

-scd Create the second copy and delete

-cs Create the second and the first copy serial

-cds Create the second copy, delete and the first copy serial

-ds Delete the offline redo log files after the first copy

-dc Delete the offline redo log files after the second copy

Regards

AAA

Re: DB13 Online Backup

Former Member — Tue, 21 Oct 2008 09:48:57 GMT

-cds not supported for disk, please select -sd Create the first copy and delete

cheers,

-Sunil

Re: DB13 Online Backup

Former Member — Thu, 23 Oct 2008 04:28:10 GMT

Hello All,

I have changed the follwing parameters in the initSID.sap profile

backup_dev_type = disk

backup_root_dir = <disk target>

stage_root_dir = <disk target>

After making changes, i schedule backup in DB13 and type

" disk " in place of tape name.

It is working fine in IDES but not working in Development system.

it is showing the below error log

Job started

Step 001 started (program RSDBAJOB, variant &0000000000013, user ID BASIS)

Execute logical command BRARCHIVE On host EFLTDS

Parameters: -u / -c force -p initEFD.sap -sd -v "DISK"

BR0002I BRARCHIVE 6.40 (15)

BR0282E Directory
Eflbackup\BACKUP\DEVBACKUP\sapbackup not found

BR0182E Checking parameter/option 'archive_copy_dir' failed

BR0007I End of offline redo log processing: adzbxsem.log 2008-10-22 11.30.36

But i am taking the backup by BRTOOLS in development system,it is working fine.

Waiting for reply.

Warm Regards

AAA

Re: DB13 Online Backup

Former Member — Thu, 23 Oct 2008 05:12:08 GMT

Hi,

===========================================================

BR0282E Directory
Eflbackup\BACKUP\DEVBACKUP\sapbackup not found

BR0182E Checking parameter/option 'archive_copy_dir' failed

===========================================================

Please check whether "sapbackup" directory is there are not and also check

"archive_copy_dir" is pointing to which directory in initSID.sap

Regards,

Naresh Sadu

Re: DB13 Online Backup

Former Member — Fri, 24 Oct 2008 07:38:16 GMT

Hi,

===========================================================

BR0282E Directory
Eflbackup\BACKUP\DEVBACKUP\sapbackup not found

BR0182E Checking parameter/option 'archive_copy_dir' failed

===========================================================

Please check whether "sapbackup" directory is there are not and also check

"archive_copy_dir" is pointing to which directory in initSID.sap

I have checked above parametres in initSID.sap and all are ok.

The job status also showing completed ,when i checked in

display log its showing the above error.

It is working fine by BRTOOLS but i need DB13 backup.

Regards,

AAA

Re: DB13 Online Backup

Former Member — Fri, 24 Oct 2008 09:09:22 GMT

>BR0282E Directory
Eflbackup\BACKUP\DEVBACKUP\sapbackup not found

>BR0182E Checking parameter/option 'archive_copy_dir' failed

The server Eflbackup is local or network? if this is on network then could you please try to map as drive and modify the initSID.sap file and retry backup in DB13?

cheers,

-Sunil

Re: DB13 Online Backup

Former Member — Fri, 24 Oct 2008 09:25:13 GMT

Hi,

Thanks for your reply.

EFLBACKUP is in network(for backup) and already mapped as drive in initSID.sap(DEV)

The following parameters are already available in initSID.sap

backup_dev_type = disk

backup_root_dir =
Eflbackup\BACKUP\DEVBACKUP\sapbackup

stage_root_dir =
Eflbackup\BACKUP\DEVBACKUP\sapbackup

archive_copy_dir =
Eflbackup\BACKUP\DEVBACKUP\sapbackup

Waiting for your reply

Regards

AAA

Re: DB13 Online Backup

Former Member — Fri, 24 Oct 2008 09:34:49 GMT

can you please map the network drive on your server for example as P:\

then change all the parameters as

backup_root_dir = p:\BACKUP\DEVBACKUP\sapbackup

cheers,

-Sunil

Re: DB13 Online Backup

Former Member — Fri, 24 Oct 2008 09:47:17 GMT

Hi Sunil,

The backup drive already mapped as

sapbackup on 'EFLBACKUP\BACKUP\DEVBACKUP(Z:)

in DEV server.Also i am taking online backup through BRTOOLS in DEV.

The same settings are working fine in IDES by DB13.

Warn Regards,

AAA

Re: DB13 Online Backup

Former Member — Fri, 24 Oct 2008 09:53:38 GMT

hm!, can you check whether the folder 'sapbackup' available under
Eflbackup\BACKUP\DEVBACKUP\

and can you able to access the path
Eflbackup\BACKUP\DEVBACKUP\sapbackup from your database server?

cheers,

-Sunil

Re: DB13 Online Backup

Former Member — Fri, 24 Oct 2008 10:39:20 GMT

Hi Sunil,

The folder 'sapbackup' available under
Eflbackup\BACKUP\DEVBACKUP\

and I am able to access the path
Eflbackup\BACKUP\DEVBACKUP\sapbackup from DEV server.

Regards,

AAA

Re: DB13 Online Backup

Former Member — Fri, 24 Oct 2008 14:02:26 GMT

are you able to access this folder with user SAPservice[SID] ? this is the user that DB13 uses for Os authentication.

Re: DB13 Online Backup

Former Member — Sat, 25 Oct 2008 04:09:17 GMT

Hi,

Thanks for you reply.

Could you please explain how to access this folder with user SAPserviceSID for Os authentication.

OS WIN 2003

ORACLE 9.2.0.7.0

ECC 5

Regards

AAA

Re: DB13 Online Backup

Former Member — Sat, 25 Oct 2008 17:44:54 GMT

logout from Windows,

log back in using user SAPservice[SID] (where you replace [SID] with your SID).