Oracle+sde数据备份、恢复

<P>1.数据库完整备份
EXP <a href="mailtSYSTEM/PASSWORD@SID" target="_blank" >SYSTEM/PASSWORD@SID</A> FULL=Y FILE=D:\SYSTEM.DMP LOG=D:\SYSTEM.LOG
2.数据入库
  (a)从数据库中删除SDE和SDE USER用户
 DROP USER SDE CASCADE;
 DROP USER SDEUSER CASCADE;
  (b)创建新的SDE用户和SDEUSER
  下为创建SDE用户过程:
  (i)创建表空间  
CREATE TABLESPACE "SDE"
    LOGGING
    DATAFILE 'C:\ORACLE\ORADATA\ORACLE\SDE.ora' SIZE 200M
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO  
  (ii)创建用户
CREATE USER "SDE"  PROFILE "DEFAULT"
    IDENTIFIED BY "PASSWORD" DEFAULT TABLESPACE "SDE"
    TEMPORARY TABLESPACE "TEMP"
    ACCOUNT UNLOCK;
  (iii)创建角色
GRANT "DBA" TO "SDE";
GRANT "CONNECT" TO "SDE";
GRANT "RESOURCE" TO "SDE";
  (iiii)系统权限
GRANT ALTER ANY INDEX TO "SDE" WITH ADMIN OPTION;
GRANT ALTER ANY TABLE TO "SDE" WITH ADMIN OPTION;
GRANT ANALYZE ANY TO "SDE" WITH ADMIN OPTION;
GRANT CREATE ANY INDEX TO "SDE" WITH ADMIN OPTION;
GRANT CREATE ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;
GRANT CREATE ANY TRIGGER TO "SDE" WITH ADMIN OPTION;
GRANT CREATE ANY VIEW TO "SDE" WITH ADMIN OPTION;
GRANT CREATE SESSION TO "SDE" WITH ADMIN OPTION;
GRANT DROP ANY INDEX TO "SDE" WITH ADMIN OPTION;
GRANT DROP ANY TABLE TO "SDE" WITH ADMIN OPTION;
GRANT DROP ANY VIEW TO "SDE" WITH ADMIN OPTION;
GRANT DROP ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;
GRANT DROP ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;
GRANT EXECUTE ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;
GRANT SELECT ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;
GRANT SELECT ANY TABLE TO "SDE" WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE  TO "SDE" WITH ADMIN OPTION;</P>
<P>3.导入SDE和SDEUSER的数据
注意顺序，先SDE，后SDEUSER
IMP <a href="mailtSYSTEM/PASSWOR@SID" target="_blank" >SYSTEM/PASSWOR@SID</A> FROMUSER=SDE TOUSER=SDE
IMP <a href="mailtSYSTEM/PASSWOR@SID" target="_blank" >SYSTEM/PASSWOR@SID</A> FROMUSER=SDEUSER TOUSER=SDEUSER</P>
<P>以上提到的SDE和SDEUSER是不同的用户，SDE是ArcSDE安装时的默认用户，SDEUSER
是指用户存储数据的用户，如果之间使用SDE默认用户存储，则省去所以的SDEUSER操作
</P>

大哥，太有用了，雪中送炭啊！<img src="images/post/smile/dvbbs/em02.gif" />

<P>sde服务启动不了，可能是sde表空间被oracle锁定了。用客户端进入oracle中，然后解锁，看看好不好用。或者清空sde表空间中的table_locks这个表中的记录看看呢</P>

oracle低版本先升级到高版本了，然后在备份，才能导入高版本中的

值得好好研究！！<img src="images/post/smile/dvbbs/em02.gif" />

<TABLE fixed; WORD-BREAK: break-all" height="85%" width="95%" align=center border=0>

<TR>
<TD 9pt; LINE-HEIGHT: 12pt" vAlign=top width=* height="100%"> <B></B><BR>谢谢</TD></TR></TABLE>

<P>“本地计算机上的arcsde service(esri_sde)服务启动后又停止。一些服务自动停止，如果他们没有什么可做的，例如“性能日至和警报”服务.”</P>
<P>重新配置一边sde服务就可以了！</P>

谢谢

关键是在 oracle 8.17与ArcSde9.0之间备份恢复都不行，同样的软件配置在不同的电脑上备份恢复数据。

不错！