"Teach Oracle Learn Oracle" -- Taj Contact me for support at askdbataj@gmail.com This blog is dedicated to all ORACLE Professionals and Learning Students.
Search This Blog
Wednesday, March 28, 2007
Control File Corrupted.
Database 10gr1.
NoArchiveLog Mode
OS Windows
SQL> create tablespace test
2 datafile 'c:\test01.dbf' size 1m;
create tablespace test
*
ERROR at line 1:
ORA-00227: corrupt block detected in controlfile: (block 1, # blocks 1)
ORA-00202: controlfile: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB01\CONTROL01.CTL'
SQL> shutdown abort;
ORACLE instance shut down.
SQL> --First Delete control01.ctl file and create new copy through control02.ctl
SQL> host del c:\oracle\product\10.1.0\oradata\db01\control01.ctl
ystem32\cmd.exe /c clsSQL> disconn
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
SQL> exit
C:\oracle\product\10.1.0\Db_1\BIN>sqlplus/nolog
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Mar 28 19:21:42 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string C:\ORACLE\PRODUCT\10.1.0\ORADA
TA\DB01\CONTROL01.CTL, C:\ORAC
LE\PRODUCT\10.1.0\ORADATA\DB01
\CONTROL02.CTL, C:\ORACLE\PROD
UCT\10.1.0\ORADATA\DB01\CONTRO
L03.CTL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment