本文详细介绍了如何进行Oracle数据库从10G到11G的异库恢复，包括设置DBID、处理参数文件错误、恢复控制文件、挂载数据库、恢复数据直到特定SCN并打开数据库的过程，以及解决遇到的错误和注意事项。
原服务器数据库版本10G，新服务器版本11G
实例名必须相同。
目录最好相同，按原pfile里的有的目录创建
查询原数据库dbid
select dbid from v$database;
RMAN> set dbid=844174343
executing command: SET DBID
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/oracle/db/dbs/initxezf.ora'
starting Oracle instance without parameter file for retrieval of spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 05/12/2017 11:38:58
RMAN-04014: startup failed: ORA-04031: unable to allocate 3978656 bytes of shared memor
实例名必须相同。
目录最好相同，按原pfile里的有的目录创建
查询原数据库dbid
select dbid from v$database;
RMAN> set dbid=844174343
executing command: SET DBID
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/oracle/db/dbs/initxezf.ora'
starting Oracle instance without parameter file for retrieval of spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 05/12/2017 11:38:58
RMAN-04014: startup failed: ORA-04031: unable to allocate 3978656 bytes of shared memor
最低0.47元/天 解锁文章
扫一扫
518
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
