不用控制文件怎么样? 在这之前还删除TABLESAPCE了吗? 如果没有,可以不用控制文件恢复。SVRMGR> recover database until time '2002-09-25:00:00:00'
老兄,我没有删除表空间,但也不行啊,这是我的执行结果:SVRMGR> recover database until time '2002-09-25:00:00:00'; ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
提示是必须用控制文件:(下面是多错误的英文解释) ORA-01610 recovery using the BACKUP CONTROLFILE option must be doneCause: Either an earlier database recovery session specified BACKUP CONTROLFILE, or the control file was re-created with the RESETLOGS option, or the control file being used is a backup control file. After that only BACKUP CONTROLFILE recovery is allowed and it must be followed by a log reset at the next database open.Action: Perform recovery using the BACKUP CONTROFILE option.
在这之前还删除TABLESAPCE了吗?
如果没有,可以不用控制文件恢复。SVRMGR> recover database until time '2002-09-25:00:00:00'
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
ORA-01610 recovery using the BACKUP CONTROLFILE option must be doneCause: Either an earlier database recovery session specified BACKUP CONTROLFILE, or the control file was re-created with the RESETLOGS option, or the control file being used is a backup control file. After that only BACKUP CONTROLFILE recovery is allowed and it must be followed by a log reset at the next database open.Action: Perform recovery using the BACKUP CONTROFILE option.
上次的resetlog后有没有作全备份?
如果有,那我告诉我怎么恢复如果没有,节哀
start nomount
create controlfile ......
幸好我把数据库完全export出来了,现在需要import就行,但是我不知道如何用sysdba身份去执行imp命令。因为我的数据库现在只能是在“mount”状态,而不能启动到“open”状态!
create controlfile ......