Re: rman ? nfs ? slow
Date: Tue, 6 Jan 2009 07:59:14 +0800
Message-ID: <gju6si$i0o$1_at_news.cn99.com>
>On various versions of UNIX/Linux there are Oracle recommended mount
>options for use with NFS file systems. (11g comes with an NFS driver
>built into the Oracle Kernal). Check on your NFS configuration. It
>could just be that the NFS device is not as fast on Windows as in a
>UNIX environment or there may be some configuration changes you need
>to make.
>Consider using the parallel option in rman.
>HTH -- Mark D Powell --
Thank your hint !!
I open parallel option .
rman > CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
and modify rman script .
run {
allocate channel c1 type disk ;
allocate channel c2 type disk ;
sql 'alter system archive log current ';
backup as compressed backupset archivelog all
tag="archivelog"
not backed up 2 times
format '\\192.168.100.39\backup\archives\%d_%T_%s_archive' ;
backup as compressed backupset current controlfile
tag="control_archive"
format '\\192.168.100.39\backup\controls\%d_%T_%s_control' ;
release channel c1 ;
release channel c2 ;
}
result diff:
START_TIME END_TIME STATUS INPUT_TYPE ELAPSED_SECONDS COMPRESSION_RATIO INPUTB OUTPUTB INPUT OUTPUT TIME
------------------- ------------------- ---------------- ---------- -------- ------- ----------------- -------- -------- -------- -------- --------- 2009-01-05 09:12:22 2009-01-05 09:13:53 COMPLETED ARCHIVELOG 91 2.55228 522.35M 204.66M 5.74M 2.25M 00:01:31 2009-01-04 20:03:06 2009-01-04 20:16:15 COMPLETED ARCHIVELOG 789 2.60098 708.50M 272.40M 919.52K 353.53K 00:13:09
it take only 1:31 minute. and now time 9:00-11:00 is peak load .
thank ! Received on Mon Jan 05 2009 - 17:59:14 CST