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;