I apparently got to frisky on my production database server and deleted the FRA folder:
/oracle/u01/app/oracle/flash_recovery_area/*
which in turn removed .../flash_recovery_area/cqdb/control02.ctl
I restored that particular file [control02.ctl] from disk and re-created the folder structure on RHEL 5.8 Linux as:
[oracle@cq cqdb]$ pwd
/oracle/u01/app/oracle/flash_recovery_area/cqdb
[oracle@cq cqdb]$ ls -l
total 10112
-rw-r----- 1 oracle oinstall 10338304 Oct 12 02:16 control02.ctl
[oracle@cq cqdb]$ cd ..
[oracle@cq flash_recovery_area]$ ls -l
total 4
drwxr-xr-x 2 oracle oinstall 4096 Oct 12 11:33 cqdb
[oracle@cq flash_recovery_area]$ cd ..
[oracle@cq oracle]$ ls -l
total 36
drwxr-x--- 3 oracle oinstall 4096 May 10 14:24 admin
drwxr-xr-x 2 oracle oinstall 4096 Oct 12 11:13 backup
drwxr-xr-x 6 oracle oinstall 4096 Jul 17 12:49 cfgtoollogs
drwxr-xr-x 2 oracle oinstall 4096 Apr 23 15:38 checkpoints
drwxrwxr-x 11 oracle oinstall 4096 Apr 23 15:30 diag
drwxr-xr-x 3 oracle oinstall 4096 Oct 12 11:32 flash_recovery_area
drwxr-x--- 3 oracle oinstall 4096 Dec 13 2010 oradata
drwxr----- 3 oracle oinstall 4096 Dec 13 2010 oradiag_oracle
drwxr-xr-x 3 oracle oinstall 4096 Jul 31 15:36 product
Now when I try and start my 11g R2 (11.2.0.3) database, I get the following error:
SQL> startup
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 1258294616 bytes
Database Buffers 385875968 bytes
Redo Buffers 7118848 bytes
ORA-00214: control file '/oracle/u01/app/oracle/oradata/cqdb/control01.ctl'
version 371038 inconsistent with file
'/oracle/u01/app/oracle/flash_recovery_area/cqdb/control02.ctl' version 370763
Any idea how I can fix this? I know this was all my fault and very foolish on production but I was under the assumption that the .../flash_recovery_area/ folder was simply for RMAN backups and after changing my db_recovery_file_desintation = '/oracle/u01/app/oracle/backup/';
I just assumed I could remove / delete the folder and if it was needed for backup reasons, I could recover it from tape. When deleted it destroyed the database connection / status and recovering the file didn't work :(
Please help!
Edited by: CarlosinFL on Oct 12, 2012 12:00 PM