Oracle 数据库备份与恢复专题

Oracle2004-02-043Com1,22ProductnameConfidentialitylevelCAMSProductversionV100Total23pages23Oracle():2004-02-08:::3ComOracle2004-02-043Com2,222004/2/16Oracle2004-02-043Com3,221exp&imp....................................................................41.1exp......................................................................................................41.1.1............................................................................................................41.1.2............................................................................................................51.2Imp......................................................................................................61.2.1............................................................................................................62tar..............................................................................62.1.............................................................................................................................62.2tar.....................................................................................................................62.3tar.................................................................................................................62.3.1............................................................................................................62.3.2............................................................................................................62.4tar.................................................................................................................62.4.1............................................................................................................62.4.2............................................................................................................62.5tar.....................................................................................................................63CAMS.......................................................................................63.1............................................................................................................63.2.........................................................................................................64..............................................................................................................................64.1........................................................................................................64.1.1............................................................................................................64.1.2............................................................................................................64.2CAMS.................................................................................................64.2.1......................................................................................................64.2.2..................................................................................................6Oracle2004-02-043Com4,221exp&imp1.1expexp/impexpimpfull()owner()table()tablespace()full():ORDSYSMDSYSCTXSYSORDPLUGINSLBACSYSowner():tables():()tablespace()expexpexpexpusername/passwordparameter=valueexpusername/passwordparfile=filenameexpexp/impimp1.1.1buffer0Oracle2004-02-043Com5,22file.dmpexpdat.dmpfilesizeexphelpexportinctypecompletecumulativeincrementalloglogshowimpfullYNtablesfromuserimptouserimpcamscams1fromusercamstousercams11.1.21.[oracle@localhostscript]$expExport:Release8.1.7.4.0-ProductiononFriFeb615:01:072004(c)Copyright2000OracleCorporation.Allrightsreserved.Username:cams--Password:--Connectedto:Oracle8iEnterpriseEditionRelease8.1.7.4.0-ProductionJServerRelease8.1.7.4.0-ProductionEnterarrayfetchbuffersize:4096--bufferOracle2004-02-043Com6,22Exportfile:expdat.dmp20040206.dmp--(1)E(ntiredatabase),(2)U(sers),or(3)T(ables):(2)U--Exportgrants(yes/no):yes--yesExporttabledata(yes/no):yes--noyesCompressextents(yes/no):yes--yesExportdoneinZHS16CGB231280charactersetandZHS16CGB231280NCHARcharactersetAbouttoexportspecifiedusers...Usertobeexported:(RETURNtoquit)cams--exp..Usertobeexported:(RETURNtoquit)..--...exportingpre-schemaproceduralobjectsandactions.exportingforeignfunctionlibrarynamesforuserCAMS.exportingobjecttypedefinitionsforuserCAMSAbouttoexportCAMS'sobjects....exportingdatabaselinks.exportingsequencenumbers.exportingclusterdefinitions.abouttoexportCAMS'stablesviaConventionalPath.....exportingtableTBL_BILLDETAIL_SWITCH23rowsexported..exportingtableTBL_BLACKLIST0rowsexported..exportingtableTBL_CHARGE_CARD11rowsexported..exportingtableTBL_ERROR_CODE37rowsexported..exportingtableTBL_EXPORT2rowsexported..exportingtableTBL_LOG3008rowsexported.......exportingsynonyms.exportingviews.exportingstoredprocedures.exportingoperators.exportingreferentialintegrityconstraints.exportingtriggers.exportingindextypes.exportingbitmap,functionalandextensibleindexes.exportingposttablesactions.exportingsnapsho