control files issue
hi,
Im a new Database guy and facing some issues...when I give the command:
startup mount
I get the following message:
ORACLE instance started.
Total System Global Area 146472960 bytes
Fixed Size 1335080 bytes
Variable Size 92274904 bytes
Database Buffers 50331648 bytes
Redo Buffers 2531328 bytes
ORA-00205: error in identifying control file, check alert log for more info
now when I check the alter log, it is giving me the following error message:
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/db_1/dbs/control02'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/db_1/dbs/control01'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
the log is showing that these two control files are supposed to be read from /dbs folder, although my spfile is indicating two different locations for the files one is /oradata and other is /flash_recovery_area folder. I have seen these folders and the control files are found there...
what's the issue...kindly guide a new learner...
thanx