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.