1.查看表空間對應關係 d: cd D:\app\administrator\product\11.2.0\dbhome_1\BIN sqlplus sys/infinitt@spectra as sysdba select * from v$tablespace; 2.關閉資料庫 shutdown ...
1.查看表空間對應關係 d: cd D:\app\administrator\product\11.2.0\dbhome_1\BIN sqlplus sys/infinitt@spectra as sysdba select * 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; quit rmant 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 sysdba alter 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;
