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

标题: 数据库无法启动报ORA-10873 [打印本页]

作者: jiawang 时间: 2019-6-28 09:42
标题: 数据库无法启动报ORA-10873
克隆数据库，重新启动时发现数据库无法打开，提示有如下的错误：
SQL> startup
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size                2213896 bytes
Variable Size          1040189432 bytes
Database Buffers       603979776 bytes
Redo Buffers             7135232 bytes
Database mounted.
ORA-10873: file 5 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 5: '+DATA/orcl/datafile/example.265.877207037'

经检查，是因为在移动数据文件+DATA/orcl/datafile/example.265.877207037没有及时结束backup;
结束backup后，数据库可正常打开，如下：
SQL> alter tablespace example end backup;
Tablespace altered.

SQL> alter database open;
Database altered.
SQL>

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