Problem Regarding Backup on Disk as well as on Tape Drive

[Former Member]

Dear Experts,

We have one Developmenet System and one QA System, and we want to take daily online database backup for both servers, now my situation is like below

(1) I have only one LTO Tape drive, which i have attached on QA Server, so in this case i can take daily backup of QA only.

(2) But Company wants policy like Alternate backup of both servers on LTO attached on QA Server, i think it is possible if we configure init<sid>.profile

(3) My problem is, on another side company wants alternate backup on Disk also, means

Day Development Server Quality Server

Monday Disk Tape

Tuesday Tape Disk

Wednesday Disk Tape

Thursday Tape Disk

Friday Disk Tape

Saturday Tape Disk

i think you can understand my problem.

So how can i set my init<sid>.sap profile file accordingly.

Waiting for your favorable response.

Thanks and Regards,

K R Singh

[Former Member · Accepted solution]

Hi Kamesh,

I am not sure what version of SAP you are using. DB13 has an option to choose what initsid.sap file you want to use. Maintain two different initsid.sap files with the names you like and use those from DB13.

Thanks,

Ravi Gandavarapu.

[Former Member]

Hi Karmesh,

If you're using Brbackup (I assume that), you can call it with different options every day (from a script, or with cron if you work with Unix). These options can be:

[-d|-device tape|tape_auto|tape_box|pipe|pipe_auto|pipe_box|disk

|disk_copy|disk_standby|stage|stage_copy|stage_standby|util_file

|util_file_online|rman_util|rman_disk|rman_stage|rman_prep]

backup device type

default: tape

or better this:

[-p|-profile <profile>]

profile name

default: init<SID>.sap

I guess you see the possibilities of this....

Hope this helps.

Best Regards,

JC Llanes.

[Former Member]

Hi JC Llanes.,

Thanks a lot for your prompt reply.

But we are planning to use DB13 instead of Brtools, if you could suggest accordingly then i will be very thankful to you.

Regards

K R Singh

[Former Member]

Hi Karmesh,

Sorry, but I think DB13 isn't as flexible as you need.

With Oracle, the best backup method I can suggest you is with BRtools or Rman.

Regards,

JC Llanes.