Page 1 of 1
Get Backup
Posted: Fri Sep 08, 2006 2:35 am
by kamran.it
Assalam Alaikum
Sir Let me know what is the right way to get bockup of my database
OR how can we get bachup and restore that file?
Kamran
Posted: Fri Sep 08, 2006 5:29 am
by Kashif
Follow the Link for backup Procedure....
topic.asp?TOPIC_ID=11
Posted: Sat Sep 09, 2006 12:58 am
by admin
Thanks Kashif for your assistance. Well there are different ways to take backup cold/hot (online/offline). The refered link is to export the database but for a backup and recovery I would recommend RMAN (Recovery Manager) always use right tool to do things right. I am writing a document for DBA's hope soon will upload and I am including RMAN.
Now again it depends on your requirements, database availability (24/7), volume of data etc. Then we will be able to provide you a recommended solution. I would suggest you should try all the possible ways and choose your own suitable way.
Have a nice day. thanks
Posted: Sat Sep 09, 2006 7:05 am
by Kashif
Please Tell me the Difference between BACKUP and Export the database.
Posted: Mon Sep 11, 2006 3:52 am
by admin
Dear Kashif,
No comparison as Export is the way you backup the database. RMAN is also for the same purpose. Now which tool is good to take backup is the question. Just think that you are using export to take backup and users are making entries in the database. A table named Employees has been exported while other tables are yet to be exported and a user have inserted/updated in the Employees table and his/her salary in another table named Salary. After this entry Salary table will be exported but not Employees now just image when you will import what will happen? Just give a think to it.....
Posted: Mon Sep 11, 2006 10:09 am
by Kashif
hmmmm
there will be problem when Impoting this exported file.
then is RMAN is Better to use for Backup the Database?
If YES then Please tell me the Procedure how can i Use it.
Posted: Tue Sep 12, 2006 2:49 am
by admin
Now you got the point. Well just download the document Oracle Apps DBA and I have covered RMAN there. thanks
Posted: Tue Sep 12, 2006 5:14 am
by Kashif
I search the Forum for Oracle Apps DBA and found Oracle Application DBA 11i. But unable to Find any other.
Is it that which u are pointing?
Posted: Tue Sep 12, 2006 6:54 am
by admin
Download the same and goto Backup topic it is same for all DBA.s. thanks
Posted: Tue Sep 12, 2006 8:39 am
by Kashif
Thanku Dear Mr. Admin