cancel
Showing results for 
Search instead for 
Did you mean: 

Problem Regarding Backup on Disk as well as on Tape Drive

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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.