Backup of QAS

[former_member182034]

Dear all,

i am taking backup of DEV, QAS and PRD. The backup of DEV and PRD is completed within 3 Hours, while backup of QAS server consume 10 hours. any one tell me, why QAS is taking to much time.

regards,

jamil

[markus_doehr2]

Without knowing more about your environment everything results just in "wild guesses".

- You use the same type of storage for QA and PRD?

- You are using the same tapes/devices? Other backups sessions running at the same time to the same tape devices?

- Are the sizes of the systems the same?

Markus

[former_member182034]

Hi Markus,

thanks for your replay.

Dear i am taking weekly backup of three server (DEV, QAS,PRD).I take one-by-one backup...because i have only backup drive.... selection of folders are same for each backup.

fyi.... i have made copy of PRD in QAS.

You use the same type of storage for QA and PRD?

yes,

You are using the same tapes/devices? Other backups sessions running at the same time to the same tape devices?

same tapes LTO 200GB (uncompress size),...backup session are not same time

Are the sizes of the systems the same?

QAS:

Oraarch size = 210GB

DATA Files = 109 GB

it takes 12 hours

PRD:

Oraarch = 60 GB

DATA File = 87 GB

it takes 3 hours

regards,

majamil

[markus_doehr2]

>

Are the sizes of the systems the same?

> QAS:

> Oraarch size = 210GB

> DATA Files = 109 GB

> it takes 12 hours

Those are 319 GB

>

> PRD:

> Oraarch = 60 GB

> DATA File = 87 GB

> it takes 3 hours

Those are 147 GB

So I would assume at least a factor of 2.

Are those tapes all connected locally? Or do you backup through the network?

Markus

[former_member182034]

Hi Markus,

thanks for take on.

Dear tape Drive is attach with DEV server and i mapped the partitions of QAS & PRD for the backup.... mean backup of QAS and PRD via network.

regares,

jamil

[markus_doehr2]

Ok.. that´s an explanation.

If you have a 100 Mbit network you can backup (theoretically) 8 MB/sec. Now let´s calculate:

319000 MB / 8.192 = 38940 sec

38940 / 3600 (60 * 60) = 10 hours

So 10 hours is the theoretical maxium. Since this is most likely Ethernet there´s overhead and even more overhead, since you seem to use SMB (network drive mapping).

So - that time is expected.

Markus

[former_member182034]

Thanks Dear Markus for this question and

Daily backup of PRD on DR server

regards,

jamil

[former_member182034]

Thanks Dear Markus for this question and

Daily backup of PRD on DR server

if you don't mind... have a look on Question

Problem with Transaction CKR1

regards,

jamil

[Former Member]

majamal

I would like to know hw you are taking the backup ?

is you backup include the achive log also ?

in that case why don't you take the backup of the data files only in a separate session take the backup of archive log in another session

regards

George

[former_member182034]

Hi George,

sorry for delay,

Dear i m taking the backup of Origlog, Mirrorlog, Oraarch, Data Files and System State. I want to inform u that i have also made client copy of PRD server on QAS server for pre-Go Live activity.

waiting ur good response.

regards,

jamil

[Former Member]

Hi

If all technical configuration is same among DEV,QAS and PRD, the time for backup depends on DB size.

do you have any more ideas about this?

- the other process was running during QAS backup