课程第37次（2017-06-13星期二）制造逻辑坏块样本+制造物理坏块样本

botang

1. 制造逻辑坏块样本：
1.1 PL/SQL Developper以sys用户执行:

1. select  t.tablespace_name, t.status
   
2. from dba_tablespaces t;
   
3. 
   
4. create tablespace tbs1 datafile size 10M nologging;

复制代码

1.2 SQL*PLUS以hr用户执行：

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 19:32:09 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn hr/oracle_4U
   
8. Connected.
   
9. SQL> create table t05218( a number , b varchar2(20)) tablespace tbs1;
   
10. 
    
11. Table created.
    
12. 
    
13. SQL> insert into t05218 values ( 179032 ,'seenanything'  );
    
14. 
    
15. 1 row created.
    
16. 
    
17. SQL> commit;
    
18. 
    
19. Commit complete.
    
20. 
    
21. SQL> create index i05218_a  on t05218(a) ;
    
22. 
    
23. Index created.
    
24. 
    
25. SQL> create index i05218_b  on t05218(b) ;
    
26. 
    
27. Index created.
    
28. 
    
29. SQL>
    

复制代码

1.3 RMAN备份：

1. [oracle@station90 ~]$ rman target  /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 13 19:40:58 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1343950367)
   
8. 
   
9. RMAN> backup tag 'for_logical_broken' tablespace tbs1;
   
10. 
    
11. Starting backup at 13-JUN-17
    
12. using target database control file instead of recovery catalog
    
13. allocated channel: ORA_SBT_TAPE_1
    
14. channel ORA_SBT_TAPE_1: SID=201 device type=SBT_TAPE
    
15. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
16. allocated channel: ORA_SBT_TAPE_2
    
17. channel ORA_SBT_TAPE_2: SID=13 device type=SBT_TAPE
    
18. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
19. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
20. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
21. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.267.946582309
    
22. channel ORA_SBT_TAPE_1: starting piece 1 at 13-JUN-17
    
23. channel ORA_SBT_TAPE_1: finished piece 1 at 13-JUN-17
    
24. piece handle=17s6ndcm_1_1 tag=FOR_LOGICAL_BROKEN comment=API Version 2.0,MMS Version 10.4.0.4
    
25. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:05
    
26. Finished backup at 13-JUN-17
    
27. 
    
28. Starting Control File and SPFILE Autobackup at 13-JUN-17
    
29. piece handle=c-1343950367-20170613-01 comment=API Version 2.0,MMS Version 10.4.0.4
    
30. Finished Control File and SPFILE Autobackup at 13-JUN-17
    
31. 
    
32. RMAN>
    

复制代码

1.4 检查64进制的小程序：

1. #!/bin/sh
   
2. 
   
3. LIST="A B C D E F G H I J K L M N O P Q R S T U V W X Y Z a b c d e f g h i j k l m n o p q r s t u v w x y z 0 1 2 3 4 5 6 7 8 9 + /"
   
4. 
   
5. 
   
6. read -p "Pleas input a base64 code: " INPUT
   
7. COUNT=0
   
8. 
   
9. for i in $LIST
   
10. do
    
11. if [ $INPUT == $i ]
    
12. then
    
13.   echo $COUNT
    
14. else
    
15.   COUNT=$[ $COUNT + 1 ]
    
16. fi
    
17. done
    

复制代码

1.5 开始逻辑坏块制作：

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 19:44:38 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn hr/oracle_4U
   
8. Connected.
   
9. SQL> insert /*+ append */ into t05218 select  * from t05218;
   
10. 
    
11. 1 row created.
    
12. 
    
13. SQL> commit;
    
14. 
    
15. Commit complete.
    
16. 
    
17. SQL> select  * from t05218;
    
18. [oracle@station90 ~]$ sqlplus /nolog
    
19. 
    
20. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 19:44:38 2017
    
21. 
    
22. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
23. 
    
24. SQL> conn hr/oracle_4U
    
25. Connected.
    
26. SQL> insert /*+ append */ into t05218 select  * from t05218;
    
27. 
    
28. 1 row created.
    
29. 
    
30. SQL> commit;
    
31. 
    
32. Commit complete.
    
33. 
    
34. SQL> select  * from t05218;
    
35. 
    
36.      A B
    
37. ---------- --------------------
    
38.     179032 seenanything
    
39.     179032 seenanything
    
40. 
    
41. SQL> select  a,b, substr(rowid,10,6) from t05218;
    
42. 
    
43.      A B            SUBSTR(ROWID,10,6)
    
44. ---------- -------------------- ------------------------
    
45.     179032 seenanything     AAAACH
    
46.     179032 seenanything     AAAACI
    
47. 
    
48. SQL> select  a,b, substr(rowid,10,6), dbms_rowid.rowid_block_number(rowid)  from t05218;
    
49. 
    
50.      A B            SUBSTR(ROWID,10,6)
    
51. ---------- -------------------- ------------------------
    
52. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
    
53. ------------------------------------
    
54.     179032 seenanything     AAAACH
    
55.                  135
    
56. 
    
57.     179032 seenanything     AAAACI
    
58.                  136
    
59. 
    
60.          A B
    
61. ---------- --------------------
    
62.     179032 seenanything
    
63.     179032 seenanything
    
64. 
    
65. SQL> select  a,b, substr(rowid,10,6) from t05218;
    
66. 
    
67.          A B                        SUBSTR(ROWID,10,6)
    
68. ---------- -------------------- ------------------------
    
69.     179032 seenanything         AAAACH
    
70.     179032 seenanything         AAAACI
    
71. 
    
72. SQL> select  a,b, substr(rowid,10,6), dbms_rowid.rowid_block_number(rowid)  from t05218;
    
73. 
    
74.          A B                        SUBSTR(ROWID,10,6)
    
75. ---------- -------------------- ------------------------
    
76. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
    
77. ------------------------------------
    
78.     179032 seenanything         AAAACH
    
79.                                  135[oracle@station90 ~]$ sqlplus /nolog
    
80. 
    
81. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 20:21:55 2017
    
82. 
    
83. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
84. 
    
85. SQL> conn hr/oracle_4U
    
86. Connected.
    
87. SQL> select  department_id, dbms_rowid.rowid_block_number(rowid) from departments;
    
88. 
    
89. DEPARTMENT_ID DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
    
90. ------------- ------------------------------------
    
91.        10                       175
    
92.        20                       175
    
93.        30                       175
    
94.        40                       175
    
95.        50                       175
    
96.        60                       175
    
97.        70                       175
    
98.        80                       175
    
99.        90                       175
    
100.       100                       175
     
101.       110                       175
     
102. 
     
103. DEPARTMENT_ID DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
     
104. ------------- ------------------------------------
     
105.       120                       175
     
106.       130                       175
     
107.       140                       175
     
108.       150                       175
     
109.       160                       175
     
110.       170                       175
     
111.       180                       175
     
112.       190                       175
     
113.       200                       175
     
114.       210                       175
     
115.       220                       175
     
116. 
     
117. DEPARTMENT_ID DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
     
118. ------------- ------------------------------------
     
119.       230                       175
     
120.       240                       175
     
121.       250                       175
     
122.       260                       175
     
123.       270                       175
     
124. 
     
125. 27 rows selected.
     
126. 
     
127. SQL>
     
128. 
     
129. 
     
130.     179032 seenanything         AAAACI
     
131.                                  136
     

复制代码

1.6 破坏这个表空间：

1.7 RMAN恢复（没有日志情况下）：

1. [oracle@station90 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 13 20:13:01 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1343950367)
   
8. 
   
9. RMAN> restore tablespace tbs1;
   
10. 
    
11. Starting restore at 13-JUN-17
    
12. using target database control file instead of recovery catalog
    
13. allocated channel: ORA_DISK_1
    
14. channel ORA_DISK_1: SID=138 device type=DISK
    
15. allocated channel: ORA_DISK_2
    
16. channel ORA_DISK_2: SID=201 device type=DISK
    
17. allocated channel: ORA_DISK_3
    
18. channel ORA_DISK_3: SID=11 device type=DISK
    
19. allocated channel: ORA_DISK_4
    
20. channel ORA_DISK_4: SID=75 device type=DISK
    
21. allocated channel: ORA_DISK_5
    
22. channel ORA_DISK_5: SID=140 device type=DISK
    
23. allocated channel: ORA_DISK_6
    
24. channel ORA_DISK_6: SID=198 device type=DISK
    
25. allocated channel: ORA_DISK_7
    
26. channel ORA_DISK_7: SID=16 device type=DISK
    
27. allocated channel: ORA_DISK_8
    
28. channel ORA_DISK_8: SID=74 device type=DISK
    
29. allocated channel: ORA_SBT_TAPE_1
    
30. channel ORA_SBT_TAPE_1: SID=144 device type=SBT_TAPE
    
31. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
32. allocated channel: ORA_SBT_TAPE_2
    
33. channel ORA_SBT_TAPE_2: SID=18 device type=SBT_TAPE
    
34. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
35. 
    
36. channel ORA_SBT_TAPE_1: starting datafile backup set restore
    
37. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
    
38. channel ORA_SBT_TAPE_1: restoring datafile 00006 to +DATA/orcl/datafile/tbs1.267.946582309
    
39. channel ORA_SBT_TAPE_1: reading from backup piece 17s6ndcm_1_1
    
40. channel ORA_SBT_TAPE_1: piece handle=17s6ndcm_1_1 tag=FOR_LOGICAL_BROKEN
    
41. channel ORA_SBT_TAPE_1: restored backup piece 1
    
42. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
    
43. Finished restore at 13-JUN-17
    
44. 
    
45. RMAN> recover tablespace tbs1;
    
46. 
    
47. Starting recover at 13-JUN-17
    
48. using channel ORA_DISK_1
    
49. using channel ORA_DISK_2
    
50. using channel ORA_DISK_3
    
51. using channel ORA_DISK_4
    
52. using channel ORA_DISK_5
    
53. using channel ORA_DISK_6
    
54. using channel ORA_DISK_7
    
55. using channel ORA_DISK_8
    
56. using channel ORA_SBT_TAPE_1
    
57. using channel ORA_SBT_TAPE_2
    
58. 
    
59. starting media recovery
    
60. media recovery complete, elapsed time: 00:00:00
    
61. 
    
62. Finished recover at 13-JUN-17
    
63. 
    
64. RMAN>
    

复制代码

测一下：

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 20:15:25 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn hr/oracle_4U
   
8. Connected.
   
9. SQL> select  * from t05218;
   
10. ERROR:
    
11. ORA-01578: ORACLE data block corrupted (file # 6, block # 136)
    
12. ORA-01110: data file 6: '+DATA/orcl/datafile/tbs1.267.946582309'
    
13. ORA-26040: Data block was loaded using the NOLOGGING option
    
14. 
    
15. 
    
16. 
    
17. no rows selected
    

复制代码

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 20:15:25 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn hr/oracle_4U
   
8. Connected.
   
9. SQL> select  * from t05218;
   
10. ERROR:
    
11. ORA-01578: ORACLE data block corrupted (file # 6, block # 136)
    
12. ORA-01110: data file 6: '+DATA/orcl/datafile/tbs1.267.946582309'
    
13. ORA-26040: Data block was loaded using the NOLOGGING option
    
14. 
    
15. 
    
16. 
    
17. no rows selected
    
18. 
    
19. SQL> select  * from t05218;
    
20. ERROR:
    
21. ORA-01578: ORACLE data block corrupted (file # 6, block # 136)
    
22. ORA-01110: data file 6: '+DATA/orcl/datafile/tbs1.267.946582309'
    
23. ORA-26040: Data block was loaded using the NOLOGGING option
    
24. 
    
25. 
    
26. 
    
27. no rows selected
    
28. 
    

复制代码

2. 物理坏块制作:

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 20:21:55 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn hr/oracle_4U
   
8. Connected.
   
9. SQL> select  department_id, dbms_rowid.rowid_block_number(rowid) from departments;
   
10. 
    
11. DEPARTMENT_ID DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
    
12. ------------- ------------------------------------
    
13.            10                                       175
    
14.            20                                       175
    
15.            30                                       175
    
16.            40                                       175
    
17.            50                                       175
    
18.            60                                       175
    
19.            70                                       175
    
20.            80                                       175
    
21.            90                                       175
    
22.           100                                       175
    
23.           110                                       175
    
24. 
    
25. DEPARTMENT_ID DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
    
26. ------------- ------------------------------------
    
27.           120                                       175
    
28.           130                                       175
    
29.           140                                       175
    
30.           150                                       175
    
31.           160                                       175
    
32.           170                                       175
    
33.           180                                       175
    
34.           190                                       175
    
35.           200                                       175
    
36.           210                                       175
    
37.           220                                       175
    
38. 
    
39. DEPARTMENT_ID DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
    
40. ------------- ------------------------------------
    
41.           230                                       175
    
42.           240                                       175
    
43.           250                                       175
    
44.           260                                       175
    
45.           270                                       175
    
46. 
    
47. 27 rows selected.
    
48. 
    
49. SQL>
    

复制代码

物理坏块脚本physical-block11.2.0.1.sh：

1. #!/bin/sh
   
2. v_dbname=orcl
   
3. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl stop database -d $v_dbname -o abort"
   
4. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog" <<EOF
   
5. conn / as sysdba
   
6. startup mount exclusive
   
7. EOF
   
8. 
   
9. rm -f /home/oracle/example01.dbf 2>/dev/null
   
10. 
    
11. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
12. backup as copy datafile 5 format '/home/oracle/example01.dbf';
    
13. EOF
    
14. 
    
15. dd if=/dev/zero of=/home/oracle/example01.dbf bs=8192 count=1 seek=175 conv=notrunc
    
16. 
    
17. su - oracle -c "export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid ; export ORACLE_SID=+ASM ; /u01/app/oracle/product/11.2.0/grid/bin/asmcmd" <<EOF
    
18. rm -f +data/$v_dbname/DATAFILE/example*
    
19. EOF
    
20. 
    
21. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
22. run {
    
23. set maxcorrupt for datafile 5 to 1;
    
24. backup as copy  datafilecopy '/home/oracle/example01.dbf' format '+data';
    
25. }
    
26. EOF
    
27. 
    
28. sleep 3
    
29. 
    
30. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
31. delete noprompt datafilecopy '/home/oracle/example01.dbf';
    
32. switch datafile 5 to copy;
    
33. EOF
    
34. 
    
35. 
    
36. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog" <<EOF
    
37. conn / as sysdba
    
38. alter database open;
    
39. EOF

复制代码

执行：

1. [root@station90 ~]# /home/oracle/physical-block11.2.0.1.sh
   
2. 
   
3. 
   
4. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 20:30:53 2017
   
5. 
   
6. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
7. 
   
8. SQL> Connected to an idle instance.
   
9. SQL> ORACLE instance started.
   
10. 
    
11. Total System Global Area 6680915968 bytes
    
12. Fixed Size                    2213936 bytes
    
13. Variable Size                 3556771792 bytes
    
14. Database Buffers         3087007744 bytes
    
15. Redo Buffers                   34922496 bytes
    
16. Database mounted.
    
17. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
18. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
19. and Real Application Testing options
    
20. 
    
21. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 13 20:31:01 2017
    
22. 
    
23. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
24. 
    
25. connected to target database: ORCL (DBID=1343950367, not open)
    
26. 
    
27. RMAN>
    
28. Starting backup at 13-JUN-17
    
29. using target database control file instead of recovery catalog
    
30. allocated channel: ORA_DISK_1
    
31. channel ORA_DISK_1: SID=68 device type=DISK
    
32. allocated channel: ORA_DISK_2
    
33. channel ORA_DISK_2: SID=131 device type=DISK
    
34. allocated channel: ORA_DISK_3
    
35. channel ORA_DISK_3: SID=192 device type=DISK
    
36. allocated channel: ORA_DISK_4
    
37. channel ORA_DISK_4: SID=8 device type=DISK
    
38. allocated channel: ORA_DISK_5
    
39. channel ORA_DISK_5: SID=69 device type=DISK
    
40. allocated channel: ORA_DISK_6
    
41. channel ORA_DISK_6: SID=132 device type=DISK
    
42. allocated channel: ORA_DISK_7
    
43. channel ORA_DISK_7: SID=193 device type=DISK
    
44. allocated channel: ORA_DISK_8
    
45. channel ORA_DISK_8: SID=9 device type=DISK
    
46. channel ORA_DISK_1: starting datafile copy
    
47. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
    
48. output file name=/home/oracle/example01.dbf tag=TAG20170613T203104 RECID=2 STAMP=946585865
    
49. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
    
50. Finished backup at 13-JUN-17
    
51. 
    
52. Starting Control File and SPFILE Autobackup at 13-JUN-17
    
53. piece handle=+FRA/orcl/autobackup/2017_06_13/s_946585768.268.946585867 comment=NONE
    
54. Finished Control File and SPFILE Autobackup at 13-JUN-17
    
55. 
    
56. RMAN>
    
57. 
    
58. Recovery Manager complete.
    
59. 记录了1+0 的读入
    
60. 记录了1+0 的写出
    
61. 8192字节(8.2 kB)已复制，2.293e-05 秒，357 MB/秒
    
62. ASMCMD> ASMCMD> exit
    
63. 
    
64. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 13 20:31:07 2017
    
65. 
    
66. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
67. 
    
68. connected to target database: ORCL (DBID=1343950367, not open)
    
69. 
    
70. RMAN> 2> 3> 4>
    
71. executing command: SET MAX CORRUPT
    
72. using target database control file instead of recovery catalog
    
73. 
    
74. Starting backup at 13-JUN-17
    
75. allocated channel: ORA_DISK_1
    
76. channel ORA_DISK_1: SID=68 device type=DISK
    
77. allocated channel: ORA_DISK_2
    
78. channel ORA_DISK_2: SID=131 device type=DISK
    
79. allocated channel: ORA_DISK_3
    
80. channel ORA_DISK_3: SID=193 device type=DISK
    
81. allocated channel: ORA_DISK_4
    
82. channel ORA_DISK_4: SID=8 device type=DISK
    
83. allocated channel: ORA_DISK_5
    
84. channel ORA_DISK_5: SID=69 device type=DISK
    
85. allocated channel: ORA_DISK_6
    
86. channel ORA_DISK_6: SID=132 device type=DISK
    
87. allocated channel: ORA_DISK_7
    
88. channel ORA_DISK_7: SID=191 device type=DISK
    
89. allocated channel: ORA_DISK_8
    
90. channel ORA_DISK_8: SID=7 device type=DISK
    
91. channel ORA_DISK_1: starting datafile copy
    
92. input is copy of datafile 00005: /home/oracle/example01.dbf
    
93. output file name=+DATA/orcl/datafile/example.265.946585871 tag=TAG20170613T203104 RECID=3 STAMP=946585871
    
94. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
    
95. Finished backup at 13-JUN-17
    
96. 
    
97. Starting Control File and SPFILE Autobackup at 13-JUN-17
    
98. piece handle=+FRA/orcl/autobackup/2017_06_13/s_946585768.269.946585871 comment=NONE
    
99. Finished Control File and SPFILE Autobackup at 13-JUN-17
    
100. 
     
101. RMAN>
     
102. 
     
103. Recovery Manager complete.
     
104. 
     
105. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 13 20:31:15 2017
     
106. 
     
107. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
108. 
     
109. connected to target database: ORCL (DBID=1343950367, not open)
     
110. 
     
111. RMAN>
     
112. using target database control file instead of recovery catalog
     
113. allocated channel: ORA_DISK_1
     
114. channel ORA_DISK_1: SID=68 device type=DISK
     
115. allocated channel: ORA_DISK_2
     
116. channel ORA_DISK_2: SID=131 device type=DISK
     
117. allocated channel: ORA_DISK_3
     
118. channel ORA_DISK_3: SID=191 device type=DISK
     
119. allocated channel: ORA_DISK_4
     
120. channel ORA_DISK_4: SID=8 device type=DISK
     
121. allocated channel: ORA_DISK_5
     
122. channel ORA_DISK_5: SID=69 device type=DISK
     
123. allocated channel: ORA_DISK_6
     
124. channel ORA_DISK_6: SID=132 device type=DISK
     
125. allocated channel: ORA_DISK_7
     
126. channel ORA_DISK_7: SID=192 device type=DISK
     
127. allocated channel: ORA_DISK_8
     
128. channel ORA_DISK_8: SID=9 device type=DISK
     
129. List of Datafile Copies
     
130. =======================
     
131. 
     
132. Key     File S Completion Time Ckp SCN    Ckp Time      
     
133. ------- ---- - --------------- ---------- ---------------
     
134. 2       5    A 13-JUN-17       1072330    13-JUN-17      
     
135.         Name: /home/oracle/example01.dbf
     
136.         Tag: TAG20170613T203104
     
137. 
     
138. deleted datafile copy
     
139. datafile copy file name=/home/oracle/example01.dbf RECID=2 STAMP=946585865
     
140. Deleted 1 objects
     
141. 
     
142. 
     
143. RMAN>
     
144. datafile 5 switched to datafile copy "+DATA/orcl/datafile/example.265.946585871"
     
145. 
     
146. RMAN>
     
147. 
     
148. Recovery Manager complete.
     
149. 
     
150. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 20:31:19 2017
     
151. 
     
152. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
153. 
     
154. SQL> Connected.
     
155. SQL>
     
156. Database altered.
     
157. 
     
158. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
159. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
160. and Real Application Testing options
     

复制代码

1. [oracle@station90 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 13 20:36:18 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1343950367)
   
8. 
   
9. RMAN> list backup of tablespace example;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. 
    
13. List of Backup Sets
    
14. ===================
    
15. 
    
16. 
    
17. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
18. ------- ---- -- ---------- ----------- ------------ ---------------
    
19. 35      Incr 0  657.75M    SBT_TAPE    00:00:27     18-MAY-17      
    
20.         BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
    
21.         Handle: 12s4ih4j_1_1   Media: station90-000001
    
22.   List of Datafiles in backup set 35
    
23.   File LV Type Ckp SCN    Ckp Time  Name
    
24.   ---- -- ---- ---------- --------- ----
    
25.   5    0  Incr 1057421    18-MAY-17 +DATA/orcl/datafile/example.265.946585871
    

复制代码

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 13 20:32:32 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn hr/oracle_4U
   
8. Connected.
   
9. SQL> select  * from departments;
   
10. select        * from departments
    
11.                *
    
12. ERROR at line 1:
    
13. ORA-01578: ORACLE data block corrupted (file # 5, block # 175)
    
14. ORA-01110: data file 5: '+DATA/orcl/datafile/example.265.946585871'
    
15. 
    

复制代码