RECOVER DATABASE USING BACKUP CONTROLFILE; 这个命令会指导Oracle使用备份中的控制文件信息进行恢复。 完成日志文件的恢复: 在使用备份控制文件恢复后,需要继续恢复缺失的归档日志文件和在线重做日志文件,直到所有的数据都被恢复到一致的状态。 重置在线重做日志文件: 在数据库成功打开后,需要使用RESETLOGS选项打开数据库...
ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done Am trying to recover a database after a controlfile lost and restored from the backup. But How does Oracle knows that we are using ...
SQL> recover database using backup controlfile until cancel; ORA-00279: 更改 6432534 (在 06/22/2008 16:39:31 生成) 对于线程 1 是必需的 ORA-00289: 建议: E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_22\O1_MF_1_ 13_%U_.ARC ORA-00280: 更改 6432534 (用于线程 ...
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done.. Answer / guest Cause: Either an earlier database recovery session specified BACKUP CONTROLFILE, or the controlfile was recreated with the RESETLOGS option, or the controlfile being used is a backup controlfile...
SQL> recover database using backup controlfile until cancel; ORA-00279: 更改 6432534 (在 06/22/2008 16:39:31 生成) 对于线程 1 是必需的 ORA-00289: 建议: E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_22\O1_MF_1_ ...