归档模式下。 1.先shutdown,然后把备份的数据文件拷回目录 2. startup mount 3. recover database until time to_date('','');--这个表大概删除的时间 4.alter database open resetlogs;
17:54:38 SQL> recover database until time '2012.1.10 17:49:00'; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/oracle/oradata/CDWS/system01.dbf'
请问有其他方法吗? 除了预先begin backup之外,
你是如何备份的啊?在3. recover database until time to_date('','');这一步骤之前 先执行以下 restore database ; 再试试。.
1.先shutdown,然后把备份的数据文件拷回目录
2. startup mount
3. recover database until time to_date('','');--这个表大概删除的时间
4.alter database open resetlogs;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oracle/oradata/CDWS/system01.dbf'
请问有其他方法吗?
除了预先begin backup之外,
restore database ; 再试试。.
就是切换成归档模式之后,把数据库做一个全备份。不是用begin backup那个。我先truncate table scott.emp
然后开始作恢复emp,把emp所在的users01.dbf覆盖过去阿,
Database mounted.
SQL> restore database
SP2-0734: unknown command beginning "restore da..." - rest of line ignored.
如果是你把所有拷贝的文件覆盖原来的文件, 然后
1.startup mount
2.recover database until time to_date();
3.alter database open resetlogs;
如果是用rman做的全备, 那么
rman > restore database;
> set until_time='';
>recover database;
sql 'alter database open';
嗯,shutdown情况下做的备份。完全恢复是可以。
但我想他能在联机状态的时候恢复,是不是不行呀,
alter database datafile xxx offline;
拷贝文件回去,
然后 recover datafile until time to_date()--这句我没试过,大概这样
alter database datafile xxx online;