关库,删文件
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@ocm disk1]$ mv system01.dbf system01.dbf_20140120
[oracle@ocm disk1]$ ls
control01.ctl redo01.log sysaux01.dbf t1_02.dbf undotbs02.dbf
EXAMPLE.dbf redo02.log system01.dbf_20140120 temp01.dbf USERS_01.dbf
JCHINDEX_01.dbf redo03.log t1_01.dbf undotbs01.dbf
[oracle@ocm disk1]$
去告警日志里面看看怎么回事?两方面来诊断数据库的错误。
强制删除后,启动,数据库处于异常关闭状态。
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
进入rman:
rman target sys/oracle@JCH111 catalog catalog_admin/catalog_admin@JCH112
查看表空间状态,和文件目录,发现 system01.dbf回来了!