请教RMAN恢复不成功
1、环境：单机ORACLE9i+WINDOWS 2003
2、RMAN 脚本：
run{
configure controlfile autobackup off;
backup database format 'E:ackup\%d_%T_%s';
backup format 'E:ackupcontrol_%T_%s' current controlfile;
backup format 'E:ackuparchive_%T_%s' archivelog all;
}
3、删除表
SQL>DROP HR.JOB_HISTORY;
SQL>COMMIT;
SQL>ALTER SYSTEM SWITCH LOGFILES;
4、恢复数据：
RMAN>SHUTDOWN IMMEDIATE
RMAN>STARTUP NOMOUNT;
RMAN>RESTORE CONTROLFILE FROM 'E:BACKUPCONTROL_20080723_3';
RMAN>ALTER DATBASE MOUNT;
RMAN>RESTORE DATABASE;
RMAN>RECOVER DATABSE;
RMAN>ALTER DATABSE OPEN;
完成后再查询HR.JOB_HISTORY，还是没有，说明恢复没有成功，这跟REDO.LOG有关系吗？应该这么操作？请高手指教？
个人理解:RESTORE DATABASE 这样子恢复把数据恢复到最近,DROP掉的HR.JOB_HISTORY在最近之内当然还是被DROP的.使用不完全恢复 until cancel,untile time 或者until scn. drop table不会导致controlfile变化.
2、RMAN 脚本：
run{
configure controlfile autobackup off;
backup database format 'E:ackup\%d_%T_%s';
backup format 'E:ackupcontrol_%T_%s' current controlfile;
backup format 'E:ackuparchive_%T_%s' archivelog all;
}
3、删除表
SQL>DROP HR.JOB_HISTORY;
SQL>COMMIT;
SQL>ALTER SYSTEM SWITCH LOGFILES;
4、恢复数据：
RMAN>SHUTDOWN IMMEDIATE
RMAN>STARTUP NOMOUNT;
RMAN>RESTORE CONTROLFILE FROM 'E:BACKUPCONTROL_20080723_3';
RMAN>ALTER DATBASE MOUNT;
RMAN>RESTORE DATABASE;
RMAN>RECOVER DATABSE;
RMAN>ALTER DATABSE OPEN;
完成后再查询HR.JOB_HISTORY，还是没有，说明恢复没有成功，这跟REDO.LOG有关系吗？应该这么操作？请高手指教？
个人理解:RESTORE DATABASE 这样子恢复把数据恢复到最近,DROP掉的HR.JOB_HISTORY在最近之内当然还是被DROP的.使用不完全恢复 until cancel,untile time 或者until scn. drop table不会导致controlfile变化.
"recover database until cancel"
will allow you to choose when the recovery should stop. you can stop it at any sequence number, or until all the redo are applied, depending on your requirement.
will allow you to choose when the recovery should stop. you can stop it at any sequence number, or until all the redo are applied, depending on your requirement.
alter database open resetlogs;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7301064/viewspace-412015/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
