Get Backup

To discuss Oracle Forms & Reports related technical issues.
Post Reply
kamran.it
Posts: 34
Joined: Tue Aug 01, 2006 7:43 am
Location: Pakistan

Get Backup

Post 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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post by Kashif »

Follow the Link for backup Procedure....
topic.asp?TOPIC_ID=11
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post 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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post by Kashif »

Please Tell me the Difference between BACKUP and Export the database.
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post 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.....
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post 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.
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Now you got the point. Well just download the document Oracle Apps DBA and I have covered RMAN there. thanks
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post 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?
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Download the same and goto Backup topic it is same for all DBA.s. thanks
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post by Kashif »

Thanku Dear Mr. Admin
Post Reply

Who is online

Users browsing this forum: No registered users and 12 guests