I am developing an application using VB as front end and Oracle8i as backend..I am not able to do the Backup and restore part..How can i take the Oracle Database backup?It's urgent..could anybody help me please..
The preference is always to use RMAN for online backups whereever possible. However, if you can afford the down time, just shut the database down and copy all the datafiles\controlfiles\archivelogs to some other storage device.
for a developer database a import/export is a good backup method. You can separately import tables as needed. It provides convinience. You can make separate exports on separte tables/schemas after some changes in the application and can import only those if needed. If you need a image copy of the database the best is to do a backup using Recover Manager (rman).
as i said, an export is not a backup method and its bad advice, you will lose data with it - doesnt matter if he is a developer a dba, a cleaner or the CEO's love child a backup needs to be a proper one
I know it is not a proper "backup" for a production database, I recommended it to cheery_poori as he is obviously not experienced with the Oracle database as a DBA, and the database he is using is for development, so if he uses a rman ora pure copy of datafiles/redos/controlfiles he might make a mistake and not be able to restore/recover the database at all (knowing many developers treat the DB as a black box). I still say exp/imp is a better solution for this situation.
The things are nto always black and white. If cheery_poori sais he needs a backup maybe someone should first asked him what kind of backup does he like and from what situation to be able to recover, what options does he have for backuing up does he even have a separete storage where he would do a backup or he will use a tape so he will need a media manager for RMAN.
Sometimes there are "custimzed" solutions to problems.