1. 移动数据文件(不包括SYSTEM,TEMP,RBS,控制文件) shutdown; 用操作系统命令移动文件(NT下用move,unix下用mv) connect internal/oracle; startup mount; alter database rename file 'oldfile' to 'newfile'; alter database open;2.移动控制文件 1) 关闭实例; 2) 使用操作系统指令移动文件; 3)编辑init<SID>.ora,例如: OLD CONFIG: control_files = (/db01/oracle/CC1/ctrl1CC1.ctl, /db03/oracle/CC1/ctrl1CC1.ctl, /db05/oracle/CC1/ctrl1CC1.ctl)
NEW CONFIG: control_files = (/db01/oracle/CC1/ctrl1CC1.ctl, /db03/oracle/CC1/ctrl1CC1.ctl, /db02/oracle/CC1/ctrl1CC1.ctl)
4) 启动实例(startup)3. 移动其他表空间文件(重建控制文件)
alter database backup controlfile to trace; shutdown; move the files edit the generated CREATE CONTROLFILE statement (found in the user dump destination) and change the filenames use the generated script you just edited to startup the database.
shutdown;
用操作系统命令移动文件(NT下用move,unix下用mv)
connect internal/oracle;
startup mount;
alter database rename file 'oldfile' to 'newfile';
alter database open;2.移动控制文件
1) 关闭实例;
2) 使用操作系统指令移动文件;
3)编辑init<SID>.ora,例如: OLD CONFIG:
control_files = (/db01/oracle/CC1/ctrl1CC1.ctl,
/db03/oracle/CC1/ctrl1CC1.ctl,
/db05/oracle/CC1/ctrl1CC1.ctl)
NEW CONFIG:
control_files = (/db01/oracle/CC1/ctrl1CC1.ctl,
/db03/oracle/CC1/ctrl1CC1.ctl,
/db02/oracle/CC1/ctrl1CC1.ctl)
4) 启动实例(startup)3. 移动其他表空间文件(重建控制文件)
alter database backup controlfile to trace; shutdown; move the files edit the generated CREATE CONTROLFILE statement
(found in the user dump destination) and change the
filenames use the generated script you just edited to startup
the database.