1

I need your help about backup in oracle database. Currently I am using Export Utility of Schema Backup but taking more time to complete and size is 40GB.

For full database backup using Image Copy and taking time more than 15 hours to complete and size is 650GB.

Which backup method is best for schema backup and full database backup which take less time and less size.

Database version Oracle Database 11gR2

Regards

0

650*1024/15/3600 = 12.3 MB/s. Sounds like you have a 100 Mbit network connection for backup. In that case, using a compressed backupset instead of image copy will significantly reduce the time it takes to backup the database. – Balazs Papp

  • Even better: do the export on the database server proper and avoid all that network overhead. And when you say you use “export utility” I hope that by that you mean Data Pump Export (expdp), not the old and deprecated exp tool ? – Albert Godfrind Jul 5 at 20:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.