backup to disk using db13

[stilianos_mavromatidis2]

Hi,

We already take online backup to tape using third party software and we want to change this backup. We want to backup oracle database and archive logs on a disk on another server using db13 (without third party software). We want to take an online backup.

We have created a mapped network drive (Z: is the drive letter) on sap database server (windows) that points to a shared folder on a remote server disk (windows).

We have changed the following parameters in init<SID>.sap file:

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = disk

backup_root_dir = z:\

compress = yes

do we have to change some other parameter in init<SID>.sap file before we configure db13 to backup Whole database online + redo log backup?

do we have to change any of the following parameters in init<SID>.sap file?

stage_root_dir

compress_cmd

uncompress_cmd

compress_dir

archive_function

archive_copy_dir

archive_stage_dir

Thanks in advance.

[Former Member · Accepted solution]

Hi,

Make the following modifications and trigger an online backup.

archive_copy_dir = /oracle/<SID>/sapbackup

archive_function = second_copy_delete

compress_dir = /oracle/<SID>/sapreorg

Let us know if you face any issue.

Br,
Venky

[stilianos_mavromatidis2 · Accepted solution]

Hi,

We have configured the init<SID>.sap file as mentioned above but when we run the backup (database+logs) it fails with the following log:

BR282E Directory Z: not found

BR182E Checking parameter/option 'backup_root_dir' failed

BR165E Parameter 'compress_cmd' is not set in E:\oracle\<SID>\920\DATABASE\init<SID>.sap

BR056I End of database backup: bekcexkq.log 2012-12-14 11.2

BR280I Time stamp 2012-12-14 11.22.29

BR054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

Drive letter Z is a map network drive.

what can be wrong?

Do we have to configure "compress_cmd" in .sap file?

What value "compress_cmd" must have?

Thanks.

[Former Member · Accepted solution]

HI,

Set the below parameters and try again

compress_dir = Z:

archive_copy_dir = Z:

Regards,

Lakshmi

[stilianos_mavromatidis2 · Accepted solution]

Hi,

The problem was that we put only the drive letter on "backup_root_dir" parameter.

We put Z:\backup as "backup_root_dir " parameter and it works.

The problem now is that we are trying to do this in our production system.

The production system has a windows cluster.

We have created the Z: map netwrok drive on one node of the cluster, we have changed the init.sap file as in development system but we get the error:

Directory Z:\PRD_backup_v not found

can someon help?

[Former Member · Accepted solution]

can you please attach the entire initSID.sap file?

[stilianos_mavromatidis2 · Accepted solution]

Hi,

this is the initSID.sap file.

It works fine for development system but not in PRD system that has windows cluster.

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = disk

backup_root_dir = Z:\PRD_backup_v

stage_root_dir = Z:\PRD_backup_v

compress = no

archive_function = save

archive_copy_dir = Z:\PRD_backup_v\archives

expir_period = 1

[Former Member · Accepted solution]

Thanks .

  Are you sure that Z:\drive can be acccessed by sidadm?

PLease login as sidadm and try to create a test file and check whther it getting created.

Try to remove _  just a plain name like PRDBACKUP  and try again...

Sometimes _ wont be taken.. it will be considered as space...

[stilianos_mavromatidis2 · Accepted solution]

we have allready tried this, prdadm has full control on this folder.

[former_member188883 · Accepted solution]

Hi Stilianos,

Change the entry as follows

backup_root_dir = \\<IP address of server where backup folder is create>\PRD_backup

In windows you need to define UNC path instead of Mapped drive Name.

This should work.

Regards,

Deepak Kori

[stilianos_mavromatidis2 · Accepted solution]

where in widnows do we have to define the UNC path?

What do you mean?

[former_member188883 · Accepted solution]

Hi Stilianos,

Please update this into initSID.sap file following entry.

backup_root_dir = \\<IP address of server where backup folder is create>\PRD_backup

Regards,

Deepak Kori

[former_member185239]

Hi Stilianos,

Maintain the entry as suggested by deepak and also check the function , It should be SD save and delete.

With Regards

Ashutosh Chaturvedi

[paul_power]

Hello Stillianos,

To my knowledge you just need to enter the full path for the remote drive in the initSID.sap for the parameter 'backup_root_dir =//hostname/location'

Check the parameters the person metnions they used in the followig thread:

http://scn.sap.com/thread/3171571

regards,

Paul