searching for all files in the recovery area cataloging files... no files cataloged skipping datafile 2; already restored to file /oradata/tjtsyw/undotbs01.dbf skipping datafile 3; already restored to file /oradata/tjtsyw/sysaux01.dbf skipping datafile 1; already restored to file /oradata/tjtsyw/system01.dbf skipping datafile 4; already restored to file /oradata/tjtsyw/users01.dbf skipping datafile 5; already restored to file /oradata/tjtsyw/tbs_users.dbf 不只是那一个文件,在recovery区域没找到任何文件 后面全都跳过了
cataloging files...
no files cataloged
skipping datafile 2; already restored to file /oradata/tjtsyw/undotbs01.dbf
skipping datafile 3; already restored to file /oradata/tjtsyw/sysaux01.dbf
skipping datafile 1; already restored to file /oradata/tjtsyw/system01.dbf
skipping datafile 4; already restored to file /oradata/tjtsyw/users01.dbf
skipping datafile 5; already restored to file /oradata/tjtsyw/tbs_users.dbf
不只是那一个文件,在recovery区域没找到任何文件
后面全都跳过了
不是这样的,恢复的时候,会根据控制文件和数据文件的信息来比较备份集与当前数据文件的scn,确定是否需要restore
这里是正常的但是,进行不完全恢复,除了restore,还需要有个recover的过程,使得数据文件处于一直的状态,才能进行open
这里缺少了这一步,因此启动会出错restore其实并不成功,关注下这个错误
ORA-19870: error reading backup piece bk_5654_1_859672310
(blocksize=8192)error on file "/oradata/tjtsyw/tbs_users01.dbf", blockno 405425检查磁盘空间是否充足