原库11.2.0.2.0,目标库11.2.0.4.0
出现问题
报错
恢复过程
restore database;
recover database;
archived log thread=1 sequence=98232
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/02/2017 11:16:14
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 98232 and starting SCN of 3499069209
recover database until scn 3499069209;
alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/02/2017 11:25:35
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 32317
Session ID: 232 Serial number: 67
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/02/2017 11:25:35
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 32317
Session ID: 232 Serial number: 67
尝试使用upgrade选项
alter database open upgrade;
通过跑升级脚本
执行升级脚本@?/rdbms/admin/catupgrd.sql
关闭数据库
shutdown immediate;
打开数据库
startup
出现问题
报错
恢复过程
restore database;
recover database;
archived log thread=1 sequence=98232
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/02/2017 11:16:14
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 98232 and starting SCN of 3499069209
recover database until scn 3499069209;
alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/02/2017 11:25:35
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 32317
Session ID: 232 Serial number: 67
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/02/2017 11:25:35
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 32317
Session ID: 232 Serial number: 67
尝试使用upgrade选项
alter database open upgrade;
通过跑升级脚本
执行升级脚本@?/rdbms/admin/catupgrd.sql
关闭数据库
shutdown immediate;
打开数据库
startup
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31324783/viewspace-2140219/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31324783/viewspace-2140219/