??Recovery Manager (RMAN)??
- 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?????????????/??????