Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: performance of backup degrade continuously
On 24 Jun 2006 06:55:04 -0700, "jshen.cad_at_gmail.com"
<jshen.cad_at_gmail.com> wrote:
>Hi,
>
>we are using oracle8i in our service system. The number of record
>increases about 3million every day. We backup the system every day
>with HP ominibackup.
>
>In past weeks, we noticed that the backup performance degrade
>continuously. ( in past month, the total backup taked about 5hour, it
>taked about 8hours last day.)
>
>how can I improve the backup performance?
>
>thanks in advance.
>
>
>Joe
>
The sporadic information you provide suggests that your data volume grows continously, thus the backup time grows accordingly.
Start considering incremental backups with RMAN, which will reduce backup time at the cost of increased recovery time.