ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF'
ORA-01251: Unknown File Header Version read for file number 1
Tue Oct 13 09:51:48 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_ckpt_2292.tr
c:
ORA-01243: system tablespace file suffered media failure
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF'
ORA-01251: Unknown File Header Version read for file number 1
SQL> shutdown immediate;
ORA-03113: end-of-file on communication channel
SQL> startup nomount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
C:\Documents and Settings\sphilip>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 13 10:19:41 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 1294680 bytes
Variable Size 444599976 bytes
Database Buffers 620756992 bytes
Redo Buffers 7090176 bytes
SQL> alter database mount;
Database altered.
SQL> select file_name from dba_data_files;
select file_name from dba_data_files
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> select * from v$datafiles
2 ;
select * from v$datafiles
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> alter database mount;
Database altered.
SQL> select file_name from dba_data_files;
select file_name from dba_data_files
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> select * from v$datafiles
2 ;
select * from v$datafiles
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF'
Completed: alter database mount
Tue Oct 13 10:21:05 2009
alter database open
Tue Oct 13 10:21:05 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_dbw0_4352.tr
c:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Tue Oct 13 10:21:08 2009
ORA-1157 signalled during: alter database open...
Restoring SYSTEM datafile from backup.
sphilip@seadba01 /cygdrive/c/oracle/product/10.2.0/oradata/orclnewbkp
$ cp SYSTEM01.DBF ../orclnew
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF'
SQL> recover datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF';
ORA-00279: change 13979986 generated at 10/12/2009 16:53:03 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00072_0684492530.001
ORA-00280: change 13979986 for thread 1 is in sequence #72
Specify log: {
AUTO
ORA-00279: change 13987064 generated at 10/13/2009 09:31:35 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00073_0684492530.001
ORA-00280: change 13987064 for thread 1 is in sequence #73
ORA-00278: log file
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00072_0684492530.001' no
longer needed for this recovery
ORA-00279: change 13987105 generated at 10/13/2009 09:32:20 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00074_0684492530.001
ORA-00280: change 13987105 for thread 1 is in sequence #74
ORA-00278: log file
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00073_0684492530.001' no
longer needed for this recovery
Log applied.
Media recovery complete.
ALTER DATABASE RECOVER datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF'
Tue Oct 13 10:27:15 2009
Media Recovery Start
parallel recovery started with 2 processes
ORA-279 signalled during: ALTER DATABASE RECOVER datafile 'C:\ORACLE\PRODUCT\1
.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF' ...
Tue Oct 13 10:27:26 2009
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Oct 13 10:27:26 2009
Media Recovery Log C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00072_06
4492530.001
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Oct 13 10:27:31 2009
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Oct 13 10:27:31 2009
Media Recovery Log C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00073_06
4492530.001
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Oct 13 10:27:31 2009
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Oct 13 10:27:31 2009
Media Recovery Log C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00074_06
4492530.001
Tue Oct 13 10:27:32 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\udump\orclnew_ora_2476.tr
:
ORA-00313: open failed for members of log group 3 of thread 1
Tue Oct 13 10:27:32 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 75 Reading mem 1
Mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A.LOG
Tue Oct 13 10:27:32 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 76 Reading mem 0
Mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2A.LOG
Mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2B.LOG
Tue Oct 13 10:27:33 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 77 Reading mem 0
Mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO1A.LOG
Mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO1B.LOG
Completed: ALTER DATABASE RECOVER CONTINUE DEFAULT
SQL> alter database open;
Database altered.
No comments:
Post a Comment