博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
Oracle异机恢复执行startup nomount时报错ORA-1565、ORA-27037、RMAN-4014
阅读量:2497 次
发布时间:2019-05-11

本文共 1976 字,大约阅读时间需要 6 分钟。

使用RMAN进行异机恢复的时候,执行STARTUP NOMOUNT报错:
[oracle@backup-recovery ~]$ export ORACLE_SID=gtfdb;
[oracle@backup-recovery ~]$ rman nocatalog
Recovery Manager:
Release 11.2.0.3.0 - Production on Tue Mar 22 16:16:04 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
RMAN> connect target /
connected to target database (not started)
RMAN> set dbid 4241661131;
executing command: SET DBID
RMAN> startup nomount
startup failed: ORA-1078: failure in processing system parameters
ORA-1565: error in identifying file 
'/u01/app/oracle/product/11.2.0/db_1/dbs/initgtfdb.ora'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
starting Oracle instance without parameter file for retrieval of spfile
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3002: failure of startup command at 02/05/2010 10:06:16
RMAN-4014: startup failed: ORA-4031: unable to allocate 84672 bytes of 
shared memory ("shared pool","unknown object","sga heap(1,0)","ksuloi: long op statistics array")
解决方法:
[oracle@backup-recovery ~]$ export ORA_RMAN_SGA_TARGET=350
之后数据库恢复正常,可以正常执行startup nomount
[oracle@backup-recovery ~]$ rman nocatalog
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Mar 22 16:16:04 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
RMAN> connect target /
connected to target database (not started)
RMAN> set dbid 4241661131;
executing command: SET DBID
RMAN> startup nomount
Oracle instance started
Total System Global Area   18907013120 bytes
Fixed Size                     2236288 bytes
Variable Size               7650410624 bytes
Database Buffers           11207180288 bytes
Redo Buffers                  47185920 bytes

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26506993/viewspace-2061866/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2061866/

你可能感兴趣的文章
学习笔记_vnpy实战培训day04_作业
查看>>
OCO订单(委托)
查看>>
学习笔记_vnpy实战培训day06
查看>>
回测引擎代码分析流程图
查看>>
Excel 如何制作时间轴
查看>>
股票网格交易策略
查看>>
matplotlib绘图跳过时间段的处理方案
查看>>
vnpy学习_04回测评价指标的缺陷
查看>>
ubuntu终端一次多条命令方法和区别
查看>>
python之偏函数
查看>>
vnpy学习_06回测结果可视化改进
查看>>
读书笔记_量化交易如何建立自己的算法交易01
查看>>
设计模式03_工厂
查看>>
设计模式04_抽象工厂
查看>>
设计模式05_单例
查看>>
设计模式06_原型
查看>>
设计模式07_建造者
查看>>
设计模式08_适配器
查看>>
设计模式09_代理模式
查看>>
设计模式10_桥接
查看>>