ORA-01122

最新推荐文章于 2024-05-06 22:24:37 发布
最新推荐文章于 2024-05-06 22:24:37 发布
阅读量1.2k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/gdolphinw/article/details/9331405
版权


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

Enter user-name: /as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup force
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2166256 bytes
Variable Size            1026392592 bytes
Database Buffers          570425344 bytes
Redo Buffers                4427776 bytes
Database mounted.
ORA-01122: database file 38 failed verification check
ORA-01110: data file 38: '/oracle/oraindex/tbs_index_01.dbf'
ORA-01207: file is more recent than control file - old control file


解决方法

第一步

SQL> alter database backup controlfile to trace;

Database altered.

SQL> exit    


第二步


SQL> select d.value||b.bias||lower(rtrim(i.instance, chr(0)))||'_ora_'||p.spid||'.trc' trace_file_name from ( select p.spid from sys.v$mystat m,sys.v$session s,sys.v$process p where m.statistic# = 1 and s.sid = m.sid and p.addr = s.paddr) p, ( select t.instance from sys.v$thread t,sys.v$parameter v where v.name = 'thread' and (v.value = 0 or t.thread# = to_number(v.value))) i, ( select value from sys.v$parameter where name = 'user_dump_dest') d,(select DECODE(count(BANNER),0,'/','\') bias from v$version where upper(banner) like '%WINDOWS%') b;

TRACE_FILE_NAME
--------------------------------------------------------------------------------
/app/oracle/product/diag/rdbms/p20/p20/trace/p20_ora_6912.trc

SQL>


第三步

oracle@linux-7e8h:~> more /app/oracle/product/diag/rdbms/p20/p20/trace/p20_ora_6912.trc
Trace file /app/oracle/product/diag/rdbms/p20/p20/trace/p20_ora_6912.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/product/11.1.0/db_1
System name:    Linux
Node name:      linux-7e8h
Release:        2.6.22.5-31-default
Version:        #1 SMP 2007/09/21 22:29:00 UTC
Machine:        x86_64
Instance name: p20
Redo thread mounted by this instance: 1
Oracle process number: 32
Unix process pid: 6912, image: oracle@linux-7e8h (TNS V1-V3)

*** 2013-07-15 09:36:44.567
*** SESSION ID:(539.7) 2013-07-15 09:36:44.567
*** CLIENT ID:() 2013-07-15 09:36:44.567
*** SERVICE NAME:() 2013-07-15 09:36:44.567
*** MODULE NAME:(sqlplus@linux-7e8h (TNS V1-V3)) 2013-07-15 09:36:44.567
*** ACTION NAME:() 2013-07-15 09:36:44.567
 
-- The following are current System-scope REDO Log Archival related
-- parameters and can be included in the database initialization file.
--
-- LOG_ARCHIVE_DEST=''
-- LOG_ARCHIVE_DUPLEX_DEST=''
--
-- LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf
--
-- DB_UNIQUE_NAME="p20"
--
-- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'
-- LOG_ARCHIVE_MAX_PROCESSES=4
-- STANDBY_FILE_MANAGEMENT=MANUAL
-- STANDBY_ARCHIVE_DEST=?/dbs/arch
-- FAL_CLIENT=''
-- FAL_SERVER=''
--
-- LOG_ARCHIVE_DEST_10='LOCATION=USE_DB_RECOVERY_FILE_DEST'
-- LOG_ARCHIVE_DEST_10='OPTIONAL REOPEN=300 NODELAY'
-- LOG_ARCHIVE_DEST_10='ARCH NOAFFIRM NOEXPEDITE NOVERIFY SYNC'
-- LOG_ARCHIVE_DEST_10='REGISTER NOALTERNATE NODEPENDENCY'
-- LOG_ARCHIVE_DEST_10='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME'
-- LOG_ARCHIVE_DEST_10='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'
-- LOG_ARCHIVE_DEST_STATE_10=ENABLE
--
-- Below are two sets of SQL statements, each of which creates a new
-- control file and uses it to open the database. The first set opens
-- the database with the NORESETLOGS option and should be used only if
-- the current versions of all online logs are available. The second
-- set opens the database with the RESETLOGS option and should be used
-- if online logs are unavailable.
-- The appropriate set of statements can be copied from the trace into
-- a script file, edited as necessary, and executed when there is a
-- need to re-create the control file.
--
--     Set #1. NORESETLOGS case
--
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- Additional logs may be required for media recovery of offline
-- Use this only if the current versions of all online logs are
-- available.
-- After mounting the created controlfile, the following SQL
-- statement will place the database in the appropriate
-- protection mode:
--  ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "P20" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 58400
LOGFILE
  GROUP 1 '/app/oracle/product/oradata/p20/redo01.log'  SIZE 50M,
  GROUP 2 '/app/oracle/product/oradata/p20/redo02.log'  SIZE 50M,
  GROUP 3 '/app/oracle/product/oradata/p20/redo03.log'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/app/oracle/product/oradata/p20/system01.dbf',
  '/app/oracle/product/oradata/p20/sysaux01.dbf',
  '/app/oracle/product/oradata/p20/undotbs01.dbf',
  '/app/oracle/product/oradata/p20/users01.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_01.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_02.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_03.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_04.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_05.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_06.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_07.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_08.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_09.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_10.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_11.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_12.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_13.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_14.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_15.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_16.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_17.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_18.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_19.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_20.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_21.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_22.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_23.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_24.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_25.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_26.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_27.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_28.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_29.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_30.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_01.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_02.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_03.dbf',
  '/oracle/oraindex/tbs_index_01.dbf',
  '/oracle/oraindex/tbs_index_02.dbf',
  '/oracle/oraindex/tbs_index_03.dbf',
  '/oracle/oraindex/tbs_index_04.dbf',
  '/oracle/oraindex/tbs_index_05.dbf',
  '/oracle/oraindex/tbs_index_06.dbf',
  '/app/oracle/product/oradata/p20/undotbs02.dbf'
CHARACTER SET AL32UTF8
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE '/app/oracle/product/flash_recovery_area/P20/archivelog/2013_07_15/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE '/app/oracle/product/flash_recovery_area/P20/archivelog/2013_07_15/o1_mf_1_1_%u_.arc';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- Database can now be opened normally.
ALTER DATABASE OPEN;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/app/oracle/product/oradata/p20/temp02.dbf' REUSE;
ALTER TABLESPACE TEMP ADD TEMPFILE '/app/oracle/product/oradata/p20/temp01.dbf' REUSE;
-- End of tempfile additions.
--
--     Set #2. RESETLOGS case
--
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- The contents of online logs will be lost and all backups will
-- be invalidated. Use this only if online logs are damaged.
-- After mounting the created controlfile, the following SQL
-- statement will place the database in the appropriate
-- protection mode:
--  ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "P20" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 58400
LOGFILE
  GROUP 1 '/app/oracle/product/oradata/p20/redo01.log'  SIZE 50M,
  GROUP 2 '/app/oracle/product/oradata/p20/redo02.log'  SIZE 50M,
  GROUP 3 '/app/oracle/product/oradata/p20/redo03.log'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/app/oracle/product/oradata/p20/system01.dbf',
  '/app/oracle/product/oradata/p20/sysaux01.dbf',
  '/app/oracle/product/oradata/p20/undotbs01.dbf',
  '/app/oracle/product/oradata/p20/users01.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_01.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_02.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_03.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_04.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_05.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_06.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_07.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_08.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_09.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_10.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_11.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_12.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_13.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_14.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_15.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_16.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_17.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_18.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_19.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_20.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_21.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_22.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_23.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_24.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_25.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_26.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_27.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_28.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_29.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_30.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_01.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_02.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_03.dbf',
  '/oracle/oraindex/tbs_index_01.dbf',
  '/oracle/oraindex/tbs_index_02.dbf',
  '/oracle/oraindex/tbs_index_03.dbf',
  '/oracle/oraindex/tbs_index_04.dbf',
  '/oracle/oraindex/tbs_index_05.dbf',
  '/oracle/oraindex/tbs_index_06.dbf',
  '/app/oracle/product/oradata/p20/undotbs02.dbf'
CHARACTER SET AL32UTF8
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE '/app/oracle/product/flash_recovery_area/P20/archivelog/2013_07_15/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE '/app/oracle/product/flash_recovery_area/P20/archivelog/2013_07_15/o1_mf_1_1_%u_.arc';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/app/oracle/product/oradata/p20/temp02.dbf' REUSE;
ALTER TABLESPACE TEMP ADD TEMPFILE '/app/oracle/product/oradata/p20/temp01.dbf' REUSE;
-- End of tempfile additions.
--


第四步


oracle@linux-7e8h:/app/oracle/product/oradata/p20> vi /home/oracle/createctl.sql


STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "P20" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 58400
LOGFILE
  GROUP 1 '/app/oracle/product/oradata/p20/redo01.log'  SIZE 50M,
  GROUP 2 '/app/oracle/product/oradata/p20/redo02.log'  SIZE 50M,
  GROUP 3 '/app/oracle/product/oradata/p20/redo03.log'  SIZE 50M
DATAFILE
  '/app/oracle/product/oradata/p20/system01.dbf',
  '/app/oracle/product/oradata/p20/sysaux01.dbf',
  '/app/oracle/product/oradata/p20/undotbs01.dbf',
  '/app/oracle/product/oradata/p20/users01.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_01.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_02.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_03.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_04.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_05.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_06.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_07.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_08.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_09.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_10.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_11.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_12.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_13.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_14.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_15.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_16.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_17.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_18.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_19.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_20.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_21.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_22.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_23.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_24.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_25.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_26.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_27.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_28.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_29.dbf',
  '/app/oracle/product/oradata/p20/tbs_p20_30.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_01.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_02.dbf',
  '/app/oracle/product/oradata/p20/tbs_finace_03.dbf',
  '/oracle/oraindex/tbs_index_01.dbf',
  '/oracle/oraindex/tbs_index_02.dbf',
  '/oracle/oraindex/tbs_index_03.dbf',
  '/oracle/oraindex/tbs_index_04.dbf',
  '/oracle/oraindex/tbs_index_05.dbf',
  '/oracle/oraindex/tbs_index_06.dbf',
  '/app/oracle/product/oradata/p20/undotbs02.dbf'
CHARACTER SET AL32UTF8;
~
~

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> @/home/oracle/createctl.sql;
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2166256 bytes
Variable Size            1026392592 bytes
Database Buffers          570425344 bytes
Redo Buffers                4427776 bytes

Control file created.

SQL> 



SQL> alter database open
  2  ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/app/oracle/product/oradata/p20/system01.dbf'


SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open




SQL> recover database  using backup controlfile;
ORA-00279: change 58953576915 generated at 07/05/2013 16:25:05 needed for
thread 1
ORA-00289: suggestion :
/app/oracle/product/flash_recovery_area/P20/archivelog/2013_07_15/o1_mf_1_415002
_%u_.arc
ORA-00280: change 58953576915 for thread 1 is in sequence #415002


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/app/oracle/product/oradata/p20/redo01.log
ORA-00310: archived log contains sequence 415000; sequence 415002 required
ORA-00334: archived log: '/app/oracle/product/oradata/p20/redo01.log'


SQL> recover database  using backup controlfile;
ORA-00279: change 58953576915 generated at 07/05/2013 16:25:05 needed for
thread 1
ORA-00289: suggestion :
/app/oracle/product/flash_recovery_area/P20/archivelog/2013_07_15/o1_mf_1_415002
_%u_.arc
ORA-00280: change 58953576915 for thread 1 is in sequence #415002


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/app/oracle/product/oradata/p20/redo02.log
ORA-00310: archived log contains sequence 415001; sequence 415002 required
ORA-00334: archived log: '/app/oracle/product/oradata/p20/redo02.log'


SQL> recover database  using backup controlfile;                      
ORA-00279: change 58953576915 generated at 07/05/2013 16:25:05 needed for
thread 1
ORA-00289: suggestion :
/app/oracle/product/flash_recovery_area/P20/archivelog/2013_07_15/o1_mf_1_415002
_%u_.arc
ORA-00280: change 58953576915 for thread 1 is in sequence #415002




SQL> recover database  using backup controlfile;
ORA-00279: change 58953576915 generated at 07/05/2013 16:25:05 needed for
thread 1
ORA-00289: suggestion :
/app/oracle/product/flash_recovery_area/P20/archivelog/2013_07_15/o1_mf_1_415002
_%u_.arc
ORA-00280: change 58953576915 for thread 1 is in sequence #415002


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/app/oracle/product/oradata/p20/redo03.log        
Log applied.
Media recovery complete.
SQL> alter database open resetlogs
  2  ;

Database altered.

SQL>



gdolphinw
关注
oeacle报错：ORA-01122、ORA-01110、ORA-01207
qq_43864807的博客
11-13 2280
1、启动数据库主要报错如下： ORA-01122: database file 2 failed verification check ORA-01110: data file 2: '/home/oracle/data/TRAFFIC_12C_3.DBF' ORA-01207: file is more recent than control file - old control file 主要三由于ORA-01207：文件比控制文件更新-旧的控制文件导致的。 同时查看数据库状态为：MOUNTED：
oracle实例无法关闭01122,ORA-01122 ORA-01110 ORA-01207问题总结
weixin_39603604的博客
04-04 357
1.SQL>shutdown abort 如果数据库是打开状态，强行关闭2.$ sqlplus /nologSQL> conn /as sysdba;3. SQL> startupORACLE instance started.Total System Global Area 3273641984 bytesFixed Size 2257680...
ORA-01122 ORA-01207问题
热门推荐
02-23 1万+
ORA-01122错误的解决方法(如果要重建控制文件，先看看数据文件是否一至,文件不一致，可以用强制同步的办法，但就怕数据表会有问题) 在重建控制文件前先试试面的方法recover database using backup controlfile;不行报ORA-01207: file is more recent than controlfile - old controlfile用alte
oracle-01122,Oracle数据库的ORA-01122 ORA-01110 ORA-01207错误
weixin_32124135的博客
04-03 1007
在Windows上保留原来数据库的数据文件、控制文件、重做日志文件重装Windows系统，重做数据库。1、安装Oracle数据库软件2、使用Oracle dbca创建一个与原来数据库名称一样的数据库3、先备份spfile文件(一般位于$ORACLE_HOME\dbs目录下)，生成一个pfile文件(一般位于$ORACLE_HOME\database目录下)：SQL>createpfilefr...
ORA-01122,ORA-01122,ORA-01122错误的解决方法！！
wolf
03-20 4273
ORA-01122,ORA-01122,ORA-01122错误的解决方法！！ 1  在数据库oracle10g中用冷 备份 备份了 数据库 中的所有的数据文件、控制文件、重做日志文件。 2  原来的数据库的数据文件、控制文件、重做日志文件丢失了 ，把冷备份中的数据文件、控制文件、重做日志文件拷贝了 过来。 3  重新启动数据库，出现以下错误： SQL> st
ORA-01122 ORA-01208 故障处理---惜分飞
07-15 964
确认数据库恢复需要sequence为254986的日志,但是数据库为非归档模式,redo已经被覆盖,因此常规方法无法正常open库,通过。数据库突然故障ORA-01122 ORA-01208,导致实例crash。工具快速修改文件头实现数据库文件头一致,open数据库成功。重启实例无法open。
oracle数据文件头损坏6,文件头损坏ORA-01122 ORA-01210恢复
weixin_42347778的博客
04-09 760
有朋友数据文件头出现错误ORA-01122和ORA-01210等错误，数据库无法正常open。因为平台是win，他们找我咨询win bbed,因为回老家电脑没有带,无法提供win的bbed.我通过dd部分文件头,然后在linux平台分析发现是该文件的文件头block大量坏块bbed分析坏块情况BBED> show allFILE# 0BLOCK# 1OF...
Oracle DataGuard 备库启动报ORA-01186 ORA-01122 ORA-01110 ORA-01210
weixin_41786256的博客
07-30 1052
如果使用LVM管理存储，当从生产端往容灾端做完基线后，启动容灾DB到read only状态时，告警日志中报如下错误： Reread of rdba: 0x00400001 (file 201,block 1) found same corrupted dataErrors in file /oracle/db/diag/rdbms/drora01/ drora01/trace/drora01 dbw0_ 12388.trc: ORA-01186: file 201 failed verification
关于oracle数据库启动报ORA-01122，ORA-01110，ORA-01203错误的解决方法
eastcool的专栏
11-20 5668
<br />ORACLE 数据库空间裸设备出问题了，启动oracle失败，解决方法<br />问题现象：<br />     启动ORACLE的时候报如下的错误：<br />        Database mounted.<br />      ORA-01122: database file 6 failed verification check<br />      ORA-01110: data file 6: '/dev/raw/rlv_cbs_user_dat'<br />      ORA-0
ORA-01122 ORA-01110 ORA-01207错误
css48419的博客
10-22 519
数据库做的冷备份，迁移到另一个数据库中，数据库的版本，路径都是一样的。也是最新的控制文件，但重启时却报控制文件过时。 如下： SQL> startup * 第 1 行出现错误: ORA-01122: ...
oracle-01122,ORA-01122,ORA-01122,ORA-01122错误的解决方法！！
weixin_29589063的博客
04-03 1170
1 在数据库oracle10g中用冷备份备份了数据库中的所有的数据文件、控制文件、重做日志文件。2 原来的数据库的数据文件、控制文件、重做日志文件丢失了 ，把冷备份中的数据文件、控制文件、重做日志文件拷贝了 过来。3 重新启动数据库，出现以下错误：SQL> startupORACLE instance started.Total System Global Area 26843545...
存储故障后oracle报—ORA-01122/ORA-01207故障处理---惜分飞
最新发布
05-06 689
客户存储异常,通过硬件恢复解决存储故障之后,oracle数据库无法正常启动(存储cache丢失),尝试recover数据库报ORA-00283 ORA-01122 ORA-01110 ORA-01207错误。数据库无法通过正常recover的思路解决.通过屏蔽一致性,强制打开数据库,alert日志报ORA-600 2662错误。这个错误比较明显,由于28号回滚段异常导致,对异常回滚段进行处理,重建undo,数据库恢复主要工作完成。通过修改数据库scn,open数据库报ORA-600 4137。
ORA-01122 AND ORA-01210
cuiwu7783的博客
11-10 575
学习BBED的过程中，突然出现了ora-01122及ora-01210错误，根据此文http://www.itpub.net/thread-1754481-1-1.html无法修复。 SQL> alte...
ORA-01122;ORA-01110;ORA-01207问题解决经验总结
wangl2014的专栏
04-20 7239
1.SQL>shutdown abort 如果数据库是打开状态，强行关闭 2.SQL>sqlplus / as sysdba 3.SQL>startupORACLE 例程已经启动。 Total System Global Area 293601280 bytes Fixed Size 1248624 bytes Variable Size 121635472...
ORA-01122: 数据库文件 1 验证失败
aini4611的博客
11-26 1060
1.SQL>shutdown abort 如果数据库是打开状态，强行关闭2.SQL>sqlplus / as sysdba3.SQL>startupORACLE 例程已经启动。Total System Global Area 293601280 bytesFixed Size 1248624 bytesVariable Size 121635472 bytesDatab...
ORA-01122: database file 13 failed verification check
qq_34749666的博客
04-01 689
ORA-01122: database file 13 failed verification check ORA-01110: data file 13: ‘/home/oracle/oradata/test1.DBF’ ORA-01210: data file header is media corrupt 问题可能是：数据库文件文件头损坏，然后损坏是因为数据文件被删除过或者是应为放在了hom...
ORA-01122: database file 3 failed verification check
sqlora的专栏
03-04 803
space available in the underlying filesystem or ASM diskgroup. Thu Mar 03 16:45:47 2022 alter database open Errors in file /home/oracle/app/diag/rdbms/ora9/ora9/trace/ora9_ora_158202.trc: ORA-01122: database file 3 failed verification check ORA-01110: dat.
解决ORCLE-ORA-01122 01110 01210
低音钢琴的专栏
05-29 5073
中午搬迁了数据库服务器，点亮后启动数据库。 lsnrctl start The listener supports no services The command completed successfully 没问题。 然后启动数据库，报错： SQL> startup ORACLE instance started. Total System Global Area 2137886720...
oracle-01122,ORA-01122 ORA-01110 ORA-01207错误
weixin_33221829的博客
04-03 628
数据库做的冷备份，迁移到另一个数据库中，数据库的版本，路径都是一样的。也是最新的控制文件，但重启时却报控制文件过时。如下：SQL> startup*第1行出现错误:ORA-01122:数据库文件1验证失败ORA-01110:数据文件1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\XBOMS\SYSTEM01.DBF'ORA-01207:文件比控制文件更新-旧的控制文...
ORA-31693 ORA-00001
04-11
ORA-31693是Oracle数据库中的一个错误代码，表示在执行数据泵作业时发生了错误。具体来说，ORA-31693错误通常与以下情况相关： 1. 数据泵作业参数错误：可能是由于指定的数据泵作业参数不正确导致的。例如，指定了无效的对象名称或目标表空间。 2. 对象不存在：如果在数据泵作业中指定了一个不存在的对象，就会触发ORA-31693错误。这可能是由于对象被删除或重命名导致的。 3. 权限问题：如果当前用户没有足够的权限执行数据泵作业，也会导致ORA-31693错误。 而ORA-00001是Oracle数据库中的另一个错误代码，表示违反了唯一约束条件。具体来说，ORA-00001错误通常与以下情况相关： 1. 插入重复值：当尝试向一个已经存在唯一约束的列插入重复值时，就会触发ORA-00001错误。 2. 更新导致冲突：如果更新操作导致了唯一约束条件的冲突，也会触发ORA-00001错误。 解决ORA-31693和ORA-00001错误的方法取决于具体的情况。对于ORA-31693错误，您可以检查数据泵作业的参数是否正确，并确保当前用户具有执行该作业所需的权限。对于ORA-00001错误，您可以检查插入或更新的数据是否违反了唯一约束条件，并相应地修改数据或调整约束。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值