重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: ORA-01172、ORA-01151错误处理 [打印本页]

作者: jiawang 时间: 2023-5-15 16:29
标题: ORA-01172、ORA-01151错误处理

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1124073472 bytes

Fixed Size                1218968 bytes

Variable Size          385877608 bytes

Database Buffers       721420288 bytes

Redo Buffers             15556608 bytes

Database mounted.

打开数据库发现报错

SQL> alter database open;

ORA-01172: recovery of thread 1 stuck at block 6251 of file 6

ORA-01151: use media recovery to recover block, restore backup if needed

SQL> recover datafile 6;

Media recovery complete.

SQL> alter database open;

Database altered.

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)