The database is currently running in ARCHIVELOG mode and RMAN is used to do a full database backup. I am told by the users that the system hangs when the backup begins. Is there something, besides waits or locks, that I can check for to determine the cause?
Another system at the site is using the same script for backup and is working fine.
Check Enqueue_resources , u may have to increase that.
Set the large_pool_size=n bytes since RMAN uses large pool if configured for backups.Also set backup_disk_io_slaves=n ,because if dont set this paramater large pool will not be used.
In case of any help contact me at email@example.com
Rohit Nirkhe,Oracle DBA,OCP
Click Here to Expand Forum to Full Width