关于不完全恢复的两个问题

问题一：

SQL> recover database until time '2012-02-18 20:00:00';

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01245: offline file 4 will be lost if RESETLOGS is done

ORA-01110: data file 4: '/u01/app/oracle/oradata/exOa/exOa/users01.dbf'

解决办法：

alter database datafile 4 online;

问题二：

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '/u01/app/oracle/oradata/exOa/exOa/system01.dbf'

解决办法：

RMAN> recover datafile 1;

Starting recover at 18-FEB-12

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=374 devtype=DISK

starting media recovery

media recovery complete, elapsed time: 00:00:00

Finished recover at 18-FEB-12

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21584437/viewspace-716824/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21584437/viewspace-716824/