- by ??
            
            
            Normal
  0
  
  
  
  7.8 ?
  0
  2
  
  false
  false
  false
  
  EN-US
  ZH-CN
  X-NONE
  
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  
  
   
   
   
   
   
   
   
   
   
   
   
  
 
  DefSemiHidden="true" DefQFormat="false" DefPriority="99"
  LatentStyleCount="267"
  
   UnhideWhenUsed="false" QFormat="true" Name="Normal"/
  
   UnhideWhenUsed="false" QFormat="true" Name="heading 1"/
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
   UnhideWhenUsed="false" QFormat="true" Name="Title"/
  
  
   UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Strong"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/
  
   UnhideWhenUsed="false" Name="Table Grid"/
  
  
   UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/
  
   UnhideWhenUsed="false" Name="Light Shading"/
  
   UnhideWhenUsed="false" Name="Light List"/
  
   UnhideWhenUsed="false" Name="Light Grid"/
  
   UnhideWhenUsed="false" Name="Medium Shading 1"/
  
   UnhideWhenUsed="false" Name="Medium Shading 2"/
  
   UnhideWhenUsed="false" Name="Medium List 1"/
  
   UnhideWhenUsed="false" Name="Medium List 2"/
  
   UnhideWhenUsed="false" Name="Medium Grid 1"/
  
   UnhideWhenUsed="false" Name="Medium Grid 2"/
  
   UnhideWhenUsed="false" Name="Medium Grid 3"/
  
   UnhideWhenUsed="false" Name="Dark List"/
  
   UnhideWhenUsed="false" Name="Colorful Shading"/
  
   UnhideWhenUsed="false" Name="Colorful List"/
  
   UnhideWhenUsed="false" Name="Colorful Grid"/
  
   UnhideWhenUsed="false" Name="Light Shading Accent 1"/
  
   UnhideWhenUsed="false" Name="Light List Accent 1"/
  
   UnhideWhenUsed="false" Name="Light Grid Accent 1"/
  
   UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/
  
   UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/
  
   UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/
  
  
   UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Quote"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/
  
   UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/
  
   UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/
  
   UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/
  
   UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/
  
   UnhideWhenUsed="false" Name="Dark List Accent 1"/
  
   UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/
  
   UnhideWhenUsed="false" Name="Colorful List Accent 1"/
  
   UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/
  
   UnhideWhenUsed="false" Name="Light Shading Accent 2"/
  
   UnhideWhenUsed="false" Name="Light List Accent 2"/
  
   UnhideWhenUsed="false" Name="Light Grid Accent 2"/
  
   UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/
  
   UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/
  
   UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/
  
   UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/
  
   UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/
  
   UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/
  
   UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/
  
   UnhideWhenUsed="false" Name="Dark List Accent 2"/
  
   UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/
  
   UnhideWhenUsed="false" Name="Colorful List Accent 2"/
  
   UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/
  
   UnhideWhenUsed="false" Name="Light Shading Accent 3"/
  
   UnhideWhenUsed="false" Name="Light List Accent 3"/
  
   UnhideWhenUsed="false" Name="Light Grid Accent 3"/
  
   UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/
  
   UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/
  
   UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/
  
   UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/
  
   UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/
  
   UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/
  
   UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/
  
   UnhideWhenUsed="false" Name="Dark List Accent 3"/
  
   UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/
  
   UnhideWhenUsed="false" Name="Colorful List Accent 3"/
  
   UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/
  
   UnhideWhenUsed="false" Name="Light Shading Accent 4"/
  
   UnhideWhenUsed="false" Name="Light List Accent 4"/
  
   UnhideWhenUsed="false" Name="Light Grid Accent 4"/
  
   UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/
  
   UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/
  
   UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/
  
   UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/
  
   UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/
  
   UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/
  
   UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/
  
   UnhideWhenUsed="false" Name="Dark List Accent 4"/
  
   UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/
  
   UnhideWhenUsed="false" Name="Colorful List Accent 4"/
  
   UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/
  
   UnhideWhenUsed="false" Name="Light Shading Accent 5"/
  
   UnhideWhenUsed="false" Name="Light List Accent 5"/
  
   UnhideWhenUsed="false" Name="Light Grid Accent 5"/
  
   UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/
  
   UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/
  
   UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/
  
   UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/
  
   UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/
  
   UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/
  
   UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/
  
   UnhideWhenUsed="false" Name="Dark List Accent 5"/
  
   UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/
  
   UnhideWhenUsed="false" Name="Colorful List Accent 5"/
  
   UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/
  
   UnhideWhenUsed="false" Name="Light Shading Accent 6"/
  
   UnhideWhenUsed="false" Name="Light List Accent 6"/
  
   UnhideWhenUsed="false" Name="Light Grid Accent 6"/
  
   UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/
  
   UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/
  
   UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/
  
   UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/
  
   UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/
  
   UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/
  
   UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/
  
   UnhideWhenUsed="false" Name="Dark List Accent 6"/
  
   UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/
  
   UnhideWhenUsed="false" Name="Colorful List Accent 6"/
  
   UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/
  
   UnhideWhenUsed="false" QFormat="true" Name="Book Title"/
  
  
 
 /* Style Definitions */
 table.MsoNormalTable
	{mso-style-name:????;
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-priority:99;
	mso-style-qformat:yes;
	mso-style-parent:"";
	mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
	mso-para-margin:0cm;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.5pt;
	mso-bidi-font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	mso-ascii-font-family:Calibri;
	mso-ascii-theme-font:minor-latin;
	mso-hansi-font-family:Calibri;
	mso-hansi-theme-font:minor-latin;
	mso-font-kerning:1.0pt;}
 
  ????,RMAN?Oracle?????????????????????,?RMAN?????????????????,?????????????? 
   
    ?????,RMAN????? 
    RMAN???????????? 
    RMAN???/?????????? 
    ???????????? 
   
  ????1487262.1???????????,?????RMAN??/????????4??????: 
   
    ???? 
    ???? 
    ???? 
    ??????? 
   
  ???????????????,???????SQLPLUS???,???????????“DD-MON-RR HH24:MI:SS”???????,??????????? 
  ??: 
  SQL>spool monitor.out 
  SQL>@monitor '06-aug-12 16:38:03' 
    
  ?????RMAN???????????,?????????,?????? - ???????????????????,?????RMAN?????? 
  ???????4??????????????? 
  ???? 
  ??DBA????????V$SESSION_LONGOPS???????????????????????,?????????????????? 
  ??: 
  SID CH CONTEXT SOFAR TOTALWORK % Complete  
  --- -- ------- ------ ---------- ----------  
  16 t1 1 181950 1186752 15.33  
  148 t2 1 249722 422400 59.12 
  ??: 
  - ???????????????? 
  - ??????????????? 
  ???? 
  ??????RMAN?????????????????????????????????????????????????????????Oracle???????????????????????? 
  ??: 
  SID CH SEQ#
EVENT STATE SECONDS  
  --- -- ----
--------------------------------- ------- ------- 
  16 t1 5735 RMAN backup & recovery I/O WAITING 10  
  143 8200 SQL*Net message from client WAITING 258.83  
  148 t2 7941 Backup:
MML create a backup piece WAITING 196.13 
  ?????????T2???????????????,???????T2????????????????? 
  ??: 
  -?CH??????RMAN???,?Rman???????????,????????? 
  -??SEQ#?????????,???????? 
  -?????????,??????SEQ#???? 
  -????????????????RMAN backup &
recovery I/O'??????????????IO???? 
  ???? 
  ???????????????????????????????,???????backup_tape_io_slaves=TRUE,?????????????????? 
  ??:  
  SID CH STATUS OPEN_TIME SOFAR Mb TOTMB IO_COUNT % Complete TYPE FILENAME  
  --- -- ----------- ------------------ -------- ------ ---------- --------
------ -------------  
  19 t1 FINISHED 02-aug-12 17:28:42 567.5 567.5 569 100.00 INPUT users01.dbf  
  19 t1 IN PROGRESS 02-aug-12
17:28:42 3489.99 8704 3490  40.10 INPUT sh.dbf  
  19 t1 IN PROGRESS 02-aug-12
17:28:42 3778 15113 OUTPUT kvnhlb22_1_1  
  20 t2 FINISHED 02-aug-12 17:28:38 740 740 742 100.00 INPUT system01.dbf  
  20 t2 FINISHED 02-aug-12 17:28:38 880 880 882 100.00 INPUT sysaux01.dbf  
  20 t2 FINISHED 02-aug-12 17:28:38 1680 1680 1682 100.00 INPUT undotbs01.dbf  
  20 t2 FINISHED 02-aug-12 17:28:38 3007.25 12029 OUTPUT l0nhlb23_1_1  
    
  ??: 
  - ???????????????,??RMAN??????IO,??????????IO??,??(Document 360443.1 RMAN Backup Performance) 
  - ?? IO_COUNT??????????? 
  ???????  
  ?????,????????, ????????????v$backup_sync_io
?????????. 
  ??: 
  SID CH FILENAME TYPE STATUS BSZ BFC OPEN IO_COUNT  
  --- -- ------------ ------ ----------- ------ --- ------------------
-------- 
  16 t1 ksnhla1b_1_1 OUTPUT IN
PROGRESS 262144 4 02-aug-12
17:12:20 1092  
  148 t2 ktnhla1c_1_1 OUTPUT IN PROGRESS 262144 4 02-aug-12 17:12:15 2968  
  ??: 
  -?????????????????,??RMAN??????IO 
  -?? IO_COUNT?????????? 
  -??IO_COUNT ????,
???IO_COUNT ????????????,???????????????,????????????? 
  ????: 
  ??????????????? 
   
    Document 1487262.1 Script to monitor RMAN
     Backup and Restore Operations  
    Document 144640.1   RMAN:
     Monitoring Recovery Manager Jobs  
    Document 360443.1   RMAN Backup
     Performance 
    Document 740911.1   RMAN Restore
     Performance 
   
  ??,?????My Oracle Support Database Backup and
Recovery community ?Oracle?????????????/??????