on 03-17-2010 10:49 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> 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.
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
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.
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
>
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> 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.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.