This content has been marked as final. Show 3 replies
1 person found this helpful
I want valuable suggestions for reducing its time or is there any way to break 0 level backup. I can allocate channels but ultimately it will take time when taking "users" tablepace backupyou can allocate several channels and use rman interfile backup parallelism for large datafiles, for example:
backup section size 500m tablespace users;
As you are taking backup to a usb drive there is not much that can be done to improve the speed. If you are concerned about the backup being slow.. then you could think of taking the backup on local disk( which would be faster and more efficient) and then move the backups from the disk to usb drive.
This can be done in a single backup script as 2 part operation.
1) take backup to disk.
2) copy the backup to usb drive and delete the backups from the disk.
There are many additional features that u can add to enhance it thoe.
+++1 person found this helpful
Perhaps if you read the fine Oracle® Database Backup and Recovery User's Guide you would get a better idea of what to do: