- Loss all Control files
SQL> Shutdown Immediate database has been turned off. The database has been uninstalled. Oracle routines have been closed. SQL> HostMicrosoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp.
C: /> DEL D: / ORACLE9 / ORADATA / NBXTDB / *. CTL
C: /> EXIT
SQL> StartUporacle routines have been started.
Total System Global Area 378608760 Bytesfixed Size 453752 bytesvariable size 167772160 bytesdatabase buffers 209715200 BYTESREDO BUFFERS 667648 BYTESORA-00205: ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
SQL> shutdown immediateora-01507: ??????
Oracle routines have been closed. SQL> @e: /orahotbak/controltrace.sql
--ControlTrace.sql file is the use of ALTER DATABASE BACKUP Control File to TRACE; he generated under - D: / Oracle9 / Admin / Nbxtdb / UDUMP, select the creation of SQL to generate ControlTrace.SQL, then use SYS users - - Run.
Oracle routines have been started.
Total system global area 378608760 bytesfixed size 453752 bytesvariable size 167772160 bytesdatabase buffers 209715200 bytesredo buffers 667648 BYtes 209715200 BYTESREDO BUFFERS 667648 BYtes
Control file has been created
ORA-00283: ?????????? ora-00264: ?????
The system has changed.
The database has been changed.
SQL> Conn Test / TEST is connected. SQL> SELECT * from Test_Excel 2;
Accident Code Time Type ----------------------------------------- ----- 23 22- February -08 TEST125 22-February -08 TEST226 22-February -08 TEST32 24-November -03 Vehicle damage 12 07-February -03 Height fall from 13 21 to October -03 Height falling 1 22- March -02 2228 - March -09 TEST529 22- Jan -10 Test6
9 lines have been selected.
SQL>
