重做系统后 恢复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;

　　连接你的实例,成功！！！！

转载于:https://www.cnblogs.com/suchen07/p/9396566.html