Q
Problem solve Get help with specific problems with your technologies, process and projects.

Taking an Oracle backup with Visual Basic

I am developing a project using VB6.0 and Oracle 8i and am facing problems with backup and recovery. If an error occurs then I have to uninstall Oracle and I lose all the data from the database. I am taking my backup in MS Access, but I want to take it using Visual Basic, which will help me more reliably.

I am developing a project using VB6.0 and Oracle 8i. In my project I am facing some problems with database backup and recovery. My project is running perfectly with scott/tiger, but if some error occurs in Oracle then I have to uninstall Oracle and I lose all the data from the database due to this. I am taking my database backup in MS Access, but I want to take a total backup using Visual Basic, which will help me more reliably than the other.
Visual Basic and MS Access should not be used as tools for your Oracle backup and recovery methodology. There are better tools provided by Oracle which can help you in a variety of situations. Consider using Oracle's Recovery Manager (RMAN) to perform your backups. With RMAN, most of the guess work as to what to recover and how to recover it is taken out of your hands and placed in the software tools. If you implement your own, custom solution, then you will have to figure out all of the details yourself. RMAN does a great job backing up your databases. For Oracle 8i, the RMAN documentation can be found here.
This was last published in January 2006

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close