重庆思庄Oracle、Redhat认证学习论坛

标题: asm加错文件的处理 [打印本页]

作者: 郑全 时间: 2015-9-30 17:10
标题: 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;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)