手贱把所有的数据库文件都删除了。等发现的时候,还得瑟了一下,幸好备份了。于是拷贝之,startup。
悲剧开始:
SQL> startup
ORACLE instance started.
SQL> startup
ORACLE instance started.
Total System Global Area 238538752 bytes
Fixed Size 1335696 bytes
Variable Size 155192944 bytes
Database Buffers 79691776 bytes
Redo Buffers 2318336 bytes
ORA-00214: control file '/u01/flash_recovery_area/sam/control02.ctl' version
5095 inconsistent with file '/u01/oradata/sam/control01.ctl' version 4757
于是想起来在/u01/flash_recovery_area/sam/,这个目录里的控制文件还没有恢复。接着把/u01/oradata/sam/control02.ctl拷贝到/u01/flash_recovery_area/sam/下。心想这下完事了吧。
得瑟的敲起startup,结果继续悲剧!!!!!!!!!
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/u01/oradata/sam/control01.ctl'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3
突然想起来,这个备份是用root用户备份的。oracle根本就访问不了,如下图。
![](http://dl.iteye.com/upload/attachment/0069/7818/53603bcf-da53-3a96-9a52-51eb88a13190.png)
于是改权限、用户、组:
1,改文件的拥有者:
chown -R oracle *
2,改文件的组:
chgrp oinstall *
改完后,想着这下中可以了吧!startup之:
结果出来的是!!!!!!!!!!
SQL> startup
ORACLE instance started.
Total System Global Area 238538752 bytes
Fixed Size 1335696 bytes
Variable Size 155192944 bytes
Database Buffers 79691776 bytes
Redo Buffers 2318336 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[22], [47392], [47465], [], [], [], [], [], [], []
我崩溃了。又是看alert文件,又是看trace文件。然后怒了。重装!
这个链接的问题和我的比较像。等一回再删一次数据库文件试试。
刚才又重新试了一次,没有模拟出以上的错误。有机会吧