Define Oracle back up to the external medium

[Former Member]

Hi,

I would like to set up back up for my Oracle DB on the external medium (FTP)?

How can I proceed, which parameters should be set in the init<DBSID>.sap ?

backup_dev_type = stage

archive_stage_dir

remote_host

How can I set “remote user and his password and check that <SAPSID>adm and SAPService<SID> have write access to the external medium?

[fidel_vales]

Hi,

Perhaps here you can find the information:

<a href="http://help.sap.com/saphelp_nw70/helpdata/en/87/e4eb7c2cc35242a01ae5f592df71af/frameset.htm">Backup to a Remote Disk</a>

You are using FTP.

I do not think <SAPSID>adm and SAPService<SID> need write access. Remember that you are connecting to the external medium with a <i><b>remote user.</b></i>

[Former Member]

Hi!

Thank you!

What are all the parameters do I edit in the init<DBSID>.sap?

What is e.g. the difference between <b>stage_root_dir</b> and <b>archive_stage_dir</b> ?

What is the spelling of remote_user?

I do not think that I do not to give the special user who has the access to the FTP-share, because otherwise the connection will not be established.

<b>remote_user = user password or user/password</b> ?

Thank you

regards

[fidel_vales]

Ok,

Lets check the documentation:

<i>

<b>stage_root_dir</b>

This parameter identifies the directories used by BRBACKUP to back up database backups to a remote disk. In exceptions (for example, no definition of the parameter archive_stage_dir), BRARCHIVE also uses the directories defined in this parameter if remote disk backup is required

<b>archive_stage_dir</b>

This parameter identifies the directory used by BRARCHIVE to back up the offline redo log files to a remote disk</i>

So, <b>archive_stage_dir</b> for the archive log files and <b>stage_root_dir</b> for the database ( and archives if the first one is not set )

Now the second part:

<i>

<b>remote_user</b>

Use this parameter to specify the user for a remote host, if you want to make a backup to a remote tape or disk.

Syntax: <b>remote_user = <user></b>

Default: none

If you use the ftp network to transfer data you can also specify the password which BRBACKUP uses to log on to the remote host.

<b>remote_user = "<user> <password>"</b>

If you do not specify a password, BRBACKUP uses the password of the database user. If this is the case, the two user passwords must be the same.</i>

so, lets asume the following

1) remote user is -> fidel

2) password for the remote user -> 123456

in this case you have to do:

<b>remote_user = "fidel 123456"</b>

Finally, all parameters together would be like ( for example )

archive_function = save_delete

archive_stage_dir = "/archlogs"

backup_dev_type = stage

backup_mode = all

backup_type = online

next_max_size = 327680K

remote_host = blablabla

remote_user = "fidel 123456"

stage_copy_cmd = ftp

stage_root_dir = "/dbbackup"

[Former Member]

Hi!

@Fidel

Many thank's for your detailed information.

<b>Are you sure about the spelling of archive_stage_dir and stage_root_dir?

I would intepret the values as archive_stage_dir=dbbackup

What is about remote user speling

(perhaps <u>remote_user = Henke pass</u>)</b>

<i>archive_function = save_delete

archive_stage_dir = "/archlogs"

backup_dev_type = stage

backup_mode = all

backup_type = online

next_max_size = 327680K

remote_host = blablabla

remote_user = "fidel 123456"

stage_copy_cmd = ftp

stage_root_dir = "/dbbackup"</i>

[fidel_vales]

Hello,

It is a very long time I have used it.

You could be correct about the archive_stage_dir and stage_root_dir.

I think it takes the string you pass and it changes to the directory.

Both will be good.

In my case it changes to the absolute path "/archlogs"

In your case it changes to the relative path "dbbackup"

with the user, I'm pretty sure I used it in the format I mentioned.

The only thing I can say is that you test both