asm加错文件的处理

郑全

SQL> alter database mount;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6:
'/export/home/oracle/product/10.2.0/db_1/dbs/CQMU01.dbf'



alter tablespace cqmu offline;


create directory zq as '/export/home/oracle/product/10.2.0/db_1/dbs';
create directory data as '+DG_ZF/zfxt/datafile';



exec dbms_file_transfer.copy_file('ZQ','CQMU01.dbf','DATA','cqmu01.dbf');


alter tablespace cqmu rename datafile '/export/home/oracle/product/10.2.0/db_1/dbs/CQMU01.dbf' to '+DG_ZF/zfxt/datafile/cqmu01.dbf'


cover datafile '+DG_ZF/zfxt/datafile/cqmu01.dbf';


alter tablespace cqmu online;