Re: rman ? nfs ? slow
Date: Sun, 4 Jan 2009 20:29:28 +0800
Message-ID: <gjqa3b$8u8$1_at_news.cn99.com>
My logfile :
begin backup xxx, running archive.rman : 2009-01-04 20:03:02.31
Recovery Manager: Release 10.2.0.4.0 - Production on Sun Jan 4 20:03:02 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1196486461)
RMAN> run {
2> allocate channel c1 type disk ; 3> sql 'alter system archive log current '; 4> 5> backup as compressed backupset archivelog all 6> tag="archivelog" 7> not backed up 2 times 8> format '\\192.168.100.39\backup\archives\%d_%T_%s_archive' ; 9> 10> backup as compressed backupset current controlfile 11> tag="control_archive" 12> format '\\192.168.100.39\backup\controls\%d_%T_%s_control' ; 13> release channel c1 ;
14> }
15>
using target database control file instead of recovery catalog allocated channel: c1
channel c1: sid=329 devtype=DISK
sql statement: alter system archive log current
Starting backup at 2009-01-04 20:03:06
current log archived
skipping archive log file
D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00461_0668705725.001; already backed up
2 time(s)
skipping archive log file
D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00462_0668705725.001; already backed up
2 time(s)
truncate ....
skipping archive log file
D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ARC00882_0668705725.001; already backed up
2 time(s)
channel c1: starting compressed archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=883 recid=1709 stamp=675122447
truncate ....
input archive log thread=1 sequence=901 recid=1745 stamp=675288189
channel c1: starting piece 1 at 2009-01-04 20:03:42
channel c1: finished piece 1 at 2009-01-04 20:15:57
piece handle=\\192.168.100.39\BACKUP\ARCHIVES\ORCL_20090104_253_ARCHIVE
tag=ARCHIVELOG comment=NONE
channel c1: backup set complete, elapsed time: 00:12:16
Finished backup at 2009-01-04 20:15:57
Starting backup at 2009-01-04 20:16:01
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 2009-01-04 20:16:02
channel c1: finished piece 1 at 2009-01-04 20:16:09
piece handle=\\192.168.100.39\BACKUP\CONTROLS\ORCL_20090104_254_CONTROL
tag=CONTROL_ARCHIVE comment=NONE
channel c1: backup set complete, elapsed time: 00:00:09
Finished backup at 2009-01-04 20:16:10
Starting Control File and SPFILE Autobackup at 2009-01-04 20:16:11
piece
handle=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\LIS\AUTOBACKUP\2009_01_0
4\O1_MF_S_675288971_4P1B4D3F_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 2009-01-04 20:16:15
released channel: c1
Recovery Manager complete.
end backup xxx, stoped archive.rman : 2009-01-04 20:16:19.95
I don't know why it is slow on windows + rman + nfs .
On Dec 31 2008, 10:02 pm, "lfree" <a..._at_163.com> wrote:
> 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:
>
> => 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 10.2.0.4.0 Production
> 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,
> compression_ratio, TRIM (input_bytes_display) inputb,
> TRIM (output_bytes_display) outputb,
> TRIM (input_bytes_per_sec_display) input,
> TRIM (output_bytes_per_sec_display) output,
> TRIM (time_taken_display) TIME
> FROM v$rman_backup_job_details
> WHERE start_time > TRUNC (SYSDATE) - 1;
>
> START_TIME END_TIME STATUS INPUT_TYPE
> ELAPSED_SECONDS COMPRESSION_RATIO INPUTB OUTPUTB INPUT OUTPUT TIME
> ------------------- ------------------- ---------------- ---------- ------
--Received on Sun Jan 04 2009 - 06:29:28 CST