Oracle9i數(shù)據(jù)庫(kù)備份與恢復(fù)(導(dǎo)出導(dǎo)入方式).doc

Oracle9i數(shù)據(jù)庫(kù)的備份和恢復(fù)以下方法是采用數(shù)據(jù)庫(kù)導(dǎo)出備份和導(dǎo)入恢復(fù)來實(shí)現(xiàn)，這樣可以保證備份的數(shù)據(jù)庫(kù)相對(duì)比較小，以下方法適用于Oracle10g的數(shù)據(jù)導(dǎo)入。唯一區(qū)別就是在創(chuàng)建表空間時(shí)有一點(diǎn)不一樣。一、數(shù)據(jù)庫(kù)導(dǎo)出在操作系統(tǒng)桌面-開始-運(yùn)行中輸入cmd在cmd中輸入如下語句進(jìn)行導(dǎo)出備份exp jcuser/anchecydb file=F:user.dmp owner=jcuser如下圖所示，那么數(shù)據(jù)備份導(dǎo)出到F盤，文件為user.dmp二、數(shù)據(jù)庫(kù)恢復(fù)安裝Oralce9i數(shù)據(jù)庫(kù)，數(shù)據(jù)庫(kù)SID為CYDB。剛安裝完畢后，數(shù)據(jù)沒有表空間、也沒有用戶。那么需要用PlSqlDev.exe進(jìn)行表空間和用戶的創(chuàng)建，最后進(jìn)行數(shù)據(jù)導(dǎo)入1. 創(chuàng)建的表空間用PlSqlDev.exe執(zhí)行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. 創(chuàng)建用戶用PlSqlDev.exe執(zhí)行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.數(shù)據(jù)庫(kù)導(dǎo)入在操作系統(tǒng)桌面-開始-運(yùn)行中輸入cmd在cmd中輸入如下語句進(jìn)行導(dǎo)入恢復(fù)imp jcuser/anche fromuser=jcuser touser=jcuser rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=n file=F:user.d