system数据文件520块损坏修复--bbed

关于这个数据块就不做多的介绍，网上有很多资料

1. SQL> select header_file,header_block from dba_segments where segment_name='BOOTSTRAP$';
   
2.  
   
3. HEADER_FILE HEADER_BLOCK
   
4. ----------- ------------
   
5.           1 520

下面试验几种段头块被破坏，恢复的情况
1、使用离线备份
2、复制同位置 好的数据块
3、修改为原来的值

1、使用离线备份

1. [oracle@kvm61 ~]$ cp /oracle/oradata/sdk/system01.dbf /oracle/oradata/sdk/system01.dbf.2

同时加入到bbed配置中

1. [oracle@kvm61 ~]$ vi bbed.conf
2. 1 /oracle/oradata/sdk/system01.dbf 723517440
3. 2 /oracle/oradata/sdk/sysaux01.dbf 639631360
4. 3 /oracle/oradata/sdk/undotbs01.dbf 204472320
5. 4 /oracle/oradata/sdk/users01.dbf 595066880
6. 5 /oracle/oradata/sdk/example01.dbf 108134400
7. 6 /oracle/scripts/sql/TBS_A.DBF 25165824
8. 7 /oracle/oradata/sdk/users01.dbf.2 595066880
9. 8 /oracle/oradata/sdk/system01.dbf.2 723517440

1. [root@kvm61 ~]# su - oracle
2. [oracle@kvm61 ~]$ bbed
3. Password:
5. BBED: Release 2.0.0.0.0 - Limited Production on 星期四 6月 23 13:53:33 2016
7. Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
9. ************* !!! For Oracle Internal Use only !!! ***************
11. BBED> set file 1 block 520
12. FILE# 1
13. BLOCK# 520
15. BBED> show
16. FILE# 1
17. BLOCK# 520
18. OFFSET 0
19. DBA 0x00400208 (4194824 1,520)
20. FILENAME /oracle/oradata/sdk/system01.dbf
21. BIFILE bifile.bbd
22. LISTFILE /home/oracle/bbed.conf
23. BLOCKSIZE 8192
24. MODE Edit
25. EDIT Unrecoverable
26. IBASE Dec
27. OBASE Dec
28. WIDTH 80
29. COUNT 512
30. LOGFILE log.bbd
31. SPOOL No
33. BBED> dump
34. File: /oracle/oradata/sdk/system01.dbf (1)
35. Block: 520 Offsets: 0 to 511 Dba:0x00400208
36. ------------------------------------------------------------------------
37. 10a20000 08024000 4b020000 00000104 43e40000 00000000 00000000 00000000
38. 00000000 01000000 07000000 20100000 00000000 03000000 07000000 0c024000
39. 00000000 00000000 01000000 03000000 00000000 00000000 00000000 01000000
40. 00000000 3b000000 00000040 09024000 07000000 00000000 00000000 00000000
41. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
42. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
43. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
44. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
45. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
46. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
47. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
48. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
49. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
50. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
51. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
52. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
54. <32 bytes="" per="" line="">

修改 破坏数据块

1. BBED> modify 1111 file 1 block 520
2. File: /oracle/oradata/sdk/system01.dbf (1)
3. Block: 520 Offsets: 0 to 511 Dba:0x00400208
4. ------------------------------------------------------------------------
5. 04570000 08024000 4b020000 00000104 43e40000 00000000 00000000 00000000
6. 00000000 01000000 07000000 20100000 00000000 03000000 07000000 0c024000
7. 00000000 00000000 01000000 03000000 00000000 00000000 00000000 01000000
8. 00000000 3b000000 00000040 09024000 07000000 00000000 00000000 00000000
9. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
10. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
11. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
12. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
13. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
14. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
15. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
16. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
17. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
18. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
19. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
20. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
22. <32 bytes="" per="" line="">

校验文件

1. BBED> verify file 1
2. DBVERIFY - Verification starting
3. FILE = /oracle/oradata/sdk/system01.dbf
5. Block 520 is corrupt
6. Corrupt block relative dba: 0x00400208 (file 0, block 520)
7. Bad header found during verification
8. Data in bad block:
9. type: 4 format: 7 rdba: 0x00400208
10. last change scn: 0x0000.0000024b seq: 0x1 flg: 0x04
11. spare1: 0x0 spare2: 0x0 spare3: 0x0
12. consistency value in tail: 0x024b1001
13. check value in block header: 0xe443
14. computed block checksum: 0xf514
17. DBVERIFY - Verification complete
19. Total Blocks Examined : 88320
20. Total Blocks Processed (Data) : 59588
21. Total Blocks Failing (Data) : 0
22. Total Blocks Processed (Index): 12419
23. Total Blocks Failing (Index): 0
24. Total Blocks Empty : 12896
25. Total Blocks Marked Corrupt : 1
26. Total Blocks Influx : 0
27. Message 531 not found; product=RDBMS; facility=BBED

启动报错

1. SQL> startup
   
2. ORACLE 例程已经启动。
   
3. 
   
4. Total System Global Area 513585152 bytes
   
5. Fixed Size 2214856 bytes
   
6. Variable Size 289408056 bytes
   
7. Database Buffers 213909504 bytes
   
8. Redo Buffers 8052736 bytes
   
9. 数据库装载完毕。
   
10. 
    
11. ORA-01092: ORACLE instance terminated. Disconnection forced
    
12. ORA-00704: bootstrap process failure
    
13. ORA-01578: ORACLE data block corrupted (file # 1, block # 520)
    
14. ORA-01110: data file 1: '/oracle/oradata/sdk/system01.dbf'
    
15. 进程 ID: 2782
    
16. 会话 ID: 125 序列号: 5

告警日志

1. Reading datafile '/oracle/oradata/sdk/system01.dbf' for corruption at rdba: 0x00400208 (file 1, block 520)
2. Reread (file 1, block 520) found same corrupt data
3. Errors in file /oracle/diag/rdbms/sdk/sdk/trace/sdk_ora_4528.trc (incident=55359):
4. ORA-01578: ORACLE 数据块损坏 (文件号 1, 块号 520)
5. ORA-01110: 数据文件 1: '/oracle/oradata/sdk/system01.dbf'
6. Incident details in: /oracle/diag/rdbms/sdk/sdk/incident/incdir_55359/sdk_ora_4528_i55359.trc
7. ARC3: Archival started
8. ARC0: STARTING ARCH PROCESSES COMPLETE
9. Errors in file /oracle/diag/rdbms/sdk/sdk/trace/sdk_ora_4528.trc:
10. ORA-00704: 引导程序进程失败
11. ORA-01578: ORACLE 数据块损坏 (文件号 1, 块号 520)
12. ORA-01110: 数据文件 1: '/oracle/oradata/sdk/system01.dbf'
13. Errors in file /oracle/diag/rdbms/sdk/sdk/trace/sdk_ora_4528.trc:
14. ORA-00704: 引导程序进程失败
15. ORA-01578: ORACLE 数据块损坏 (文件号 1, 块号 520)
16. ORA-01110: 数据文件 1: '/oracle/oradata/sdk/system01.dbf'
17. Error 704 happened during db open, shutting down database
18. USER (ospid: 4528): terminating the instance due to error 704
19. Instance terminated by USER, pid = 4528
20. ORA-1092 signalled during: ALTER DATABASE OPEN...
21. opiodr aborting process unknown ospid (4528) as a result of ORA-1092
22. Thu Jun 23 17:34:13 2016
23. ORA-1092 : opitsk aborting process

将备份的离线备份数据文件覆盖损坏的数据文件

再次启动数据库

1. SQL> startup
2. ORACLE 例程已经启动。
4. Total System Global Area 513585152 bytes
5. Fixed Size 2214856 bytes
6. Variable Size 289408056 bytes
7. Database Buffers 213909504 bytes
8. Redo Buffers 8052736 bytes
9. 数据库装载完毕。
10. ORA-01113: 文件 1 需要介质恢复
11. ORA-01110: 数据文件 1: '/oracle/oradata/sdk/system01.dbf'

做介质恢复

1. SQL> recover datafile 1
   
2. ORA-00279: 更改 2096976 (在 06/23/2016 01:00:08 生成) 对于线程 1 是必需的
   
3. ORA-00289: 建议: /archive/1_58_911404654.dbf
   
4. ORA-00280: 更改 2096976 (用于线程 1) 在序列 #58 中
   
5. 
   
6. 
   
7. 指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
   
8. AUTO
   
9. ORA-00279: 更改 2131469 (在 06/23/2016 13:53:05 生成) 对于线程 1 是必需的
   
10. ORA-00289: 建议: /archive/1_59_911404654.dbf
    
11. ORA-00280: 更改 2131469 (用于线程 1) 在序列 #59 中
    
12. 
    
13. 
    
14. ORA-00279: 更改 2152061 (在 06/23/2016 14:03:47 生成) 对于线程 1 是必需的
    
15. ORA-00289: 建议: /archive/1_60_911404654.dbf
    
16. ORA-00280: 更改 2152061 (用于线程 1) 在序列 #60 中
    
17. 
    
18. 
    
19. ORA-00279: 更改 2172753 (在 06/23/2016 14:13:37 生成) 对于线程 1 是必需的
    
20. ORA-00289: 建议: /archive/1_61_911404654.dbf
    
21. ORA-00280: 更改 2172753 (用于线程 1) 在序列 #61 中
    
22. 
    
23. 
    
24. ORA-00279: 更改 2192759 (在 06/23/2016 14:33:39 生成) 对于线程 1 是必需的
    
25. ORA-00289: 建议: /archive/1_62_911404654.dbf
    
26. ORA-00280: 更改 2192759 (用于线程 1) 在序列 #62 中
    
27. 
    
28. 
    
29. 已应用的日志。
    
30. 完成介质恢复。

方式二，使用备份的文件中的数据块进行恢复

1. BBED> set file 8
   
2.         FILE# 8
   
3. 
   
4. BBED> show
   
5.         FILE# 8
   
6.         BLOCK# 520
   
7.         OFFSET 0
   
8.         DBA 0x02000208 (33554952 8,520)
   
9.         FILENAME /oracle/oradata/sdk/system01.dbf.2
   
10.         BIFILE bifile.bbd
    
11.         LISTFILE /home/oracle/bbed.conf
    
12.         BLOCKSIZE 8192
    
13.         MODE Edit
    
14.         EDIT Unrecoverable
    
15.         IBASE Dec
    
16.         OBASE Dec
    
17.         WIDTH 80
    
18.         COUNT 512
    
19.         LOGFILE log.bbd
    
20.         SPOOL No
    
21. 
    
22. BBED> copy file 8 block 520 to file 1 block 520
    
23.  File: /oracle/oradata/sdk/system01.dbf (1)
    
24.  Block: 520 Offsets: 0 to 511 Dba:0x00400208
    
25. ------------------------------------------------------------------------
    
26.  10a20000 08024000 4b020000 00000104 43e40000 00000000 00000000 00000000
    
27.  00000000 01000000 07000000 20100000 00000000 03000000 07000000 0c024000
    
28.  00000000 00000000 01000000 03000000 00000000 00000000 00000000 01000000
    
29.  00000000 3b000000 00000040 09024000 07000000 00000000 00000000 00000000
    
30.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
31.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
32.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
33.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
34.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
35.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
36.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
37.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
38.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
39.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
40.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
41.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
42. 
    
43.  <32 bytes per line>
    
44. 
    
45. BBED> verify file 1
    
46. DBVERIFY - Verification starting
    
47. FILE = /oracle/oradata/sdk/system01.dbf
    
48. 
    
49. 
    
50. DBVERIFY - Verification complete
    
51. 
    
52. Total Blocks Examined : 88320
    
53. Total Blocks Processed (Data) : 59588
    
54. Total Blocks Failing (Data) : 0
    
55. Total Blocks Processed (Index): 12419
    
56. Total Blocks Failing (Index): 0
    
57. Total Blocks Empty : 12896
    
58. Total Blocks Marked Corrupt : 0
    
59. Total Blocks Influx : 0
    
60. Message 531 not found; product=RDBMS; facility=BBED
    
61. 
    
62. SQL> connect / as sysdba
    
63. 已连接到空闲例程。
    
64. SQL>
    
65. SQL> startup
    
66. ORACLE 例程已经启动。
    
67. 
    
68. Total System Global Area 513585152 bytes
    
69. Fixed Size 2214856 bytes
    
70. Variable Size 289408056 bytes
    
71. Database Buffers 213909504 bytes
    
72. Redo Buffers 8052736 bytes
    
73. 数据库装载完毕。
    
74. 数据库已经打开。

修改损坏的块为原来的值

1. [oracle@kvm61 ~]$ bbed
   
2. Password:
   
3. 
   
4. BBED: Release 2.0.0.0.0 - Limited Production on 星期四 6月 23 16:06:28 2016
   
5. 
   
6. Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
   
7. 
   
8. ************* !!! For Oracle Internal Use only !!! ***************
   
9. 
   
10. BBED> set file 1 block 520
    
11.         FILE# 1
    
12.         BLOCK# 520
    
13. 
    
14. BBED> dump
    
15.  File: /oracle/oradata/sdk/system01.dbf (1)
    
16.  Block: 520 Offsets: 0 to 511 Dba:0x00400208
    
17. ------------------------------------------------------------------------
    
18.  10a20000 08024000 4b020000 00000104 43e40000 00000000 00000000 00000000
    
19.  00000000 01000000 07000000 20100000 00000000 03000000 07000000 0c024000
    
20.  00000000 00000000 01000000 03000000 00000000 00000000 00000000 01000000
    
21.  00000000 3b000000 00000040 09024000 07000000 00000000 00000000 00000000
    
22.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
23.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
24.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
25.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
26.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
27.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
28.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
29.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
30.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
31.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
32.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
33.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
34. 
    
35.  <32 bytes per line>
    
36. 
    
37. 模拟损坏：
    
38. 
    
39. BBED> modify /x ffff file 1 block 520
    
40. Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) Y
    
41.  File: /oracle/oradata/sdk/system01.dbf (1)
    
42.  Block: 520 Offsets: 0 to 511 Dba:0x00400208
    
43. ------------------------------------------------------------------------
    
44.  ffff0000 08024000 4b020000 00000104 43e40000 00000000 00000000 00000000
    
45.  00000000 01000000 07000000 20100000 00000000 03000000 07000000 0c024000
    
46.  00000000 00000000 01000000 03000000 00000000 00000000 00000000 01000000
    
47.  00000000 3b000000 00000040 09024000 07000000 00000000 00000000 00000000
    
48.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
49.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
50.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
51.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
52.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
53.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
54.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
55.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
56.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
57.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
58.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
59.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    
60. 
    
61.  <32 bytes per line>
    
62. 
    
63. BBED> verify file 1
    
64. DBVERIFY - Verification starting
    
65. FILE = /oracle/oradata/sdk/system01.dbf
    
66. 
    
67. Block 520 is corrupt
    
68. Corrupt block relative dba: 0x00400208 (file 0, block 520)
    
69. Bad header found during verification
    
70. Data in bad block:
    
71.  type: 255 format: 7 rdba: 0x00400208
    
72.  last change scn: 0x0000.0000024b seq: 0x1 flg: 0x04
    
73.  spare1: 0x0 spare2: 0x0 spare3: 0x0
    
74.  consistency value in tail: 0x024b1001
    
75.  check value in block header: 0xe443
    
76.  computed block checksum: 0x5def
    
77. 
    
78. 
    
79. DBVERIFY - Verification complete
    
80. 
    
81. Total Blocks Examined : 88320
    
82. Total Blocks Processed (Data) : 59588
    
83. Total Blocks Failing (Data) : 0
    
84. Total Blocks Processed (Index): 12419
    
85. Total Blocks Failing (Index): 0
    
86. Total Blocks Empty : 12896
    
87. Total Blocks Marked Corrupt : 1
    
88. Total Blocks Influx : 0
    
89. Message 531 not found; product=RDBMS; facility=BBED
    
90. 
    
91. 
    
92. BBED> dump
    
93.  File: /oracle/oradata/sdk/system01.dbf (1)
    
94.  Block: 520 Offsets: 0 to 511 Dba:0x00400208
    
95. ------------------------------------------------------------------------
    
96.  ffff0000 08024000 4b020000 00000104 43e40000 00000000 00000000 00000000
    
97.  00000000 01000000 07000000 20100000 00000000 03000000 07000000 0c024000
    
98.  00000000 00000000 01000000 03000000 00000000 00000000 00000000 01000000
    
99.  00000000 3b000000 00000040 09024000 07000000 00000000 00000000 00000000
    
100.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
101.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
102.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
103.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
104.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
105.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
106.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
107.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
108.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
109.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
110.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
111.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
112. 
     
113.  <32 bytes per line>
     
114. 
     
115. SQL> startup
     
116. ORACLE 例程已经启动。
     
117. 
     
118. Total System Global Area 513585152 bytes
     
119. Fixed Size 2214856 bytes
     
120. Variable Size 289408056 bytes
     
121. Database Buffers 213909504 bytes
     
122. Redo Buffers 8052736 bytes
     
123. 数据库装载完毕。
     
124. ORA-01092: ORACLE instance terminated. Disconnection forced
     
125. ORA-00704: bootstrap process failure
     
126. ORA-01578: ORACLE data block corrupted (file # 1, block # 520)
     
127. ORA-01110: data file 1: '/oracle/oradata/sdk/system01.dbf'
     
128. 进程 ID: 3598
     
129. 会话 ID: 125 序列号: 5
     
130. 
     
131. 
     
132. 将修改的数据块修改回去
     
133. 
     
134. BBED> modify /x 10a2 file 1 block 520
     
135.  File: /oracle/oradata/sdk/system01.dbf (1)
     
136.  Block: 520 Offsets: 0 to 511 Dba:0x00400208
     
137. ------------------------------------------------------------------------
     
138.  10a20000 08024000 4b020000 00000104 43e40000 00000000 00000000 00000000
     
139.  00000000 01000000 07000000 20100000 00000000 03000000 07000000 0c024000
     
140.  00000000 00000000 01000000 03000000 00000000 00000000 00000000 01000000
     
141.  00000000 3b000000 00000040 09024000 07000000 00000000 00000000 00000000
     
142.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
143.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
144.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
145.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
146.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
147.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
148.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
149.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
150.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
151.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
152.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
153.  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
     
154. 
     
155.  <32 bytes per line>
     
156. 
     
157. SQL> startup
     
158. ORACLE 例程已经启动。
     
159. 
     
160. Total System Global Area 513585152 bytes
     
161. Fixed Size 2214856 bytes
     
162. Variable Size 289408056 bytes
     
163. Database Buffers 213909504 bytes
     
164. Redo Buffers 8052736 bytes
     
165. 数据库装载完毕。
     
166. 数据库已经打开。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29023300/viewspace-2121078/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29023300/viewspace-2121078/