Oracle9i数据库备份与恢复(导出导入方式).doc

Oracle9i数据库的备份和恢复以下方法是采用数据库导出备份和导入恢复来实现，这样可以保证备份的数据库相对比较小，以下方法适用于Oracle10g的数据导入。唯一区别就是在创建表空间时有一点不一样。一、数据库导出在操作系统桌面-开始-运行中输入cmd在cmd中输入如下语句进行导出备份exp jcuser/anchecydb file=F:user.dmp owner=jcuser如下图所示，那么数据备份导出到F盘，文件为user.dmp二、数据库恢复安装Oralce9i数据库，数据库SID为CYDB。刚安装完毕后，数据没有表空间、也没有用户。那么需要用PlSqlDev.exe进行表空间和用户的创建，最后进行数据导入1. 创建的表空间用PlSqlDev.exe执行SQL语句Oracle9i的SQL如下：CREATE TABLESPACE jcuser DATAFILEF:OracleoradataCYDBjcuser.DBF SIZE 500M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITEDLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO;如下图Oracle10g的SQL如下：CREATE TABLESPACE jcuser DATAFILEF:OralceoradataCYDBjcuser.DBF SIZE 500M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITEDLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTOFLASHBACK OFF;2. 创建用户用PlSqlDev.exe执行SQL语句SQL如下:CREATE USER JCUSER IDENTIFIED BY VALUES 48BF9028D593805D DEFAULT TABLESPACE jcuser TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT AQ_ADMINISTRATOR_ROLE TO JCUSER; GRANT RESOURCE TO JCUSER; GRANT IMP_FULL_DATABASE TO JCUSER; GRANT EXP_FULL_DATABASE TO JCUSER; GRANT CONNECT TO JCUSER; GRANT AQ_USER_ROLE TO JCUSER; ALTER USER JCUSER DEFAULT ROLE ALL; GRANT UNLIMITED TABLESPACE TO JCUSER; GRANT EXECUTE ON SYS.DBMS_AQ TO JCUSER;3.更改密码用PlSqlDev.exe更改用户JCUSER的密码，更改为anche如下图4.数据库导入在操作系统桌面-开始-运行中输入cmd在cmd中输入如下语句进行导入恢复imp jcuser/anche fromuser=jcuser touser=jcuser rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=n file=F:user.d