RMAN备份错误

本帖最后由 iiwoai 于 2011-10-11 15:19 编辑

一、ORA-19573: cannot obtain exclusive enqueue for datafile 3
1、设置表空间离线
SQL>alter tablespace spacename offline;
2、重启数据库 开为mount模式
SQL> SHUTDOWN IMMEDIATE;
RMAN>STARTUP MOUNT
RMAN>

二、SQL> startup
SQL>alter database open;
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/dtberp/system01.dbf'

解决方法：
SQL> RECOVER DATAFILE  '/u01/app/oracle/oradata/dtberp/system01.dbf'
Media recovery complete.
SQL> recover tablespace system;
Media recovery complete.
SQL> RECOVER DATABASE;
Media recovery complete.
SQL> ALTER DATABASE OPEN;
Database altered.

恢复失败，仍提示数据错误。
报错之后查看状态，如为OFFLINE 或RECOVER 如下恢复
SQL> select file#,status from v$datafile;
     FILE# STATUS
---------- -------
         1 SYSTEM
         2 RECOVER
         3 ONLINE
         4 ONLINE

SQL>RECOVER DATAFILE 2
auto
SQL>alter database datafile 2 online;
SQL> select file#,status from v$datafile;
     FILE# STATUS
---------- -------
         1 SYSTEM
         2 ONLINE
         3 ONLINE