修改控制文件,数据文件,日志文件等目录位置
1.准备工作:找出现使用的控制文件,数据文件,日志文件,临时文件目录
Select name from v$datafile;
Select name from v$controlfile;
Select member from v$logfile;
select name from v$tempfile;
准备好要恢复到文件目录(冷备份的目录)
如:’/tmp/coldbak/control01.ctl’,’/tmp/coldbak/users01.dbf’等等
2.修改控制文件位置
Alter system set control_files=
'/usr/oradata/orcl/control01.ctl',
'/usr/oradata/orcl/control02.ctl',
'/usr/oradata/orcl/control03.ctl' scope=spfile;
验证修改情况
select value from v$spparameter where name='control_files';
3.修改数据文件,日志文件,临时文件到要恢复的目录文件
Alter database rename file
'/usr/oradata/orcl/system01.dbf' to '/tmp/coldbak/system01.dbf';
Alter database rename file
'/usr/oradata/orcl/undotbs01.dbf' to '/tmp/coldbak/undotbs01.dbf';
Alter database rename file
'/usr/oradata/orcl/sysaux01.dbf' to '/tmp/coldbak/sysaux01.dbf';
Alter database rename file
'/usr/oradata/orcl/users01.dbf' to '/tmp/coldbak/users01.dbf';
Alter database rename file
'/usr/oradata/orcl/redo01.log to '/tmp/coldbak/redo01.log’;
Alter database rename file
'/usr/oradata/orcl/redo02.log to '/tmp/coldbak/redo02.log';
Alter database rename file
'/usr/oradata/orcl/redo03.log’ to '/tmp/coldbak/redo03.log';
4.重新启动数据库
如果出现:
ORA-38760: This database instance failed to turn on flashback database
在mount状态下
Alter database flashback off;
Alter database open;
再重启到mount下
Alter database flashback on;
Alter database open;
--END
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26466695/viewspace-748019/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26466695/viewspace-748019/