RUN {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:/backup/%F';
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT 'd:/backup/%U';
BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL CH1;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;
---
这个是备份的语句。
shutdown immediate
startup mount
recover database until time '2010-10-28 17:31';
alter database open resetlogs;
---
这个是恢复到某个时间点的语句。
数据库为存档模式为什么我恢复的数据总是不对呢 比如要恢复17:31的数据,但是17:31后增加的数据都还在。在恢复得时候,是不是要把备份的文件放到某个位置哦? 谢谢解答
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:/backup/%F';
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT 'd:/backup/%U';
BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL CH1;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;
---
这个是备份的语句。
shutdown immediate
startup mount
recover database until time '2010-10-28 17:31';
alter database open resetlogs;
---
这个是恢复到某个时间点的语句。
数据库为存档模式为什么我恢复的数据总是不对呢 比如要恢复17:31的数据,但是17:31后增加的数据都还在。在恢复得时候,是不是要把备份的文件放到某个位置哦? 谢谢解答
Flashback database to timestamp to_timestamp('2010-10-28 17:31','yyyy-mm-ddhh24:mi');参考下flashback database吧:http://ssuhvs.javaeye.com/blog/642452
那么我前面的方法是错在哪里呢