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;