1.查看表空间对应关系
d:
cd D:appadministratorproduct11.2.0dbhome_1BIN
sqlplus sys/infinitt@spectra as sysdba
select * from v$tablespace;
2.关闭数据库
shutdown immediate;
3.复制数据文件到新的位置
4.启动数据库到mount状态
startup mount;
5.重命名数据文件
alter database rename file 'H:oradataspectraRISDAT01.DBF' to 'L:oradataspectraRISDAT01.DBF';
alter database rename file 'H:oradataspectraRISDAT02.DBF' to 'L:oradataspectraRISDAT02.DBF';
alter database rename file 'H:oradataspectraSPDAT01.DBF' to 'L:oradataspectraSPDAT01.DBF';
alter database rename file 'H:oradataspectraSPDAT02.DBF' to 'L:oradataspectraSPDAT02.DBF';
alter database rename file 'H:oradataspectraSPIDX01.DBF' to 'L:oradataspectraSPIDX01.DBF';
alter database rename file 'H:oradataspectraSPIDX02.DBF' to 'L:oradataspectraSPIDX02.DBF';
alter database rename file 'H:oradataspectraSYSAUX01.DBF' to 'L:oradataspectraSYSAUX01.DBF';
alter database rename file 'H:oradataspectraSYSTEM01.DBF' to 'L:oradataspectraSYSTEM01.DBF';
alter database rename file 'H:oradataspectraTEMP01.DBF' to 'L:oradataspectraTEMP01.DBF';
alter database rename file 'H:oradataspectraUNDOTBS01.DBF' to 'L:oradataspectraUNDOTBS01.DBF';
alter database rename file 'H:oradataspectraUSERS01.DBF' to 'L:oradataspectraUSERS01.DBF';
5.重命名日志文件
alter database rename file 'H:oradataspectraREDO01.LOG' to 'L:oradataspectraREDO01.LOG';
alter database rename file 'H:oradataspectraREDO02.LOG' to 'L:oradataspectraREDO02.LOG';
alter database rename file 'H:oradataspectraREDO03.LOG' to 'L:oradataspectraREDO03.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:oradataspectraCONTROL01.CTL' from 'H:oradataspectraCONTROL01.CTL' ;
restore controlfile to 'L:oradataspectraCONTROL02.CTL' from 'H:oradataspectraCONTROL02.CTL' ;
restore controlfile to 'L:oradataspectraCONTROL03.CTL' from 'H:oradataspectraCONTROL03.CTL' ;
quit //退出rman
9..修改控制文件位置
sqlplus / as sysdba
alter system set control_files='L:oradataspectraCONTROL01.CTL','L:oradataspectraCONTROL02.CTL','L:oradataspectraCONTROL03.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;
内容来源于网络如有侵权请私信删除
- 还没有人评论，欢迎说说您的想法！
客服
