OCI should not be used as a tool for your Oracle backup and recovery methodology. OCI is an access method designed to let you access data in your Oracle database.
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 10g, the RMAN documentation can be found here. Please take the time to read this documentation.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading