AM UNABLE TO OPEN THE DATABACE MY DATABASE IS NOT MOUNTING COMMING ERROR AS
*""""'*
SQLPlus: Release 11.2.0.1.0 Production on Mon Sep 10 20:24:59 2012*
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys
Enter password:
SP2-0306: Invalid option.
*Usage: CONN[ECT] [
logon [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]*
*where <logon> ::= <username>[<password>][@<connect_identifier>]*
*<proxy> ::= <proxyuser>[<username>][<password>][@<connect_identifier>]*
Enter user-name: connect /as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "SYS"
SQL> select from tab*
*2 ;*
select from tab*
***
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> select from customers;*
select from customers*
***
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> select from customer;*
select from customer*
***
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> startup fource mount;
SP2-0714: invalid combination of STARTUP options
SQL> recovery database;
SP2-0734: unknown command beginning "recovery d..." - rest of line ignored.
SQL> alter database open;
alter database open
***
ERROR at line 1:
ORA-01507: database not mounted
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup force mount;
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 360710608 bytes
Database Buffers 167772160 bytes
Redo Buffers 5804032 bytes
ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file: 'C:\APP\SURYA\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL'
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).
SQL> recover database;
ORA-01507: database not mounted. """""""""""""""""''
SO PLEASE HELP ME AND CLARIFY ME THIS PROLEM , MAY B WITH DIS ONLY I MAY NT CONNECTING TO MY FORMS BUILDER & ,....................... MY PROJECT IS ON HOLD PLZ !
MY CONTACT IS *"RAVI_TECHNOLOGY@YAHOO.CO.IN"*