Shulou(Shulou.com)06/01 Report--

I. explanation

The Oracle database has a very special base table, which you can delete delete from bootstrap$.

Features:

1. Base table (data dictionary table)

2. After deleting the data, it is almost impossible to find it.

3. An error is reported after the database is restarted and cannot be started.

4. Non-business data will not be lost.

5. DBA with no morality and no bottom line will be used by the next generation to dig holes.

II. Phenomenon

SQL > select count (*) from bootstrap$

The result is 0

The database can operate normally and does not affect the business.

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL >

SQL > startup

ORACLE instance started.

Total System Global Area 3089920000 bytes

Fixed Size 2257232 bytes

Variable Size 654315184 bytes

Database Buffers 2415919104 bytes

Redo Buffers 17428480 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-00702: bootstrap verison''inconsistent with version' 8.0.0.0.0'

Process ID: 13563

Session ID: 572 Serial number: 3

SQL >

How to handle it: use BBED to copy the block, because no business data is involved, so there is no data loss. You can contact me for specific recovery methods.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.