Skip to Content

backup to disk using db13

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 14, 2012 at 11:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2012 at 11:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 25, 2013 at 10:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded