（52-21）第36/37次：2016-01-05星期二, 2016-01-07星期四

botang

（52-21）上完1Z0-052第18章

100^(193-193-0)(2-1)=1

100^(193-193-0)(11-1)=10

100^(194-193-0)(2-1)=100

100^(194-193-0)(11-1)=1000

100^(194-193-0)(2-1)+

   100^(194-193-1)(11-1)=110

100^(194-193-0)(12-1)=1100

100^(62-62-0)(101-100)=1

100^(62-62-0)(101-91)=10

100^(62-61-0)(101-100)=100

123456.789

100^(195-193-0)(13-1)+

100^(195-193-1)(35-1)+

100^(195-193-2)(57-1)+

100^(195-193-3)(79-1)+

100^(195-193-4)(91-1)=120000+3400+56+0.78+0.009=

123456.789

-123456.789

100^(62-60-0)(101-89)+

100^(62-60-1)(101-67)+

100^(62-60-2)(101-45)+

100^(62-60-3)(101-23)+

100^(62-60-4)(101-11)=120000+3400+56+0.78+0.009=

-123456.789

-123456.78901

100^(62-60-0)(101-89)+

100^(62-60-1)(101-67)+

100^(62-60-2)(101-45)+

100^(62-60-3)(101-23)+

100^(62-60-4)(101-11)+

100^(62-60-5)(101-91)

=120000+3400+56+0.78+0.009+ 0.00001=

-123456.78901

1. select  * from v$backup_corruption;
   
2. 
   
3. select  * from v$copy_corruption;
   
4. 
   
5. select  * from v$database_block_corruption;
   
6. 
   
7. drop tablespace tbs05309 including contents and datafiles ;
   
8. 
   
9. create tablespace tbs05309  datafile size 5M  nologging;
   
10. 
    
11. ---
    
12. BEGIN
    
13. DBMS_REPAIR.ADMIN_TABLES (
    
14.    table_name => 'REPAIR_TABLE',
    
15.    table_type => DBMS_REPAIR.REPAIR_TABLE,
    
16.    action => DBMS_REPAIR.CREATE_ACTION,
    
17.    tablespace => 'USERS');
    
18. END;
    
19. 
    
20. BEGIN
    
21. DBMS_REPAIR.ADMIN_TABLES (
    
22.    table_name => 'ORPHAN_KEY_TABLE',
    
23.    table_type => DBMS_REPAIR.ORPHAN_TABLE,
    
24.    action => DBMS_REPAIR.CREATE_ACTION,
    
25.    tablespace => 'USERS');
    
26. END;
    
27. 
    
28. select  * from REPAIR_TABLE;
    
29. 
    
30. select  * from ORPHAN_KEY_TABLE;
    
31. 
    
32. DECLARE
    
33.   num_corrupt INT;
    
34. BEGIN
    
35. num_corrupt := 0;
    
36. DBMS_REPAIR.CHECK_OBJECT (
    
37.    schema_name => 'HR',
    
38.            object_name => 'T05309',
    
39.    repair_table_name => 'REPAIR_TABLE',
    
40.    corrupt_count => num_corrupt);
    
41.   dbms_output.put_line( 'Find  '|| num_corrupt||' Bolcks.'  );
    
42. END;
    
43. 
    
44. select  * from REPAIR_TABLE;
    
45. 
    
46. select  * from ORPHAN_KEY_TABLE;
    
47. 
    
48. DECLARE
    
49.   num_orphans INT;
    
50. BEGIN
    
51. num_orphans := 0;
    
52. DBMS_REPAIR.DUMP_ORPHAN_KEYS (
    
53.   schema_name => 'HR',
    
54.   object_name => 'ICOL1',
    
55.   object_type => DBMS_REPAIR.INDEX_OBJECT,
    
56.   repair_table_name => 'REPAIR_TABLE',
    
57.   orphan_table_name => 'ORPHAN_KEY_TABLE',
    
58.   key_count => num_orphans);
    
59. DBMS_OUTPUT.PUT_LINE('orphan key count: ' || TO_CHAR(num_orphans));
    
60. END;
    
61. 
    
62. 
    
63. DECLARE
    
64.   num_orphans INT;
    
65. BEGIN
    
66. num_orphans := 0;
    
67. DBMS_REPAIR.DUMP_ORPHAN_KEYS (
    
68.   schema_name => 'HR',
    
69.   object_name => 'ICOL2',
    
70.   object_type => DBMS_REPAIR.INDEX_OBJECT,
    
71.   repair_table_name => 'REPAIR_TABLE',
    
72.   orphan_table_name => 'ORPHAN_KEY_TABLE',
    
73.   key_count => num_orphans);
    
74. DBMS_OUTPUT.PUT_LINE('orphan key count: ' || TO_CHAR(num_orphans));
    
75. END;
    
76. 
    
77. select  * from ORPHAN_KEY_TABLE;
    
78. 
    
79. begin
    
80.    dbms_repair.skip_corrupt_blocks('HR','T05309');
    
81. end;
    
82. 
    
83. 
    
84. -----
    
85. select  * from ORPHAN_KEY_TABLE;
    
86. 
    
87.   select  dump(key)   from orphan_key_table where keyrowid||' '='AAAUi7AIgAAAIABAAA'||' ';
    
88.   ASCII
    
89.   
    
90.   WULONGW
    
91.   1979    640K        IBM  sort >2  SDL oracle;
    
92.   
    
93.   -------
    
94.   -------
    
95.   195 13 49 69 11
    
96.   120000+4800+68+0.1=124868.1
    
97.   100^(195-193-0)(13-1)+
    
98.    100^(195-193-1)(49-1)+100^(195-193-2)(69-1) +100^(195-193-3)(11-1)
    
99.    ----
    
100.    ----
     
101.    
     
102. 
     
103. 
     
104. 
     
105. 
     

复制代码