ORA-00214 control file flash_recovery_area version %s inconsistent with file version %s


Error Description:
Database startup failed with following error after the database cold backup restoration.
SQL> startup
ORACLE instance started.

Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             343933392 bytes
Database Buffers          184549376 bytes
Redo Buffers                5804032 bytes
ORA-00214: control file 'D:\APP\ORADATA\ORCL\CONTROL01.CTL' version 10399
inconsistent with file 'D:\APP\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL' version 10386
Solution Description:
This error is because of the control file which is present on the FLASH_RECOVERY_AREA is not consistent with the control file available with the database files. Most of the case this error occurs after the cold backuprestoration. In majority case when we restore the cold backup all the data files including control files get restored to the normal db files location. But the FLASH_RECOVERY_AREA files remains as it is without any changes. In the init/spfile there should be an entry for the flash_recovery_area control file. When you try to startup the database with the spfile, the controlfiles (flash recovery area and the other control file) will not be in sync and it throws this error.
How to resolve this error?
Method 1: Sync the control files
Step 1: start the database in nomount mode.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             343933392 bytes
Database Buffers          184549376 bytes
Redo Buffers                5804032 bytes
Step 2: find out the control_files parameter value
SQL> show parameter control_files
control_files  string    D:\APP\ORADATA\ORCL\CONTROL01.CTL, D:\APP\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL
Step 3: Shutdown the database.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
Step 4: Copy the control file from ORADATA directory to the FLAS_RECOVERY_AREA directory using OS commands.
D:\export>copy D:\APP\ORADATA\ORCL\CONTROL01.CTL D:\APP\FLASH_RECOVERY_AREA\ORCL
\CONTROL02.CTL
Overwrite D:\APP\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL? (Yes/No/All): yes
        1 file(s) copied.
Step 5: startup the database in normal mode.
Method 2: Remove the flash_recovery_area control file from the parameter file
Step 1: start the database in nomount mode.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             343933392 bytes
Database Buffers          184549376 bytes
Redo Buffers                5804032 bytes
Step 2: Create the pfile from spfile(only if it is running on spfile)
SQL> create pfile='D:\app\product\11.2.0\dbhome_1\database\initORCL.ora' fromspfile='D:\app\product\11.2.0\dbhome_1\database\SPFILEORCL.ORA';
Step 3: open the initORCL.ora file and modify the control_files parameter. Remove the entry marked in red which means remove the flash_recovery_area control file entry from the parameter file.
*.control_files='D:\app\oradata\orcl\control01.ctl', 'D:\app\flash_recovery_area\orcl\control02.ctl'
Step 4: Startup the database with initORCL.ora file
SQL> startup pfile='D:\app\product\11.2.0\dbhome_1\database\initORCL.ora'
ORACLE instance started.
Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             343933392 bytes
Database Buffers          184549376 bytes
Redo Buffers                5804032 bytes
Database mounted.
Database opened.
Step 5: create spfile from pfile
SQL> create spfile='D:\app\product\11.2.0\dbhome_1\database\SPFILEORCL.ORA' frompfile='D:\app\product\11.2.0\dbhome_1\database\initORCL.ora';
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google