更改asm磁盘冗余模式

参考：438580.1

备份spfile:

SQL> create pfile='d:\initsid.ora' from spfile;

控制文件备份：

SQL> alter database backup controlfile to '+DG1';

SQL> alter system set control_files='+DG1\ORCL10G\CONTROLFILE\' SCOPE=SPFILE;

恢复控制文件到新位置：

$ rman target /

RMAN > shutdown immediate;

RMAN > startup nomount;

RMAN> restore controlfile to '' from '+DG2\ORCL10G\CONTROLFILE\mycontrol.ctl';

RMAN > alter database mount;

拷贝数据文件到新位置：

RMAN> backup as copy database format '+DG1';

RMAN> switch database to copy;

RMAN> recover database ;

RMAN> alter database open resetlogs;

TEMP文件位置更新：

SQL> alter tablespace TEMP add tempfile '+DG1' SIZE 10M;

SQL> alter database tempfile '+DG2/orcl10g/tempfile/temp.265.626631119' dro

LOGfile文件位置更新：

SQL> alter database add logfile member '+DG1' to group 1;

SQL> alter database add logfile member '+DG1' to group 2;

SQL> alter database add logfile member '+DG1' to group 3;

SQL> alter database drop logfile member 'complete_name';

检查所有文件位置：

SQL> select name from v$controlfile

union

select name from v$datafile

union

select name from v$tempfile

union

select member from v$logfile

union

select filename from v$block_change_tracking

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。