- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-12 23:16:27
|
查看: 1206 |
回复: 1
环境 VM LINUX ,DB 11G
是EBS的测试环境,异常关机后做了一个测试的动作(adcfgclone.pl dbTier xml)(真的中招了 dbid为重为0)
启动报
数据库报ORA-01221: data file 1 is not the same file to a background process
通过跟踪发现DB ID=0
Db ID=0=0x0, Db Name='TEST'
-----然后想重建CTROLFILE
再次exec dbms_backup_restore.zerodbid(0);
--nomount 下
CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 512
MAXINSTANCES 8
MAXLOGHISTORY 14607
LOGFILE
GROUP 3 (
'/opt/phdata/db/apps_st/data/log03.dbf',
'/opt/phdata/db/apps_st/data/log03a.dbf'
) SIZE 200M,
GROUP 4 (
'/opt/phdata/db/apps_st/data/log04a.dbf',
'/opt/phdata/db/apps_st/data/log04b.dbf'
) SIZE 200M
-- STANDBY LOGFILE
DATAFILE
'/opt/phdata/db/apps_st/data/system01.dbf',
'/opt/phdata/db/apps_st/data/system02.dbf',
'/opt/phdata/db/apps_st/data/system03.dbf',
'/opt/phdata/db/apps_st/data/system04.dbf',
'/opt/phdata/db/apps_st/data/system05.dbf',
'/opt/phdata/db/apps_st/data/ctxd01.dbf',
'/opt/phdata/db/apps_st/data/owad01.dbf',
'/opt/phdata/db/apps_st/data/a_queue02.dbf',
'/opt/phdata/db/apps_st/data/odm.dbf',
'/opt/phdata/db/apps_st/data/olap.dbf',
'/opt/phdata/db/apps_st/data/sysaux01.dbf',
'/opt/phdata/db/apps_st/data/apps_ts_tools01.dbf',
'/opt/phdata/db/apps_st/data/system12.dbf',
'/opt/phdata/db/apps_st/data/a_txn_data04.dbf',
'/opt/phdata/db/apps_st/data/a_txn_ind06.dbf',
'/opt/phdata/db/apps_st/data/a_ref03.dbf',
'/opt/phdata/db/apps_st/data/a_int02.dbf',
'/opt/phdata/db/apps_st/data/sysaux02.dbf',
'/opt/phdata/db/apps_st/data/olap01.dbf',
'/opt/phdata/db/apps_st/data/undo2.dbf',
'/opt/phdata/db/apps_st/data/sysaux03.dbf',
'/opt/phdata/db/apps_st/data/system10.dbf',
'/opt/phdata/db/apps_st/data/system06.dbf',
'/opt/phdata/db/apps_st/data/portal01.dbf',
'/opt/phdata/db/apps_st/data/system07.dbf',
'/opt/phdata/db/apps_st/data/system09.dbf',
'/opt/phdata/db/apps_st/data/system08.dbf',
'/opt/phdata/db/apps_st/data/system11.dbf',
'/opt/phdata/db/apps_st/data/undo01.dbf',
'/opt/phdata/db/apps_st/data/a_txn_data01.dbf',
'/opt/phdata/db/apps_st/data/a_txn_ind01.dbf',
'/opt/phdata/db/apps_st/data/a_ref01.dbf',
'/opt/phdata/db/apps_st/data/a_int01.dbf',
'/opt/phdata/db/apps_st/data/a_summ01.dbf',
'/opt/phdata/db/apps_st/data/a_nolog01.dbf',
'/opt/phdata/db/apps_st/data/a_archive01.dbf',
'/opt/phdata/db/apps_st/data/a_queue01.dbf',
'/opt/phdata/db/apps_st/data/a_media01.dbf',
'/opt/phdata/db/apps_st/data/a_txn_data02.dbf',
'/opt/phdata/db/apps_st/data/a_txn_data03.dbf',
'/opt/phdata/db/apps_st/data/a_txn_ind02.dbf',
'/opt/phdata/db/apps_st/data/a_txn_ind03.dbf',
'/opt/phdata/db/apps_st/data/a_txn_ind04.dbf',
'/opt/phdata/db/apps_st/data/a_txn_ind05.dbf',
'/opt/phdata/db/apps_st/data/a_ref02.dbf'
CHARACTER SET UTF8
CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/opt/phdata/db/apps_st/data/system10.dbf'
ORA-27048: skgfifi: file header information is invalid
------------------------
alert.log
Errors in file /opt/phdata/db/tech_st/11.1.0/admin/TEST_steve888/diag/rdbms/test/TEST/trace/TEST_dbw0_25648.trc:
ORA-01186: file 1 failed verification tests
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/opt/phdata/db/apps_st/data/system01.dbf'
ORA-01206: file is not part of this database - wrong database id
File 1 not verified due to error ORA-01122
Aborting crash recovery due to error 1221
Errors in file /opt/phdata/db/tech_st/11.1.0/admin/TEST_steve888/diag/rdbms/test/TEST/trace/TEST_ora_25666.trc:
ORA-01221: data file 1 is not the same file to a background process
ORA-1221 signalled during: ALTER DATABASE OPEN...
Wed Feb 17 05:51:48 2010
Errors in file /opt/phdata/db/tech_st/11.1.0/admin/TEST_steve888/diag/rdbms/test/TEST/trace/TEST_m000_25668.trc:
trace file
------------
DATA FILE #1:
(name #46) /opt/phdata/db/apps_st/data/system01.dbf
creation size=0 block size=8192 status=0xe head=46 tail=46 dup=1
tablespace 0, index=1 krfil=1 prev_file=2
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:23569 scn: 0x056c.ddc03342 02/13/2010 21:00:38
Stop scn: 0xffff.ffffffff 02/13/2010 13:56:54
Creation Checkpointed at scn: 0x0000.00000004 05/12/2000 14:27:59
thread:0 rba0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000
Offline scn: 0x056c.dda6cee6 prev_range: 0
Online Checkpointed at scn: 0x056c.dda6cee7 02/11/2010 17:27:55
thread:1 rba0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
Plugged readony: NO
Plugin scnscn: 0x0000.00000000
Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
DDE rules only execution for: ORA 1110
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
ORA-01186: file 1 failed verification tests
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/opt/phdata/db/apps_st/data/system01.dbf'
ORA-01206: file is not part of this database - wrong database id
---------- |
|