oracle8 备份与恢复(exp/imp)

1.start/cmd:exp system/manager@ea21sg2t full=y file=e:/oracle/ea21sg2t.dmp log=ea21sg2t.log 

2.create database.

3.start/cmd:svrmgrl

connect internal/oracle@ea21sg2t

@f:/setupOracle/tablespace.sql

tablespace.sql:

spool E:/oracle/admin/ea21sg2t/create/createdb1_ea21sg2tidx.log
drop tablespace RHOMBUS_CM_TS_DATA including contents;      
CREATE TABLESPACE RHOMBUS_CM_TS_DATA                                                             
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/cm/CMMODULE01_RHOMBUSSG6T.DBF' SIZE 100M REUSE;    
drop tablespace EA21_MF_TS_DATA including contents;      
CREATE TABLESPACE EA21_MF_TS_DATA                                                              
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/mf/mfmodule01_ea21sg2t.dbf' SIZE 1400M REUSE;       
drop tablespace EA21_QT_TS_DATA including contents;                                      
CREATE TABLESPACE EA21_QT_TS_DATA                                                              
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/qt/qtmodule01_ea21sg2t.dbf' SIZE 500M REUSE;          
drop tablespace EA21_CO_TS_DATA including contents;                                            
CREATE TABLESPACE EA21_CO_TS_DATA                                                              
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/co/comodule01_ea21sg2t.dbf' SIZE 1200M REUSE;    
drop tablespace EA21_SI_TS_DATA including contents;                                            
CREATE TABLESPACE EA21_SI_TS_DATA                                                              
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/si/simodule01_ea21sg2t.dbf' SIZE 200M REUSE;    

..................................

If there is not  the directory such as cm,mf,qt,co,si,you must create the directory fistly .

4.imp system/manager@ea21sg2t file=e:/oracle/ea21sg2t.dmp log=d:/oracle/ea21sg2t.log full=y grants=y

if there is error,after opening another start/cmd:alter user system identified by manager,try above command again.

caution:if the imp failed, you can try again after removing all table using  truncate table t1; truncate table t2;.If there is a error such as "warning objects were exported by EXP_USER ,not by you :",you can try it again after changing the system/manager to developer/developer.

5.oracle dba studio/storage/tablespaces,change the size according to the percent such as system,temp.