Home > Database > Mysql Tutorial > body text

基于用户控制的oracle热备文件的异机恢复

WBOY
Release: 2016-06-07 17:37:16
Original
1158 people have browsed it

测试目的:检测windows下oracle热备文件(含spfile,控制文件,数据文件,归档日志,非rman方式)异机恢复,非原路径下的恢复可用性。测试环境:windows2003R2,O

测试目的:检测windows下oracle热备文件(4 (,6 (,,,AL32UTF8

7,关闭数据库,启动到nomount模式,删除或重命名之前用的控制文件,执行上面代码创建控制文件:

image

8,将数据库启动到mount模式

alter database mount;

9,通过归档日志还原数据库,,恢复过程中指定归档文件路径

recover database using backup controlfile until cancel

image

10,恢复完成后,通过resetlogs模式启动数据库:

alter database open resetlogs;

image



我的博客:

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!