oracle 恢复备份

 

select * from dbconninfo

update dbconninfo set url = 'jdbc:oracle:thin:@(description=(address_list=(address=(host=localhost)(protocol=tcp)(port=1521))(address=(host=localhost)(protocol=tcp) (port=1521)) (load_balance=yes)(failover=yes))(connect_data=(service_name=racdb)))'

oracle 恢复备份过程：

0、导出语句
exp 'system/bzhs!*6@racdb as sysdba' file=fullexp.dmp full=y

1、手工创建数据库racdb

2、手工创建表空间
TM3_SHNXMYJT_SM
TM3_SHNXMYJT_JF
DATAWIN
TM3_SHNXMYJT_SUB
TM3_SHNXMYJT_SYS

3、手工创建用户
TM3_SHNXMYJT_SM
TM3_SHNXMYJT_JF
DATAWIN
TM3_SHNXMYJT_SUB
TM3_SHNXMYJT_SYS

4、测试用户可登陆
sqlplus system/bzhs!*6@racdb as sysdba

6、还原数据库文件 full.dmp（D盘根目录）
imp 'system/bzhs!*6@racdb as sysdba' file=full.dmp ignore=y full=y

7、测试语句
drop user se cascade;