Re: Need insight for RMAN tape backup troubleshooting
- From: Saurabh <saurabhmanroy@xxxxxxxxx>
- To: "sandip.mukhopadhyay24@xxxxxxxxx" <sandip.mukhopadhyay24@xxxxxxxxx>
- Date: Thu, 30 May 2013 08:15:52 +0200
Hello Sandy,
You haven't mentioned How many channels have you allocated for backup ? How
many free tapes are available in tape pool ? Are you using rman compression ?
How big is sga ? What are the wait events seen if any in the db ?
In general, Execution time of 'backup validate database' command should help
you to find the right problem area.
Considering that there is enough network bandwidth available b/w host nd tapes
and cpu & i/o is not the bottleneck on the host, It is likely that tape media
pool doesnt have enough tapes leading to channel queueing. Check Activity
monitor tab on Netbackup Server console for this.
Regards,
On 30-May-2013, at 3:36 AM, Sandip Mukhopadhyay
<sandip.mukhopadhyay24@xxxxxxxxx> wrote:
> Hi Everyone,
> In one of our QA servers,RMAN incremental backup(s) is running for last 8
> days in tape (Netback -Veritas), Large pool was not configured there ,
> Operating system is Solaris SPARC 64 bit , I tried to diagnose read and
> write bottlenecks from dynamic performance views related to RMAN (sync and
> async) , but did not able to figure out any. DB version is 11.2.0.2.0 and
> size of the database is 1.5 TB approx. Any advice to peek into this issue?
>
> Regards,
> Sandy
> Oracle DB
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
