ORA-1113 signalled during: alter database open...
平臺:windows 2000 server
Oracle 9.2.0.4
使用了Windows的HA元件,在雙機手工切換後打不開資料庫,alert.log中出現
ORA-1113 signalled during: alter database open...錯誤.
alter database open
ORA-1113 signalled during: alter database open...
Fri Mar 24 16:07:21 2006
alter database open
ORA-1113 signalled during: alter database open...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
由於不在現場,原來是用Veritas的備份去恢復的,結果發現Veritas沒有備份Undo資料檔案,s活不行.
到了現場後,首先把當時現場的備份恢復,然後執行以下步驟:
SQL>startup mount
SQL>recover database;
SQL>alter database open;
It works!
記得以前有這樣的案例,結果一試即中,可憐我同事在現場呆了一整天:(
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/6906/viewspace-22010/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-279 signalled during: alter database recover logfileDatabase
- RAC 例項不能啟動 ORA-1589 signalled during ALTER DATABASE OPENDatabase
- [重慶思莊每日技術分享]-ORA-1142 signalled during: ALTER DATABASE END BACKUPDatabase
- alter database in OracleDatabaseOracle
- alter database datafile offline and alter database tablespace ...offlineDatabase
- alter database create datafileDatabase
- alter database create datafile '' as ''Database
- alter database和alter system和alter session的區別DatabaseSession
- alter database open resetlogs;Database
- alter database offline 與 alter database offline drop效果比對Database
- alter database disable thread 2Databasethread
- ALTER DATABASE RESETLOGS 的作用Database
- DATA GUARD 中alter database 命令Database
- ALTER DATABASE DATAFILE OFFLINEDatabase
- ALTER DATABASE 與 ALTER TABLESPACE OFFLINE的區別Database
- 忍不住問下alter system 和alter database的區別Database
- Oracle DBA命令參考——alter databaseOracleDatabase
- ALTER DATABASE CLEAR UNARCHIVED LOGFILE的使用DatabaseHive
- alter database ... create datafile的原理及用途Database
- alter database datafile 4 offline drop;Database
- 恢復一則 alter database create datafile '' as ''Database
- alter database datafile offline drop 與 alter tablespace drop datafile 區別Database
- Supporting Bigfile Tablespaces During Database Creation (77)Database
- Alter database datafile resize ORA-03297 原因解析Database
- UNRECOVERABLE DATAFILE clause in the ALTER DATABASE CLEAR LOGFILE statementDatabase
- VMS: ALTER TABLESPACE/DATABASE TO RENAME FILES on VMS [ID 9560.1]Database
- ORA-1113, ORA-1110 When recovering a copy of the database on a different serverDatabaseServer
- alter database datafile .... offline drop的問題Database
- alter database backup controlfile to trace的問題Database
- 在alter database mount時的一點收穫Database
- alter database backup controlfile to trace的含義Database
- 重建控制檔案--alter database backup controlfile to traceDatabase
- alter database drop datafile 與 drop tablespace file 的區別Database
- alter database datafile offline drop相關問題Database
- 425alter database force logging修改那裡Database
- 部署 11G 物理DataGuard時 ALTER DATABASE OPEN 報錯Database
- Oracle11gr2新增ALTER DATABASE LINK語法OracleDatabase
- 剛裝完的資料庫報錯 ORA-01102 ORA-1102 signalled during....資料庫