ry requestingunknown archived log for thread 1 with sequence 36278 and starting SCN of11412370952
?
RMAN>
?
后台alet日志报错信息为：
Fri Aug 21 11:47:07 2015
alter database recover datafile list clear
Completed: alter database recover datafilelist clear
alter database recover datafile list
1 ,2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12
Completed: alter database recover datafilelist
1 ,2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 4slaves
ORA-279 signalled during: alter databaserecover if needed
start until cancel using backup controlfile
...
alter database recover logfile'/oracle/app/oracle/flash_recovery_area/archivelog1_36277_821708334.dbf'
Media Recovery Log/oracle/app/oracle/flash_recovery_area/archivelog1_36277_821708334.dbf
ORA-279 signalled during: alter databaserecover logfile'/oracle/app/oracle/flash_recovery_area/archivelog1_36277_821708334.dbf'...
alter database recover cancel
Media Recovery Canceled
Completed: alter database recover cancel
Fri Aug 21 11:47:09 2015
Checker run found 1 new persistent datafailures
?
可见，出先此错误的原因是恢复需要的归档日志记录在控制文件或恢复目录中找不到。解决方法分两种情况：
1.如果相关的日志存在且可用的话，就将此日志记录添加到控制文件或恢复目录中。
2.如果相关的日志已经被删除了或不可用了，那么就按照错误的提示scn将数据库恢复到此scn，这里是11412370952。也就是说此时数据库只能进行不完全恢复了，在打开数据库时得使用resetlogs打开。
?
recover database until scn 11412370952;
?
?
RMAN> recover database until scn11412370952;
?
Starting recover at 20-AUG-15
using channel ORA_DISK_1
?
starting media recovery
media recovery complete, elapsed time:00:00:00
?
Finished recover at 20-AUG-15
?
RMAN>
?
然后打开数据库
RMAN> alter database openresetlogs;
?
database opened
?
RMAN>
?
?
3，一些调试过程中的意外报错
然后打开报错
RMAN> alter database open resetlogs;
?
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002: failure of alter db command at08/20/2015 20:31:07；
ORA-03113: end-of-file on communicationchannel
Process ID: 30584
Session ID: 192 Serial number: 19
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002: failure of alter db command at08/20/2015 20:31:07
ORA-03113: end-of-file on communicationchannel
Process ID: 30584
Session ID: 192 Serial number: 19
[oracle@testoracle1 dbs]$
?
重新进去打开
RMAN> alter database open resetlogs;
?
using target database control file insteadof recovery catalog
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002: failure of alter db command at08/20/2015 20:35:44
RMAN-06403: could not obtain a fullyauthorized session
ORA