[Code retention] ORA-01033: ORACLE initialization or shutdown in progress

Error Code: ORA-01033: ORACLE initialization or shutdown in progress

Fault description: A ORA-01033 error occurs during database connection because files such as database files ([NAME]. DMP)/log files are moved.

Fault Analysis: [Point of view is that the network itself does not guarantee its correctness] There is a common saying on the Internet that this type of fault is usually caused by the failure of Moving Files, which affects the damage to the database log files, resulting in failure to perform I/O operations. errors. ORACLE recognizes that the database is not fully loaded and the above error occurs.

Fault features: You cannot open a database using command line sqlplus or PL/SQL Developer. However, you can use the sys user to log on to the system as sysdba.

Problem Solving:

1. Answers to data recovery are common on the network. In terms of data recovery, it is certainly not guaranteed that 100% is successfully completed. This may involve some configuration of the backup mechanism. For common methods on the internet, use the Google search engine for retrieval. In this example, most methods on the Internet fail, so I cannot verify whether the methods on the Internet are correct. Try to solve the problem.

2. the official explanation for the ORA-01033 is basically to let the user wait for a period of time to log on again, based on this judgment lies in the nature of the ORA-01033 is not fully loaded caused by the busy process, A reasonable explanation of this situation can indeed be to let the user wait until the loading is complete. However, the irreversible operation of such File Corruption means that it is never possible to wait until the loading is completed. Therefore, waiting cannot be solved.

3. [hazard] The purpose of the danger mentioned is that this operation is generally not applicable to formal databases because it is destructive and irreversible data. The basic idea is to remove the database from oracle without using the backup data for restoration. For tables with a large amount of important data, we suggest you seek more professional help. However, deletion of irrelevant data due to temporary data or misoperations is very effective.

Microsoft Windows XP [version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C: \ Documents ents and Settings \ GongCen> sqlplus/as sysdba SQL * Plus: Release 10.1.0.2.0-Production on Monday March 31 14:19:39 2008 Copyright (c) 1982,200 4, Oracle. All rights reserved. Connect: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Production With the Partitioning, OLAP and Data Mining options SQL> alter database datafile 'C: \ Documents and Settings \ GongCen \ My Documents ents \ Visual Studio 2008 \ VSS Projects \ lpgl \ Code \ SQL \ lpgl 'offline drop; The database has been changed. 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 171966464 bytes Fixed Size 787988 bytes Variable Size 145488364 bytes Database Buffers 25165824 bytes Redo Buffers 524288 bytes The database has been loaded. The database has been opened.

Because only the database files are deleted and the relationships are not maintained, You need to manually delete the users of the database instance. You can use the command line or visualized tools to perform operations. To delete a user, you must have sysdba or the same type of permissions.