重做系统后 恢复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;
连接你的实例,成功!!!!