模拟storage copy 功能失败的记录

最新推荐文章于 2025-04-24 13:38:01 发布

转载最新推荐文章于 2025-04-24 13:38:01 发布 · 126 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/355761

文章标签：

#数据库

本文记录了一次Oracle数据库恢复过程中的遇到的问题及解决方法。通过尝试不同的启动方式与恢复手段，最终实现了数据库的正常启动。实验中涉及了压缩拷贝$ORACLE_BASE目录、启动失败后的错误处理等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

试验设想：

机器1:

alter database begin backup

然后，在oracle仍然活动的状态下，将$ORACLE_BASE目录全部压缩拷贝到机器2

机器2:

startup：失败

startup mount--〉recover database。仍然失败

看来，storage copy 这种第三方的功能，应该是作了和数据库厂商之间的特殊配合。

Redo Buffers                5722112 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'


SQL>


SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1023004672 bytes
Fixed Size                  2259640 bytes
Variable Size             641729864 bytes
Database Buffers          373293056 bytes
Redo Buffers                5722112 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL>

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1023004672 bytes
Fixed Size                  2259640 bytes
Variable Size             641729864 bytes
Database Buffers          373293056 bytes
Redo Buffers                5722112 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[7], [47781], [47787], [], [], [], [], [], [], []

SQL>