。
也就是说此时数据库仅仅能进行不全然恢复了,在打开数据库时得使用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>
,一些调试过程中的意外报错
然后打开报错
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-01034: ORACLE not available
ORA-27101: shared memory realm does notexist
Linux-x86_64 Error: 2: No such file ordirectory
RMAN>
尝试去sqlplus模式下启动
SQL> startup
ORACLE instance started.
Total System Global Area 5010685952 bytes
Fixed Size 2212936 bytes
Variable Size 2751466424 bytes
Database Buffers 2214592512 bytes
Redo Buffers 42414080 bytes
Database mounted.
ORA-03113: end-of-file on communicationchannel
Process ID: 10504
Session ID: 191 Serial number: 3
SQL>
这里打不开的原因是,參数文件恢复失效后,跳过參数文件恢复这一步骤。然后进行控制文件恢复后restore库recover库引发的问题。
解决方式:就是又一次恢复參数文件后再进行下述步骤就全然OK。