Get the App
SLTechnology News&Howtos  ›  Database  › 

Bootstrap$, you are so special.

Shulou Source: shulou.com Published: 2022-06-01 15:15:25 11月14日 Update

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.

Tags: Data database business method special dictionary characteristic phenomenon result ethics non-business non-business processing influence contact operation goodbye too special Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Technology Apple Huawei Xiaomi Shulou Information