Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!p2g2000prf.googlegroups.com!not-for-mail From: Mark D Powell Newsgroups: comp.databases.oracle.server Subject: Re: rman ? nfs ? slow Date: Thu, 1 Jan 2009 06:58:21 -0800 (PST) Organization: http://groups.google.com Lines: 106 Message-ID: References: <495cb0cd$0$2854$ba620e4c@news.skynet.be> NNTP-Posting-Host: 69.245.99.218 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1230821901 7660 127.0.0.1 (1 Jan 2009 14:58:21 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 1 Jan 2009 14:58:21 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: p2g2000prf.googlegroups.com; posting-host=69.245.99.218; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Jan 1, 7:03=A0am, "Gerard H. Pille" wrote: > lfree schreef: > > > > > > > I use rman backup product database on OS windows(2003 R2 standard 64 > > edition ) ,I check to find > > it is slow (vs Linux rhel 4.3 ). My nfs server use SFU for windows. > > > windows: > > > =A0=3D> select * from v$version ; > > BANNER > > ---------------------------------------------------------------- > > Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi > > PL/SQL Release 10.2.0.4.0 - Production > > CORE =A0 =A010.2.0.4.0 =A0 =A0 =A0Production > > TNS for 64-bit Windows: Version 10.2.0.4.0 - Production > > NLSRTL Version 10.2.0.4.0 - Production > > > SELECT start_time, end_time, status, input_type, elapsed_seconds, > > =A0 =A0 =A0 =A0compression_ratio, TRIM (input_bytes_display) inputb, > > =A0 =A0 =A0 =A0TRIM (output_bytes_display) outputb, > > =A0 =A0 =A0 =A0TRIM (input_bytes_per_sec_display) input, > > =A0 =A0 =A0 =A0TRIM (output_bytes_per_sec_display) output, > > =A0 =A0 =A0 =A0TRIM (time_taken_display) TIME > > =A0 FROM v$rman_backup_job_details > > =A0WHERE start_time > TRUNC (SYSDATE) - 1; > > > START_TIME =A0 =A0 =A0 =A0 =A0END_TIME =A0 =A0 =A0 =A0 =A0 =A0STATUS = =A0 =A0 =A0 =A0 =A0 INPUT_TYPE > > ELAPSED_SECONDS COMPRESSION_RATIO INPUTB =A0 OUTPUTB =A0INPUT =A0 =A0OU= TPUT =A0 TIME > > ------------------- ------------------- ---------------- ---------- ---= ----- > > ------- ----------------- -------- -------- -------- -------- ---------= - > > 2008-12-31 20:03:06 2008-12-31 20:19:37 COMPLETED =A0 =A0 =A0 =A0ARCHIV= ELOG > > 991 =A0 =A0 =A0 =A0 =A0 2.59272 1.02G =A0 =A0402.88M =A01.05M =A0 =A041= 6.29K =A000:16:31 > > > output_bytes_per_sec_display =3D 416.29K. > > > linux : > > > BANNER > > ---------------------------------------------------------------- > > Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi > > PL/SQL Release 10.2.0.3.0 - Production > > CORE =A0 =A010.2.0.3.0 =A0 =A0 =A0Production > > TNS for Linux: Version 10.2.0.3.0 - Production > > NLSRTL Version 10.2.0.3.0 - Production > > > START_TIME =A0 =A0 =A0 =A0 =A0END_TIME =A0 =A0 =A0 =A0 =A0 =A0STATUS = =A0 =A0 =A0 =A0 =A0 INPUT_TYPE > > ELAPSED_SECONDS COMPRESSION_RATIO INPUTB =A0 OUTPUTB =A0INPUT =A0 =A0OU= TPUT =A0 TIME > > ------------------- ------------------- ---------------- ---------- ---= ----- > > ------- ----------------- -------- -------- -------- -------- ---------= - > > 2009-01-01 02:10:17 2009-01-01 02:17:51 COMPLETED =A0 =A0 =A0 =A0ARCHIV= ELOG > > 454 =A0 =A0 =A0 =A0 =A0 2.72805 2.91G =A0 =A01.07G =A0 =A06.56M =A0 =A0= 2.40M =A0 =A000:07:34 > > 2008-12-31 02:10:17 2008-12-31 02:16:25 COMPLETED =A0 =A0 =A0 =A0ARCHIV= ELOG > > 368 =A0 =A0 =A0 =A0 =A0 2.59673 2.25G =A0 =A0888.76M =A06.27M =A0 =A02.= 42M =A0 =A000:06:08 > > > output_bytes_per_sec_display =3D 2.4M > > > in windows, I use to copy command , archive filesiez =3D 42M ,it takes = only > > 2-3s=A1=A3 > > copy arch... \\192.168.25.100\backup > > > why? > > > thank advanced. > > You are taking a backup on system A (Linux or Whinedoze) while the data i= s in fact on system B > (your NFS)? =A0 Not such a good idea. =A0In which case your problem could= be network related. > > I don't find it strange that Linux could beat Whinedoze on network throug= hput. > > Gerard- Hide quoted text - > > - Show quoted text - 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 --