Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Happens If You Lost a Data File
What Happens If You Lost a Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files
✍: FYIcenter.com
After you shuting down an Oracle database, you accidently deleted a data file from the operating system. If you try to start the database again you will get error when Oracle tries to open the database after mounting the database. The following tutorial examples shows you what will happen if the data file c:\temp\my_space.dbf is deleted. Oracle can still start the database instance and mount the database. But it will fail on openning the database as shown below in a SQL*Plus session:
>sqlplus /nolog SQL> connect SYSTEM/fyicenter AS SYSDBA SQL> STARTUP ORACLE instance started. Total System Global Area 100663296 bytes Fixed Size 1285956 bytes Variable Size 58720444 bytes Database Buffers 37748736 bytes Redo Buffers 2908160 bytes Database mounted. ORA-01157: cannot identify/lock data file 5 - see DBWR trace file ORA-01110: data file 5: 'C:\TEMP\MY_SPACE.DBF' SQL> SHUTDOWN; ORA-01109: database not open Database dismounted. ORACLE instance shut down.
2007-05-03, 5940👍, 0💬
Popular Posts:
What are secure and non-secure websites? A secure Website uses the Secure Socket Layer (SSL) protoco...
.NET INTERVIEW QUESTIONS - What is the difference between thread and process? A thread is a path of ...
it will be very helpful if you send some important Questions with Answers of DBMS Tell us what types...
Where are all .NET Collection classes located ? System.Collection namespace has all the collection c...
How can I search for data in a linked list? Unfortunately, the only way to search a linked list is w...