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.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close