ORACLE Data File Corruption, error: ora-01033: oracle initialization or shutdown in progress

First, the cause of the problem. This error occurs when I delete a file under \ oracle \ product \ 10.1.0 \ oradata \ oral.

When I used SQL statement statements to create a tablespace, I was so anxious to delete the created file. The problem arises. Sysdba can log on, but in use, the "database is not open, only allow query in the fixed table/View" appears, while normal users cannot log on to use, the ORA-01033 appears: ORACLE initialization or shutdown in progress error.

Analysis: the cause of this error is that after Oracle is started, the user needs to load the original configuration information in the solution during login. During the loading process, files in the configuration are not found, therefore, an error is reported.

Solution Process:

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

SQL * Plus: Release 10.1.0.2.0-Production on Monday September 28 14:35:38 2009

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

SQL> connect sys/123 as sysdba;
Connected.
SQL> shutdown normal
ORA-01109: the database is not open

The database has been detached.
The ORACLE routine has been disabled.
SQL> startup mount;
The ORACLE routine has been started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
The database has been loaded.
SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01589: to open the database, you must use the RESETLOGS or NORESETLOGS Option

SQL> alter database open resetlogs;
Alter database open resetlogs
*
Row 3 has an error:
ORA-01157: unable to identify/lock data file 6-see DBWR trace file
ORA-01110: data file 6: 'C: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORAL \ fscredit40'

SQL> alter database datafile 6 offline drop;

The database has been changed.

SQL> alter database open resetlogs;

The database has been changed.

SQL> alter database datafile 6 offline drop;

The database has been changed.

SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01531: Routine opened database

SQL> shutdown normal
Tip: the database is closed.
Database uninstalled
ORACLE routine disabled

SQL> startup mount;
The ORACLE routine has been started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database buffers 25165824 bytes
Redo buffers 262144 bytes
The database has been loaded.

At this point, the problem is solved.
========================================================== =====

========================================================== ====

Other articles on the Internet

============================================

======================================

Oracle Database File Corruption has been solved. The problem is "error: ORA-01033: Oracle initialization or shutdown in progress", and later from the Internet to find some information, and finally add their own practice finally solved, but there is a problem, it seems that the database files are useless.

Solution
In a DOS environment
Sqlplus/nolog
SQL> connect sys/sys as sysdba
SQL> shutdown normal
SQL> startup Mount
SQL> alter database open;

Row 3 has an error:
ORA-01157: unable to identify/lock data file 6-see dbwr trace file
ORA-01110: data file 6: 'd:/Oracle/oradata/oragwh/indx01.dbf''

If this problem occurs, continue to enter
SQL> conn sys/sys as sysdba;
Connected.
SQL> alter database datafile 6 offline drop;

Until Scott logs in.
SQL> conn Scott/Tiger

Then enter
SQL> shutdown normal
SQL> startup

This article from the csdn blog, reproduced please indicate the source: http://blog.csdn.net/henlson/archive/2007/07/18/1696966.aspx

When you enter the preceding command, the following problems may occur:

ORA-00313: Unable to open a member of log group 1 (thread 1)

The solution is as follows:

Run Oracle ---- integrated management tools ---- sqlplus Worksheet

SQL> connect/As sysdba;

Connected.

SQL> shutdown immediate;

ORA-01109: the database is not open

The database has been detached.

The Oracle routine has been disabled.

SQL> startup;

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

The database has been loaded.

ORA-00313: Unable to open a member of log group 1 (thread 1)

ORA-00312: Online log 1 thread 1: 'C: \ oracle \ oradata \ orcl \ redo01.log'

Check whether c: \ oracle \ oradata \ myoracle \ redo01.log is still running, but redo02.log and redo03.log are deleted by mistake.

Try another routine, OEMREP. The results are still the same!

Is it possible to reinstall the database? Is there any way to solve this problem?

Solution:

SQL> shutdown immediate;

ORA-01109: the database is not open

The database has been detached.

SQL> startup mount;

The ORACLE routine has been started.

SQL> select * from v $ log;

GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIME

--------------------------------------------------------------------------------------------

1 1 0 104857600 1 no uncurrent 670680 month-07

2 1 15 104857600 1 NO unactive 696119 06-12-07

3 1 0 104857600 1 NO Unactive 650182 month-07

3 rows have been selected.

Alter database clear unarchived logfile group 1;/* recreate the log file */

The database has been changed.

Alter database clear unarchived logfile group 2;

The database has been changed.

Alter database clear unarchived logfile group 3;

The database has been changed.

SQL> shutdown;

The database has been detached.

The ORACLE routine has been disabled.

SQL> startup;

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

The database has been loaded.

The database has been opened.

Solve the problem!

However, after performing the same operation on the myoracle routine, I don't know what went wrong,

SQL> startup;

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

The database has been loaded.

ORA-03113: End of file for communication channel

There are many reasons for this problem when searching for information on the Internet, generally because the network is disconnected or init. ora, C: \ oracle \ ora92 \ network \ admin \ sqlnet. ora or tnsnames. ora has a problem. obviously, these are not suitable for me. one of my two routines can be used normally, and the other has problems!

After I close the database, open it again and execute:

SQL> connect "/as sysdba ";

SQL> select * from scott. emp;

ORA-27101 shared memory realm does not exist-

There are many explanations for this error. Check init. if there is a problem with the memory configuration of the ora file, but the command is executed when the database is not opened, the following error message will also appear: I belong to the latter, this is because the database is not mounted. please remind me.

Later, I thought about it and encountered an error:

ORA-24324: Service handle not initialized

ORA-01041: Internal error, hostdef extension does not exist

This is getting messy. In desperation, I had to repeat it and repeat it again. The operation started from re-configuring the log file. However, the error disappears due to a miracle, it does not prompt that the communication channel file is over, and the database is normal, but it is dizzy!

Troubleshooting knowledge:

First, run the following statement to check whether group1 is a current log group.

Select * from v $ log;

If the deleted log is not a member of the current log group, it is relatively simple.

Alter database clear logfile group 1;

If your database is not archived, use the following statement.

Alter database clear unarchived logfile group 1;

If the current log group is corrupted but the database is shut down normally, the above method can also be used.

If there are active transactions in the log group, you may need to use backup to recover the transaction as follows:

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

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

SQL * Plus: Release 10.2.0.1.0-Production on Saturday May 27 11:19:52 2006 Copyright (c) 1982,200 5, Oracle. All rights

Reserved.

SQL> conn sys/dd as sysdba

Connected.

SQL> startup mount

ORA-01081: unable to start Oracle that is already running-Close it first

SQL> recover database until time '2017-05-19 13:45:02 ';/* restore */

/* (Recover database until cancel; Alter database resetlogs; re-create the log file). I do not know which method is used .*/

Media recovery is completed.

SQL> alter database open resetlogs;

The database has been changed.

SQL> shutdown immediate;

The database has been closed.

The database has been detached.

The Oracle routine has been disabled.

SQL> startup

The Oracle routine has been started.

Total system global area 205520896 bytes

Fixed size 1248092 bytes

Variable Size 79692964 bytes

Database buffers 117440512 bytes

Redo buffers 7139328 bytes

The database has been loaded.

The database has been opened.

SQL>