Backup Block Size

[Former Member]

Dear Friends,

We are using HP DLT VS10 tape drive for our Dev system backup.But it is taking too much time to complete the backup(more than18hrs for 80 GB).Our hardware person is telling that by increasing the block size we can solve this problem.Currently we are using the cpio command in init<SID>.sap to copy the files.Can anybody help me in increasing the backup block size ?

Our OS is HP UX 11.11,Oracle 9.2

Thanks in advance,

Joby

[former_member204746 · Accepted solution]

you did not specify which backup tool you are using.

I suspect this to be BRBACKUP as you are talking about initSID.sap.

I would trash CPIO and change this to DD, you backup time should reduce to 25% of actual time as per my experience.

try this first before changing block size.

[Former Member]

Surprisingly I could not find tape_copy_cmd in our init<SID>.sap , can I insert this parameter manually after compress command ?

Thanks,

Joby

[Former Member]

Hi Joby,

Yes, you can add the command manually. This is the syntax:

<b>tape_copy_cmd = [cpio | dd | cpio_gnu | rman | rman_dd]</b>

<i>Default: cpio</i>

If you're using raw devices, this command don't affect (always copied with dd).

Best Regards,

JC Llanes.

[Former Member]

Hi Joby,

Yes, there would be a better performance by increasing block size, by be careful about not to set a big size, this can be a problem when restoring your datafiles.

Take a look at notes 13994 and 334472. I think they can solve your doubts.

Best Regards,

JC Llanes.