ORA-01003 & ORA-01110

When Oracle 9i Database is logged on, A ORA-01003 & ORA-01110 message is prompted, which probably means that the data file storage media is corrupt.

Startup nomount, normal;

Alter database mount, also normal;

Alter database open:

 Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 1 ??????
ORA-01110 :???? 1: 'e: \ ORACLE \ ORADATA \ JSDSB \ system01.dbf'

 

The following are the logs of the recovery process, which are marked in red:

 

 

Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C: \ Documents ents and Settings \ Administrator> sqlplus/nolog

SQL * Plus: Release 9.2.0.1.0-Production on Saturday January 7 09:41:58 2012

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL> conn/as sysdba
Connected.
SQL> conn system/manager
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

Warning: you are no longer connected to ORACLE.
SQL> exit

C: \ Documents ents and Settings \ Administrator> sqlplus/nolog

SQL * Plus: Release 9.2.0.1.0-Production on Saturday January 7 09:43:30 2012

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL> conn/as sysdba
Connected.
SQL> shutdown abort
The ORACLE routine has been disabled.
SQL> startup noount
SP2-0714: Invalid STARTUP Option combination
SQL>Startup nomount
The ORACLE routine has been started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL>Alter database mount
2;

The database has been changed.

SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 1 ??????
ORA-01110 :???? 1: 'e: \ ORACLE \ ORADATA \ JSDSB \ system01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ system01.dbf ';
Media recovery is completed.
SQL> recover tablespace system;

// Index data file storage medium Error
ORA-00283 :??????????
ORA-00264 :?????

SQL> recover tablespace system;
ORA-00283 :??????????
ORA-00264 :?????

SQL> exit
From Oracle9i Enterprise Edition Release 9.2.0.1.0-Production
With the Partitioning, OLAP and Oracle Data Mining options
Disconnects from JServer Release 9.2.0.1.0-Production

C: \ Documents ents and Settings \ Administrator> sqlplus/nolog

SQL * Plus: Release 9.2.0.1.0-Production on Saturday January 7 09:45:56 2012

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL> conn/as sysdba
Connected.
SQL> shutdown abort
The ORACLE routine has been disabled.
SQL> startup nomount;
The ORACLE routine has been started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> alter database mount;

The database has been changed.

SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 2 ??????
ORA-01110 :???? 2: 'e: \ ORACLE \ ORADATA \ JSDSB \ undotbs01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ undotbs01.dbf ';
Media recovery is completed.
SQL> recover tablespace system;
ORA-00283 :??????????
ORA-00264 :?????

SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 3 ??????
ORA-01110 :???? 3: 'e: \ ORACLE \ ORADATA \ JSDSB \ cwmlite01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ cwmlite01.dbf ';
Media recovery is completed.
SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 4 ??????
ORA-01110 :???? 4: 'e: \ ORACLE \ ORADATA \ JSDSB \ drsys01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ drsys01.dbf ';
Media recovery is completed.
SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 5 ??????
ORA-01110 :???? 5: 'e: \ ORACLE \ ORADATA \ JSDSB \ example01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ example01.dbf ';
Media recovery is completed.
SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 6 ??????
ORA-01110 :???? 6: 'e: \ ORACLE \ ORADATA \ JSDSB \ indx01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ indx01.dbf ';
Media recovery is completed.
SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 7 ??????
ORA-01110 :???? 7: 'e: \ ORACLE \ ORADATA \ JSDSB \ odm01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ odm01.dbf ';
Media recovery is completed.
SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 8 ??????
ORA-01110 :???? 8: 'e: \ ORACLE \ ORADATA \ JSDSB \ tools01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ tools01.dbf ';
Media recovery is completed.
SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 9 ??????
ORA-01110 :???? 9: 'e: \ ORACLE \ ORADATA \ JSDSB \ users01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ users01.dbf ';
Media recovery is completed.
SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-01113 :?? 10 ??????
ORA-01110 :???? 10: 'e: \ ORACLE \ ORADATA \ JSDSB \ xdb01.dbf'

SQL> recover datafile 'e: \ ORACLE \ ORADATA \ JSDSB \ xdb01.dbf ';
Media recovery is completed.
SQL> alter database open;
Alter database open
*
ERROR is located in row 1st:
ORA-00322 :?? 2 (?? 1 )??????
ORA-00312 :???? 2 ?? 1: 'e: \ ORACLE \ ORADATA \ JSDSB \ redo02.log'

// The redo log file is corrupted.
SQL> select group #, status, is_recovery_dest_file from v $ logfile;
Select group #, status, is_recovery_dest_file from v $ logfile
*
ERROR is located in row 1st:
ORA-00904: "IS_RECOVERY_DEST_FILE ":??????

SQL> select group #, status from v $ logfile;

GROUP # STATUS
-----------------
3 STALE
2 STALE
1

SQL> alter database clear unarchived logfile group 2;

The database has been changed.

// Clear the non-archive mode redo log file. Once cleared, the redo log group will have one fewer

SQL> alter database open;

The database has been changed.

SQL> exit
From Oracle9i Enterprise Edition Release 9.2.0.1.0-Production
With the Partitioning, OLAP and Oracle Data Mining options
Disconnects from JServer Release 9.2.0.1.0-Production

C: \ Documents ents and Settings \ Administrator>