Oracle異機恢復執行startup nomount時報錯ORA-1565、ORA-27037、RMAN-4014
使用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
[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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle startup(nomount mount open restrict)OracleREST
- oracle 異機恢復Oracle
- Oracle RMAN異機恢復Oracle
- rman恢復方案和oracle異機恢復Oracle
- oracle冷備份、恢復和異機恢復Oracle
- ORACLE RMAN異機異目錄恢復Oracle
- oracle的RMAN異機恢復Oracle
- startup,startup mount,startup nomount之間的區別
- 兩篇oracle異機恢復文章Oracle
- Oracle備份恢復之熱備份恢復及異機恢復Oracle
- oracle10201 startup nomount報ora-00600錯Oracle
- Oracle 12c RMAN 異機恢復Oracle
- Oracle 11g RMAN 異機恢復Oracle
- yii執行phpunit時報錯PHP
- Netbackup+oracle db 異機恢復案例Oracle
- Xtrabackup恢復時報錯'Error: datadir must be specified'Error
- oracle 11G r2 異機恢復Oracle
- RMAN異機恢復總結
- oracle10gR2之RMAN異機恢復案例Oracle
- oracle 10.2.0.1 win 32 rman 備份異機恢復Oracle
- Oracle異地資料庫恢復Oracle資料庫
- [Oracle]startup mount時報ORA-12514錯誤的解決方法Oracle
- 資料庫異機恢復開啟報錯ORA-36961資料庫
- 【北亞資料恢復】異常斷電導致Oracle資料庫報錯的oracle資料恢復資料恢復Oracle資料庫
- RMAN恢復 執行重要檔案RMAN恢復
- 執行dbca時報錯:Xlib:No protocol specifiedProtocol
- 資料庫不能startup nomount ora-00600資料庫
- 異機恢復後ORA-01152錯誤解決
- oracle 9I 資料庫異機恢復( Catalog 庫 )Oracle資料庫
- Oracle asm磁碟損壞異常恢復OracleASM
- rman之同平臺異機恢復
- 同平臺異機備份恢復
- 使用DP實現RAC異機恢復
- 資料庫異機冷備恢復資料庫
- 用rman執行塊恢復
- 6_Oracle truncate異常恢復之bbed修復Oracle
- 7_Oracle truncate異常恢復之plsql修復OracleSQL
- Oracle 11g RMAN 異機恢復報錯 RMAN-06172、ORA-07202Oracle