重做系统后 恢复oracle 实例
第一次进行操作,按照网上方法,试了一遍,很多细节搞不清楚,但是还是要记录一下.
备份 old数据库
所用到文件有:
XXXXXX\product\11.2.0\dbhome_1\database\pwdXXXX.ora文件
XXXXXX\flash_recovery_area\XXXXXXXX\CONTROL02.ctl文件
XXXXXX\oradata\xxxxxxxxx\下的所有文件
为了成功,选择与之前安装的oracle相同版本相同路径,进行安装。推荐不要安装数据库。
通过 Database Configuration Assistant 新建实例,尽量与之前实例相同。
准备工作完毕
关闭oracle实例 监听
用备份文件替换新的文件。
开启 实例 监听
cmd下 set oracle_sid=xxxxxx;
登入 sysdba 账户
若是新安装的oracle路径不对,修改XXXXXX\oradata\xxxxxxxxx\实例下的所有文件路径。
通过
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\SYSTEM01.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\SYSTEM01.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\SYSAUX01.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\SYSAUX01.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\UNDOTBS01.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\UNDOTBS01.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\USERS01.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\USERS01.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_BASIS.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_BASIS.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_ARCHIVES.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_ARCHIVES.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_SERVICES.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_SERVICES.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_REPORT.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_REPORT.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_INDEX.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_INDEX.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_BIRTHCERTIFICATE.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_BIRTHCERTIFICATE.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_SPECIALARCHIVES.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_SPECIALARCHIVES.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_FAMILYCONTRACT.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_FAMILYCONTRACT.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_HEALTHEDUCATION.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_HEALTHEDUCATION.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_EXTEND.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_EXTEND.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_HISINTERFACE.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_HISINTERFACE.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_FILES.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_FILES.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_STATS.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\ZLCHS_STATS.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\SYSTEM01.DBF' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\SYSTEM01.DBF';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\REDO01.log' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\REDO01.log';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\REDO02.LOG' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\REDO02.LOG';
alter database rename file 'F:\APP\ADMINISTRATOR\ORADATA\ZLC\REDO03.LOG' to 'd:\APP\ADMINISTRATOR\ORADATA\ZLC\REDO03.LOG';
修改。
确定全部修改,执行 alter database open;
连接你的实例,成功!!!!
最新文章
- 使用Nito.AsyncEx实现异步锁(转)
- linux有关信号的FAQ
- bzoj 2753: [SCOI2012] 滑雪与时间胶囊 Label:MST
- Python下载进度条
- LR手动关联新手总结
- SpringMvc JSON 406,吐血。。。。
- Ogre2.1 灯光与阴影
- 简单的JQuery top返回顶部
- AJAX - 类型“System.Web.UI.UpdatePanel”不具有名为“FileUpload”的公共属性。
- linux中服务器定时程序设定
- Lambda&;Java多核编程-6-方法与构造器引用
- Selenium基础知识
- Java+Velocity模板引擎集成插件到Eclipse及使用例子
- Git文件状态描述
- python中的小知识点
- 半导体制造、Fab以及Silicon Processing的基本知识
- RabbitMQ安装后无法访问https://localhost:15672/ 控制台问题解决
- todos+增删改查+js练习
- jenkins 关联 钉钉机器人
- POJ 2400 Supervisor, Supervisee(KM二分图最大权值匹配)题解