如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com
适用于:
Oracle Server – Enterprise Edition – 版本 11.1.0.6 到11.2.0.2.0 [Release 11.1 to 11.2]
本文信息适用于任何平台。
症状
在备用数据库环境中,我们尝试启动或alter database open。这会返回错误ORA-1122 ORA-1110 和ORA-1200。
SQL> startup
ORACLE instance started.
Total System Global Area 1235959808 bytes
Fixed Size 2159232 bytes
Variable Size 1107299712 bytes
Database Buffers 117440512 bytes
Redo Buffers 9060352 bytes
Database mounted.
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: ‘/u01/home/oracle/oradata/chicago/sysaux01.dbf’
ORA-01200: actual file size of 106168 is smaller than correct size of 106296
blocks
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: ‘/u01/home/oracle/oradata/chicago/sysaux01.dbf’
ORA-01200: actual file size of 106168 is smaller than correct size of 106296
blocks
尝试备份相同文件可能在其中一个备用数据库中显示相同错误:
RMAN> backup datafile 2 format ‘/tmp/sysaux.bck’;
Starting backup at 01-JUN-12
Starting implicit crosscheck backup at 01-JUN-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=113 device type=DISK
Crosschecked 5 objects
Finished implicit crosscheck backup at 01-JUN-12
Starting implicit crosscheck copy at 01-JUN-12
using channel ORA_DISK_1
Finished implicit crosscheck copy at 01-JUN-12
searching for all files in the recovery area
cataloging files…
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/01/2012 10:12:27
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: ‘/u01/home/oracle/oradata/newyork/sysaux01.dbf’
ORA-01200: actual file size of 106168 is smaller than correct size of 106296 blocks
更改
包含主数据库的机器崩溃并被重启。
原因
问题是由于机器崩溃导致的损坏。
解决方案
查看在其他备用数据库中是否没有损坏。从“完好”备用数据库中备份文件并还原到主数据库。然后你可以打开主数据库,不生成错误。
[oracle@vboxstb ~]$ rman target /
Recovery Manager: Release 11.1.0.7.0 – Production on Fri Jun 1 10:13:34 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: CHICAGO (DBID=1391866143, not open)
RMAN> backup datafile 2 format ‘/tmp/sysaux.bck’;
Starting backup at 01-JUN-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=120 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/home/oracle/oradata/boston/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 01-JUN-12
channel ORA_DISK_1: finished piece 1 at 01-JUN-12
piece handle=/tmp/sysaux.bck tag=TAG20120601T101352 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 01-JUN-12
RMAN> exit
Recovery Manager complete.
将文件传输到有问题的数据库,例如使用ftp protocol。
连接到主数据库,还原并恢复那里的文件。
[oracle@vboxprm ~]$ rman target /
Recovery Manager: Release 11.1.0.7.0 – Production on Fri Jun 1 10:16:51 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: CHICAGO (DBID=1391866143, not open)
RMAN> catalog backuppiece ‘/tmp/sysaux.bck’;
using target database control file instead of recovery catalog
cataloged backup piece
backup piece handle=/tmp/sysaux.bck RECID=7 STAMP=784808257
RMAN> restore datafile 2;
Starting restore at 01-JUN-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=145 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /u01/home/oracle/oradata/chicago/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /tmp/sysaux.bck
channel ORA_DISK_1: piece handle=/tmp/sysaux.bck tag=TAG20120601T101352
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 01-JUN-12
RMAN> recover datafile 2;
Starting recover at 01-JUN-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=148 device type=DISK
starting media recovery
archived log for thread 1 with sequence 156 is already on disk as file /u01/home/oracle/flash_recovery_area/CHICAGO/archivelog/2012_05_24/o1_mf_1_156_7vv0lr01_.arc
…
archived log file name=/u01/home/oracle/flash_recovery_area/CHICAGO/archivelog/2012_05_30/o1_mf_1_197_7wd2z2w3_.arc thread=1 sequence=197
media recovery complete, elapsed time: 00:01:30
Finished recover at 01-JUN-12
RMAN> exit
Recovery Manager complete.
现在你可以打开主数据库了。
SQL> alter database open;
Database altered.
Comment