2012年2月22日重启数据库报错问题解决

 SQL> startup nomount;
ORACLE instance started.

Total System Global Area 8351150080 bytes
Fixed Size                  2176320 bytes
Variable Size            4580182720 bytes
Database Buffers         3707764736 bytes
Redo Buffers               61026304 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5:
'/opt/oracle/oracle/oradata/aaa/aaa_1.dbf'

结果一查是将文件aaa_1.dbf'移到了另外一个地方

alter database aaa rename file '/opt/oracle/oracle/oradata/aaa/aaa_1.dbf' to '/flbsmart/aaa_1.dbf';-----修改了文件

alter database open;

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/flbsmart/CBS_DEFAULT_DAT_1.dbf'

 

recover database 5;

ORA-00279: change 1578186 generated at 02/22/2012 06:13:54 needed for thread 1
ORA-00289: suggestion : /opt/oracle/db/flash_recovery_area/MDSPDBZQ/archivelog/2012_02_22/o1_mf_1_346_%u_.arc
ORA-00280: change 1578186 for thread 1 is in sequence #346

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/opt/oracle/db/flash_recovery_area/MDSPDBZQ/archivelog/2012_02_22/o1_mf_1_346_%u_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

-----这个需要archivelog来恢复

崩溃了，这个是no archive的数据库

alter database datafile 5 offline drop;

只有采取文件下线的方式

alter database open;