Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-12 23:16:27 | 查看: 1207| 回复: 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
----------
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
2#
发表于 2017-4-12 23:17:52
没有备份,非归档模式,是我自己的测试环境

有备份,但一部分数据肯定是没了
其有其它办法解决吗
关键是现在建不了控制文件

大师,能不能给的详细点?
改DBID现在好像也不行吧,用那个工具?
用这个不行哦
DBNEWID: Release 11.1.0.7.0 - Production on Wed Feb 17 08:53:14 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to database TEST (DBID=2008849300)

NID-00131: Control file is not current


Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 16:53 , Processed in 0.054865 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569