Dear All,

New guy here. Would appreciate if someone could advice me a bit on the backup/recovery matters.

I am running Oracle 8.0.5 on AIX 4.3.3 on a 24/7 basis. It is NOT likely for me to shutdown database to do a cold backup.

I had tried exporting 24 tables with the average of 1 million records per table. It took more than 3 days to complete the exporting exercise. I have in total more than 180 tables to be exported.

Any idea how can I speed up the export/import processes?

btw, is there any good site to learn more about the backup/recovery?


Many thanks in advance.