Очень долго выполняется rman : Oracle

А я-то говорю - по rman посмотри активность, например, вот этим: http://technet.microsoft.com/ru-ru/bb896645

Запустил посморел /// рман ничего не делает

А кто-то другой что-нибудь делает?

редкая активность oracle ... так как с базой работают ореры и товароведы

забил рман в оптимизере и запуслил ручками понеслось обращение...

дошло до этого и висим


Recovery Manager: Release 10.2.0.1.0 - Production on Tue Mar 26 11:58:12 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: DBCENTR (DBID=3266958312)

RMAN> backup database;

Starting backup at 26-MAR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=115 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=92 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=140 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=122 devtype=DISK
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\INDX02.DB
F
input datafile fno=00011 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\USERS03.D
BF
input datafile fno=00012 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\TOOLS01.D
BF
input datafile fno=00014 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\TOOLS+2.D
BF
input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\UNDOTBS01
.DBF
channel ORA_DISK_1: starting piece 1 at 26-MAR-13
channel ORA_DISK_2: starting compressed full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00007 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\INDX03.DB
F
input datafile fno=00018 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\USERS04.D
BF
input datafile fno=00017 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\TOOLS+5.D
BF
input datafile fno=00015 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\TOOLS+3.D
BF
input datafile fno=00009 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\UNDOTBS02
.DBF
channel ORA_DISK_2: starting piece 1 at 26-MAR-13
channel ORA_DISK_3: starting compressed full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\INDX01.DB
F
input datafile fno=00008 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\INDX04.DB
F
input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\SYSAUX01.
DBF
channel ORA_DISK_3: starting piece 1 at 26-MAR-13
channel ORA_DISK_4: starting compressed full datafile backupset
channel ORA_DISK_4: specifying datafile(s) in backupset
input datafile fno=00005 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\USERS02.D
BF
input datafile fno=00010 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\USERS01.D
BF
input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\SYSTEM01.
DBF
input datafile fno=00013 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\TOOLS+1.D
BF
input datafile fno=00016 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBCENTR\TOOLS+4.D
BF
channel ORA_DISK_4: starting piece 1 at 26-MAR-13
channel ORA_DISK_3: finished piece 1 at 26-MAR-13
piece handle=Z:\ALOG\DBCENTR\BACKUPSET\2013_03_26\O1_MF_NNNDF_TAG20130326T115825
_8O2O92FJ_.BKP tag=TAG20130326T115825 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:05:55
channel ORA_DISK_4: finished piece 1 at 26-MAR-13
piece handle=Z:\ALOG\DBCENTR\BACKUPSET\2013_03_26\O1_MF_NNNDF_TAG20130326T115825
_8O2O92HH_.BKP tag=TAG20130326T115825 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:05:55
channel ORA_DISK_1: finished piece 1 at 26-MAR-13
piece handle=Z:\ALOG\DBCENTR\BACKUPSET\2013_03_26\O1_MF_NNNDF_TAG20130326T115825
_8O2O924Q_.BKP tag=TAG20130326T115825 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:06:30
channel ORA_DISK_2: finished piece 1 at 26-MAR-13
piece handle=Z:\ALOG\DBCENTR\BACKUPSET\2013_03_26\O1_MF_NNNDF_TAG20130326T115825
_8O2O928N_.BKP tag=TAG20130326T115825 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:06:37
Finished backup at 26-MAR-13

Starting Control File and SPFILE Autobackup at 26-MAR-13
piece handle=Z:\ALOG\DBCENTR\AUTOBACKUP\2013_03_26\O1_MF_S_811080303_8O2OOJ29_.B
KP comment=NONE
Finished Control File and SPFILE Autobackup at 26-MAR-13

так и висит на Finished Control File and SPFILE Autobackup at 26-MAR-13

надо трейсить и смотреть, что оно делает... хотя бы той прогой, что выше давал

вот по кругу гоняет

13:30:03,6766531 StorServ.exe 1264 ReadFile C:\Program Files\Adaptec\Adaptec Storage Manager\ArcAifSCSI4.log SUCCESS Offset: 0, Length: 72
13:30:04,1395943 ORACLE.EXE 4968 WriteFile D:\oracle\product\10.2.0\oradata\dbcentr\CONTROL01.CTL SUCCESS Offset: 49152, Length: 16384, I/O Flags: Non-cached, Write Through
13:30:04,1396329 ORACLE.EXE 4968 WriteFile D:\oracle\product\10.2.0\oradata\dbcentr\CONTROL02.CTL SUCCESS Offset: 49152, Length: 16384, I/O Flags: Non-cached, Write Through
13:30:04,1396491 ORACLE.EXE 4968 WriteFile D:\oracle\product\10.2.0\oradata\dbcentr\CONTROL03.CTL SUCCESS Offset: 49152, Length: 16384, I/O Flags: Non-cached, Write Through
13:30:04,1398462 ORACLE.EXE 4968 ReadFile D:\oracle\product\10.2.0\oradata\dbcentr\CONTROL01.CTL SUCCESS Offset: 49152, Length: 16384, I/O Flags: Non-cached
13:30:04,3594744 ORACLE.EXE 4968 RegOpenKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3595016 ORACLE.EXE 4968 RegQueryValue HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORA_NLS_PROFILE33 NAME NOT FOUND Length: 144
13:30:04,3595190 ORACLE.EXE 4968 RegCloseKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3595367 ORACLE.EXE 4968 RegOpenKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3595548 ORACLE.EXE 4968 RegQueryValue HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORA_NLS10 NAME NOT FOUND Length: 144
13:30:04,3595645 ORACLE.EXE 4968 RegCloseKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3595760 ORACLE.EXE 4968 RegOpenKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3595925 ORACLE.EXE 4968 RegQueryValue HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORACLE_HOME SUCCESS Type: REG_SZ, Length: 60, Data: D:\oracle\product\10.2.0\db_1
13:30:04,3596015 ORACLE.EXE 4968 RegQueryValue HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORACLE_HOME SUCCESS Type: REG_SZ, Length: 60, Data: D:\oracle\product\10.2.0\db_1
13:30:04,3596103 ORACLE.EXE 4968 RegCloseKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3598026 ORACLE.EXE 4968 CreateFile D:\oracle\product\10.2.0\db_1\nls\data\lx1boot.nlb SUCCESS Desired Access: Generic Read, Disposition: Open, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: N, ShareMode: Read, Write, AllocationSize: n/a, OpenResult: Opened
13:30:04,3598253 ORACLE.EXE 4968 ReadFile D:\oracle\product\10.2.0\db_1\nls\data\lx1boot.nlb SUCCESS Offset: 0, Length: 48
13:30:04,3598526 ORACLE.EXE 4968 ReadFile D:\oracle\product\10.2.0\db_1\nls\data\lx1boot.nlb SUCCESS Offset: 48, Length: 22240
13:30:04,3598763 ORACLE.EXE 4968 CloseFile D:\oracle\product\10.2.0\db_1\nls\data\lx1boot.nlb SUCCESS
13:30:04,3623097 ORACLE.EXE 4968 RegOpenKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3623322 ORACLE.EXE 4968 RegQueryValue HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORA_NLS_PROFILE33 NAME NOT FOUND Length: 144
13:30:04,3623435 ORACLE.EXE 4968 RegCloseKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3623571 ORACLE.EXE 4968 RegOpenKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3623742 ORACLE.EXE 4968 RegQueryValue HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORA_NLS10 NAME NOT FOUND Length: 144
13:30:04,3623839 ORACLE.EXE 4968 RegCloseKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3623948 ORACLE.EXE 4968 RegOpenKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3624106 ORACLE.EXE 4968 RegQueryValue HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORACLE_HOME SUCCESS Type: REG_SZ, Length: 60, Data: D:\oracle\product\10.2.0\db_1
13:30:04,3624184 ORACLE.EXE 4968 RegQueryValue HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORACLE_HOME SUCCESS Type: REG_SZ, Length: 60, Data: D:\oracle\product\10.2.0\db_1
13:30:04,3624269 ORACLE.EXE 4968 RegCloseKey HKLM\SOFTWARE\ORACLE\KEY_OraDb10g_home1 SUCCESS
13:30:04,3625488 ORACLE.EXE 4968 CreateFile D:\oracle\product\10.2.0\db_1\nls\data\lx1boot.nlb SUCCESS Desired Access: Generic Read, Disposition: Open, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: N, ShareMode: Read, Write, AllocationSize: n/a, OpenResult: Opened
13:30:04,3625669 ORACLE.EXE 4968 ReadFile D:\oracle\product\10.2.0\db_1\nls\data\lx1boot.nlb SUCCESS Offset: 0, Length: 48
13:30:04,3625773 ORACLE.EXE 4968 ReadFile D:\oracle\product\10.2.0\db_1\nls\data\lx1boot.nlb SUCCESS Offset: 48, Length: 22240
13:30:04,3625880 ORACLE.EXE 4968 CloseFile D:\oracle\product\10.2.0\db_1\nls\data\lx1boot.nlb SUCCESS
13:30:04,5380068 ORACLE.EXE 4968 WriteFile D:\oracle\product\10.2.0\oradata\dbcentr\REDO09.LOG SUCCESS Offset: 46512128, Length: 2048, I/O Flags: Non-cached, Write Through

Могу выложить лог ... ProcessMonitor за какое нибудь время

Добавлено через 29 минут 40 секунд
Вот только закончило ...

вот даже в чем засада
RMAN> exit
Recovery Manager complete.


и висим

сессию посмотри, он же в базе сейчас...