今天克隆数据库,重新启动时发现数据库无法打开,提示有如下的错误:
经检查,是因为在移动数据文件+DATA/orcl/datafile/example.265.877207037没有及时结束backup;
结束 backup后,数据库可正常打开,如下:
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> |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29367946/viewspace-1725798/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29367946/viewspace-1725798/