Monday, July 2, 2012

Oracle Database Backup using Brtools on a Disk

Hi All,

This blog contains steps with screenshot which shows you the steps to take Oracle DB backup on Disk.

Please stop your SAP application server before you proceed with your DB backup activities and take a backup of initSID.sap file before you modify it manually.

Step1: Modify the initSID.sap file present in the location :\oracle\SID\11202\database (windows) or /oracle/SID/112_64/dbs(Linux).

Change the entries as shown in the figure above(Change "backup_dev_type = disk" and "backup_root_dir = :\location" and save and quit.

Step2: Start Brtools utility from the command prompt by logging in as SIDadm on windows and oraSID  in Linux.


 
Enter "4" (Press Enter Key)



Enter "1" (Press Enter Key)


Enter "c" (Press Enter Key)


Enter "c" (Press Enter Key)



Enter "c" (Press Enter Key)













It will show you the summary of all the files which it will copy during this backup activity, Press "c" and continue.




You can see the progress of your backup as shown in the screen above.

Finally once your backup is over, you can see the return code 0 on the screen which shows that your backup was successfull.

7 comments:

  1. since my sap sytem is connected through linux and having db2 database how to connect to BRTOOLS can u tell me

    ReplyDelete
  2. Hi Kiran,

    Brtools is only available for oracle DB.

    Thanks.
    Sharib

    ReplyDelete
  3. Hello sharib,
    that was a good information,can you provide any script so that I can schedule the online backup every Friday night after 12.

    operating system : Red Hat Enterprise Linux version 5.7
    Database: oracle 10g

    ReplyDelete
  4. how to backup in 2 o more tape data cartridge, using brtools and db13 transaction

    ReplyDelete
  5. How to restore onine backup on different SID with BRTOOLS

    Regards
    Ajay

    ReplyDelete