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

系统管理员 2024-04-17 23:57 47阅读 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/，如需转载，请注明出处，否则将追究法律责任。

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