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
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.