ORA-00205 ORA-00214 不小心把一个controlfile给删掉了

今天早上测试数据库的flash_recovery_area空间满了 ，达到100%无法使用。 按照我们理解，处理方式很简单 删除闪回恢复区的日志 ，然后在rman中crossscheck和delete一下就可以解决该问题。
哈哈，操作起来是不是信手拈来，可是悲剧的事情发生了，不知道是某为同事在flash_recovery_area下保存了一份controlfile，没有这份controlfile文件rman登录报错

点击(此处)折叠或打开

1. [oracle@Primary ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jul 14 17:32:29 2016
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
   
6. 
   
7. RMAN-00571: ===========================================================
   
8. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
   
9. RMAN-00571: ===========================================================
   
10. RMAN-00554: initialization of internal recovery manager package failed
    
11. RMAN-06003: ORACLE error from target database:
    
12. ORA-00210: cannot open the specified control file
    
13. ORA-00202: control file: '/oracle/database/fast_recovery_area/primary/control02.ctl'
    
14. ORA-27041: unable to open file
    
15. Linux-x86_64 Error: 2: No such file or directory
    
16. Additional information: 3

丢失了一份控制文件，可以复制一份都rman提示的位置。在sqlplus中登录，尝试restart ，提示ora-00214 ， 让我们来看卡ora 214， 好像SCN号不对

点击(此处)折叠或打开

1. SQL> startup force
   
2. ORACLE instance started.
   
3. 
   
4. Total System Global Area 776646656 bytes
   
5. Fixed Size 2257272 bytes
   
6. Variable Size 478154376 bytes
   
7. Database Buffers 289406976 bytes
   
8. Redo Buffers 6828032 bytes
   
9. ORA-00214: control file '/oracle/database/oradata/primary/control01.ctl' version 8130992 inconsistent with file '/oracle/database/fast_recovery_area/primary/control02.ctl' version 8130318

点击( 此处 )折叠或打开

1. [oracle@Primary ~]$ oerr ora 214
   
2. 00214, 00000, "control file '%s' version %s inconsistent with file '%s' version %s"
   
3. // *Cause: An inconsistent set of control files, datafiles/logfiles, and redo
   
4. // files was used.
   
5. // *Action: Use a consistant set of control files, datafiles/logfiles, and redo
   
6. // log files. That is, all the files must be for the same database
   
7. // and from the same time period.

那就彻底点把服务down掉，重新复制controlfile02后startup database

点击(此处)折叠或打开

1. cp /oracle/database/oradata/primary/control01.ctl /oracle/database/fast_recovery_area/primary/control02.ctl

点击(此处)折叠或打开

1. SQL> startup
   
2. ORACLE instance started.
   
3. 
   
4. Total System Global Area 776646656 bytes
   
5. Fixed Size 2257272 bytes
   
6. Variable Size 478154376 bytes
   
7. Database Buffers 289406976 bytes
   
8. Redo Buffers 6828032 bytes
   
9. Database mounted.
   
10. ORA-38760: This database instance failed to turn on flashback database
    
11. 
    
12. 
    
13. SQL> alter database flashback off;        #数据库的flashback 还是off掉，毕竟不太实用
    
14. 
    
15. Database altered.
    
16. 
    
17. SQL> alter database open;

至此数据库可以正常了，然后在重复博客开文提到的crosscheck和delete操作，alter日志不在有以下错误提示
ORA-19815: WARNING: db_recovery_file_dest_size of 4385144832 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27039319/viewspace-2121994/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27039319/viewspace-2121994/