Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01171: datafile 6 going offline due to error advancing checkpoint

545041Feb 27 2007 — edited Mar 1 2007

Hi

Anyone here know what cause this error? This error happened after backup at night.The data file then went offline. Anyone know the reason?

Thanks

Excerpt from alert.log:
Mon Feb 26 20:34:45 2007
Errors in file d:\oracle\admin\live\bdump\live_ckpt_1064.trc:
ORA-01171: datafile 6 going offline due to error advancing checkpoint
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: 'D:\ORACLE\ORADATA\LIVE\VGSM_DB01.DBF'
ORA-01208: data file is an old version - not accessing current version
Contents of d:\oracle\admin\live\bdump\live_ckpt_1064.trc
Dump file d:\oracle\admin\live\bdump\live_ckpt_1064.trc
Mon Feb 26 20:34:45 2007
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: live

Redo thread mounted by this instance: 1

Oracle process number: 5

Windows thread id: 1064, image: ORACLE.EXE

*** 2007-02-26 20:34:45.000
*** SESSION ID:(4.1) 2007-02-26 20:34:45.000
ORA-01171: datafile 6 going offline due to error advancing checkpoint
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: 'D:\ORACLE\ORADATA\LIVE\VGSM_DB01.DBF'
ORA-01208: data file is an old version - not accessing current version

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2007

Added on Feb 27 2007

#general-database-discussions

4 comments

1,777 views