当进行恢复数据库执行recover database的时候报 SQL> recover database ORA-00279: change 981220327 generated at 11/09/2018 19:04:07 needed for thread 1 ORA-00289: suggestion : /u01/apps/oracle/flash_recovery_area/ORCL/archivelog/2018_11_12/o1_mf_1_23242_fy lp52rf_.arc ORA-00280: change 9...
分配的通道: ORA_DISK_1 通道ORA_DISK_1: SID=148 设备类型=DISK 通道ORA_DISK_1: 正在开始还原数据文件备份集 通道ORA_DISK_1: 正在指定从备份集还原的数据文件 通道ORA_DISK_1: 将数据文件 00001 还原到 D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTE M01.DBF 通道ORA_DISK_1: 将数据文件 00002 还原到 D...
ORA-00279: change 17000140 generated at 11/08/2007 14:52:17 needed for thread 1 ORA-00289: suggestion : /opt/oracle/flash_recovery_area/DZJ01/archivelog/2008_02_29/o1_mf_1_1174_%u_.arc ORA-00280: change 17000140 for thread 1 is in sequence #1174 ...
其实这个场景下,告警日志中ORA-279更像是“输出消息”, 而不是“错误信息”,它是在提示需要请求的归档日志才能继续恢复。以前在使用RMAN进行RECOVER时没有留意过这个细节信息。顺便记录一下。以免初次遇到这个提示信息的时候,还以为出现了什么异常或错误。 [root@DB-Server2019_02_16]$ oerr ora 279 00279, 00000...
[root@DB-Server 2019_02_16]$ oerr ora 279 00279, 00000, "change %s generated at %s needed for thread %s" // *Cause: The requested log is required to proceed with recovery. // *Action: Please supply the requested log with "ALTER DATABASE RECOVER ...
ORA-01113: file 4 needs media recovery ORA-01110: data file 4: '/home/oracle/oracle/product/10.2.0/db_1/oradata/petervm/users01.dbf' SQL> recover datafile 4; ORA-00279: change 2340665 generated at 05/24/2013 23:34:39 needed for thread 1 ...
ORA-00279: change 1717921 generated at 11/12/2021 01:07:36 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_12/o1_mf_1_5_%u_.ar c ORA-00280: change 1717921 for thread 1 is in sequence #5 ...
ORA-00278: log file '/oracle/YYDNEW/oraarch/YYDarch1_993851_614464364.dbf' no longer needed for this recovery Specify log: {<RET>=suggested | filename | AUTO | CANCEL} ORA-00279: change 66539631772 generated at 04/15/2013 19:15:28 needed for ...
SQL> recover automatic database until cancel using backup controlfile; ORA-00279: change 2172930 generated at 04/08/2021 12:27:06 needed for thread 1 ORA-00289: suggestion : /u02/fast_recovery_area/ORATEST1/archivelog/2021_04_08/o1_mf_1_13_%u_.arc ORA-00280: chan...
ORA-00278: log file '/home/oracle/archivelog/DG/1_9_921163363.dbf' no longer needed for this recovery Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00279: change 1253084 generated at 08/29/2016 14:52:58 needed for thread 1 ...