更改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小時內刪除侵權內容。