Get Backup
Get Backup
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
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
Follow the Link for backup Procedure....
topic.asp?TOPIC_ID=11
topic.asp?TOPIC_ID=11
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
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
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.....
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.....
Who is online
Users browsing this forum: No registered users and 1 guest