ITPub博客

首页 > 数据库 > Oracle > Oracle异机恢复执行startup nomount时报错ORA-1565、ORA-27037、RMAN-4014

Oracle异机恢复执行startup nomount时报错ORA-1565、ORA-27037、RMAN-4014

原创 Oracle 作者:feelpurple 时间:2016-03-22 16:27:13 0 删除 编辑
使用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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-08-01

  • 博文量
    404
  • 访问量
    1181046