尝试用: recover database until time '2001-03-14:09:00:00'; alter database open resetlogs; exp system/manager file=saved.dmp full=Y; shutdown immediate; startup imp system/manager file=saved.dmp full=Y commit=Y buffer=64000祝好运!
SVRMGR> recover database until time '2001-03-14 09:00:00'; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01245: offline file 1 will be lost if RESETLOGS is done ORA-01110: data file 1: 'E:\ORANT\DATABASE\SYS1ORCL.ORA' SVRMGR> alter database datafile 1 online; Statement processed. SVRMGR> alter database datafile 6 online; Statement processed. SVRMGR> alter database open resetlogs; alter database open resetlogs * ORA-01190: controlfile or data file 1 is from before the last RESETLOGS ORA-01110: data file 1: 'E:\ORANT\DATABASE\SYS1ORCL.ORA' SVRMGR>
如果有数据文件的备份,可以: startup mount; recover database until time '2001-03-14 09:00:00'; alter database rename file 'e:\orant\database\sys10rcl.ora' to 'd:\orant\database\sys10rcl.ora'; alter database open resetlogs;
只有一个很早的,而且log archived被删除。
先用ALTER DATABASE DATAFILE '' OFFLINE; 把数据文件脱机,然后shutdown再用下述步骤: startup mount; alter database rename file 'e:\orant\database\sys10rcl.ora' to 'd:\orant\database\sys10rcl.ora'; alter database open; recover datafile ''; alter database datafile '' online;
recover database until time '2001-03-14:09:00:00';
alter database open resetlogs;
exp system/manager file=saved.dmp full=Y;
shutdown immediate;
startup
imp system/manager file=saved.dmp full=Y commit=Y buffer=64000祝好运!
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01245: offline file 1 will be lost if RESETLOGS is done
ORA-01110: data file 1: 'E:\ORANT\DATABASE\SYS1ORCL.ORA'
SVRMGR> alter database datafile 1 online;
Statement processed.
SVRMGR> alter database datafile 6 online;
Statement processed.
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: 'E:\ORANT\DATABASE\SYS1ORCL.ORA'
SVRMGR>
startup mount;
recover database until time '2001-03-14 09:00:00';
alter database rename file
'e:\orant\database\sys10rcl.ora' to
'd:\orant\database\sys10rcl.ora';
alter database open resetlogs;
把数据文件脱机,然后shutdown再用下述步骤:
startup mount;
alter database rename file
'e:\orant\database\sys10rcl.ora' to
'd:\orant\database\sys10rcl.ora';
alter database open;
recover datafile '';
alter database datafile '' online;
因为当中的log archive被删除,所以用以前的数据文件我认为是
不能recover的。
为什么会出这样的错呢?
我觉得应该可以恢复的呀?