brarchive configuration for a scp second copy

[benoit-schmid]

Hello,

Could someone provide me an example of a configuration with a second copy through scp.

Basically I am running:

brarchive -sd -c -f 1 -u / -p <SID>brarchiveinit.sap

The current single copy is sent on a networker interface with backint.

I am going to run:

brarchive -ssd -c -f 1 -u / -p <SID>brarchiveinit.sap

I would like to know the lines that I should add to <SID>brarchiveinit.sap so that

the second copy is a scp on useridATcopyhost.unige.ch.

I have not found that many documentation for that except ones that shows that it is possible.

Thanks in advance for your help.

[volker_borowski2 · Accepted solution]

Hi,

"-ssd" to two diffrent device-types will not work at all.

You can use it to backup to two diffrent tape-drives at the same time.

you need to do

-s -d tape

and in a second run

-scd -d disk

and use "scp" as the disk_copy_cmd

Hope this helps

Volker

[benoit-schmid · Accepted solution]

>

> Hi,
> 
> "-ssd" to two diffrent device-types will not work at all.
> You can use it to backup to two diffrent tape-drives at the same time.
> 
> you need to do 
> 
> -s -d tape
> 
> and in a second run
> 
> -scd -d disk
> 
> and use "scp" as the disk_copy_cmd
> 
> Hope this helps
> Volker

Hello Volker,

Thanks for the precision on tape and disk difference.

1. Concerning -d disk and -d tape, do you agree that I can configure this in the init file?

I need more than specifying scp as disk_copy_cmd because I need to specify the destination

(1) hostname, (2) directory and (3) userid.

2. How do I configure this?

3. If you have a pointer to a doc on this point I am interested.

Thanks in advance for your help.

[volker_borowski2 · Accepted solution]

Hi again,

> 1. Concerning -d disk and -d tape, do you agree that I can configure this in the init file?

No, you can only configure ONE backup_device_type in one initSID.sap.

So either you need to do one call with -d to overrule or use -p to specify

diffrent initSID.sap files i.e. initSID.sap.tape & initSID.sap.disk

> I need more than specifying scp as disk_copy_cmd because I need to specify the destination

> (1) hostname, (2) directory and (3) userid.

> 2. How do I configure this?

Yup, sorry: -d disk is for a local copy. You'd need to specify -d stage to specify

a remote copy. Which would require to set parameters: (see link below)

remote_host

remote_user

backup_dev_type

stage_copy_cmd

archive_stage_dir

Your scp connection to the target needs to authenticate without a prompt, so with scp

you need to set up a key pair with no passphrase for scp or use rcp with .rhost authentication (not secure)

> 3. If you have a pointer to a doc on this point I am interested.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/14/5f0540a054e469e10000000a155106/frameset.htm

Good luck

Volker

[benoit-schmid · Accepted solution]

Good afternoon Volker,

Thanks for sharing your knowledge of brarchive.

I had missed several points.

>

> Hi again,

>

> > 1. Concerning -d disk and -d tape, do you agree that I can configure this in the init file?

>

> No, you can only configure ONE backup_device_type in one initSID.sap.

> So either you need to do one call with -d to overrule or use -p to specify

> diffrent initSID.sap files i.e. initSID.sap.tape & initSID.sap.disk

>

To be sure that I understand well, could you please confirm that I can not do it with a single brarchive process?

If yes can I run these processes in background with the -c -f 1 options.

> Yup, sorry: -d disk is for a local copy. You'd need to specify -d stage to specify

> a remote copy. Which would require to set parameters: (see link below)

>

> remote_host

ok my remote hostname

> remote_user

ok my remote username

> backup_dev_type

What is it for an scp?

> stage_copy_cmd

What is it?

> archive_stage_dir

Is the path on the remote hostname?

>

> > 3. If you have a pointer to a doc on this point I am interested.

>

> http://help.sap.com/saphelp_nw70ehp1/helpdata/en/14/5f0540a054e469e10000000a155106/frameset.htm

This doc really lacks examples.

Thanks in advance for your answer.

[volker_borowski2 · Accepted solution]

Good (late) evening back to you

> To be sure that I understand well, could you please confirm that I can not do it with a single brarchive process?

> If yes can I run these processes in background with the -c -f 1 options.

confirmed, you need two seperate runs to backup to two diffrent device-types

> > backup_dev_type

> What is it for an scp?

stage

> > stage_copy_cmd

> What is it?

scp / ftp or rcp

> > archive_stage_dir

> Is the path on the remote hostname?

yes

> > http://help.sap.com/saphelp_nw70ehp1/helpdata/en/14/5f0540a054e469e10000000a155106/frameset.htm

> This doc really lacks examples.

true, but you'll have to work through it anyway.

My be you should start a bit higher in the navigation tree on the left like

database backup / backup methods / backup to a remote disks.

In that conceptional area there are even some pics to explain details.

The link was mere to direct you to the brarchive section directly.

Volker

[benoit-schmid · Accepted solution]

Good afternoon,

I will try this thanks for your help.

[ashish_mishra2]

>

> I would like to know the lines that I should add to <SID>brarchiveinit.sap so that

> the second copy is a scp on useridATcopyhost.unige.ch.

Hi,

As per my understanding and interaction with oracle database, I never saw happening SCP through bracrchive.

however if so is happening in your case, please use -cds parameter with brarchive. that might help you.

brarchive -cds -c -f 1 -u / -p <SID>brarchiveinit.sap

Cheers !!!

Ashish

[benoit-schmid]

>

> As per my understanding and interaction with oracle database, I never saw happening SCP through bracrchive.

> however if so is happening in your case, please use -cds parameter with brarchive. that might help you.

If you look at http://help.sap.com/saphelp_nwpi71/helpdata/en/46/ad9ab7c5b462d1e10000000a1553f7/content.htm

You can read that:

BRARCHIVE can use reliable copy programs such as rcp, ftp, or scp for the copying of the offline redo log files from the primary host onto the standby host, with the backup_dev_type parameter set to stage. Therefore, NFS-mounting and verification are no longer necessary.

> brarchive -cds -c -f 1 -u / -p <SID>brarchiveinit.sap

>

As far as I understand, -ssd should do both copies in parallel whereas -cds do a save and after a copy.

So -ssd should be faster to copy to both media and more importantly to delete the archive logs.

Thanks in advance for your answer.

[ashish_mishra2]

Interesting and useful information.

Thanks