Oracle控制檔案記錄檔資料檔案遷移

標籤：資料庫   logfile   控制   ctr   複製   min   log   art   force   

1.查看錶空間對應關係d:cd D:\app\administrator\product\11.2.0\dbhome_1\BINsqlplus sys/[email protected] as sysdbaselect * from v$tablespace; 2.關閉資料庫shutdown immediate; 3.複製資料檔案到新的位置 4.啟動資料庫到mount狀態startup mount;5.重新命名資料檔案alter database rename file ‘H:\oradata\spectra\RISDAT01.DBF‘ to ‘L:\oradata\spectra\RISDAT01.DBF‘;alter database rename file ‘H:\oradata\spectra\RISDAT02.DBF‘ to ‘L:\oradata\spectra\RISDAT02.DBF‘;alter database rename file ‘H:\oradata\spectra\SPDAT01.DBF‘ to ‘L:\oradata\spectra\SPDAT01.DBF‘;alter database rename file ‘H:\oradata\spectra\SPDAT02.DBF‘ to ‘L:\oradata\spectra\SPDAT02.DBF‘;alter database rename file ‘H:\oradata\spectra\SPIDX01.DBF‘ to ‘L:\oradata\spectra\SPIDX01.DBF‘;alter database rename file ‘H:\oradata\spectra\SPIDX02.DBF‘ to ‘L:\oradata\spectra\SPIDX02.DBF‘;alter database rename file ‘H:\oradata\spectra\SYSAUX01.DBF‘ to ‘L:\oradata\spectra\SYSAUX01.DBF‘;alter database rename file ‘H:\oradata\spectra\SYSTEM01.DBF‘ to ‘L:\oradata\spectra\SYSTEM01.DBF‘;alter database rename file ‘H:\oradata\spectra\TEMP01.DBF‘ to ‘L:\oradata\spectra\TEMP01.DBF‘;alter database rename file ‘H:\oradata\spectra\UNDOTBS01.DBF‘ to ‘L:\oradata\spectra\UNDOTBS01.DBF‘;alter database rename file ‘H:\oradata\spectra\USERS01.DBF‘ to ‘L:\oradata\spectra\USERS01.DBF‘;  5.重新命名記錄檔alter database rename file ‘H:\oradata\spectra\REDO01.LOG‘ to ‘L:\oradata\spectra\REDO01.LOG‘;alter database rename file ‘H:\oradata\spectra\REDO02.LOG‘ to ‘L:\oradata\spectra\REDO02.LOG‘;alter database rename file ‘H:\oradata\spectra\REDO03.LOG‘ to ‘L:\oradata\spectra\REDO03.LOG‘;6.開啟資料庫並查看狀態alter database open;shutdown immediate;startup;select * from v$logfile;或select a.group#, a.status, b.member,a.bytes/1024/1024 sizeM from v$log a ,v$logfile b where a.group#=b.group#;alter system switch logfile;//切換日誌 ===========================================================7.查看控制檔案select name from v$controlfile; 8.恢複控制檔案shutdown immediate;startup nomount;quitrmant target /restore controlfile to ‘L:\oradata\spectra\CONTROL01.CTL‘ from ‘H:\oradata\spectra\CONTROL01.CTL‘ ;restore controlfile to ‘L:\oradata\spectra\CONTROL02.CTL‘ from ‘H:\oradata\spectra\CONTROL02.CTL‘ ;restore controlfile to ‘L:\oradata\spectra\CONTROL03.CTL‘ from ‘H:\oradata\spectra\CONTROL03.CTL‘ ; quit //退出rman 9..修改控制檔案位置sqlplus / as sysdbaalter system set control_files=‘L:\oradata\spectra\CONTROL01.CTL‘,‘L:\oradata\spectra\CONTROL02.CTL‘,‘L:\oradata\spectra\CONTROL03.CTL‘  scope=spfile; 10.啟動資料庫startup mount force;select * from v$controlfile;alter database open;select * from spectra.version;  11.查看資料庫以上更改的資訊 select name from v$controlfile;select * from v$logfile;select * from v$tablespace; 

Oracle控制檔案記錄檔資料檔案遷移