使用plsqldev对oracle数据库做备份还原操作

1、1：将plsqldev软件复制到安装了oracle数据库的服务器里面，解压，双击plsqldev.exe,打开软件2：输入用户名system，密码*和数据库的database，默认为orcl，点击OK,进入数据库。30K2StartingVersionPL/SQLDeveloperOracleLogonReadingpReadingkLoggingoUsername(systemPassword|Databaseorcl匚cinnectas|Normal|Cancel|3：点击右侧名称为tabales的文件夹，打开所有表。:田：E:3:甲由：由：由：由：由：田：田：E:3:甲由：由：由：由：由

2、：田：田：E.Appliceiticin/Plug-InYourVersion|LsitstVrsiciri|StsitusPLVSQLDeveloper311&Q41514Update-l.lEx|.止.FL/SQLD亡”电1.01电1iEyzt电Eotc1FileProiectEdit.SessionDebugToolsMacroDocumentsReportsWindowHelp-辽-Q肆宅G辛=曲昨名objecbsTablesAQ$_INTEFlNET_AGEhLAQ$_INTERNET_AGENAQ$_QUEIJESAQ$_QUEUE_TAE：LESAQ$_SCHEDU

3、LESDEF$_AQCALLDEF$_AQEFIFIOFIDEF$_CALLDESTDEF$_DEFAULTDESTDEF$_DESTINATIONDEF$_EFIFIOFIDEF$_LIJEIDEF$_OFIIGINDEF$_PFIOFAGATOFIDEF$_PUSHED_TFIANEDEF$_TEMF$LOE：FLOATMXTIMETMF1FLOATVALUETMPHEALTHTMPHELPINTMAXTIMETMFINTVALIJETMP4：往下拉。查看是否有ns开头的表PL/SQLDevelopersysteaorclFileEditSessionToolsMacroDocuments

4、sWindowG孕=牡坷尼1.AllobjectsK-1VIEW$_ADVk-1VIEW$_ADVk-iviewj.advKIVIEWJ.ADVk-1VIEW$_ADVk-iviewj.advPLANTEMPNS101229101229EliTniinnnniiTniinnEninni寻iTninninniinnnniiTniinnnnirrninnEninnifnninnnniNS_101229_101229_FLiNS_101229_101229_INNS_101229_101229_LONS_AE!lLITY_FlESOUFiCNS_ACCESSUSEFlCONfNS_ALi.FlMCO

5、NFIGNS_ALi.FlMSOUNDNS_ALi.FlMSOUNDFILENS_ALi.FlMSOUNDSCHNS_ALi.FlMTIMENS_ALi.FlM_ALi.FlMNS_ALi.FlM_MAILNS_AIRM_NETSENDNS_ALi.FlM_PHONENS_ALi.FlM_SOUNDNS_ALi.FlM_SOUhJDHONS.ANALYSE丄匸IMFIGNS_APPLICATIONNS_APPLICATION_UNINS.AFIEANS_AFIEAINFONS_AFIEAINFOITEMNS_AFIEA_TOPONS_AFIEA_USEFI5：找到后，说明连接的数据库正常，再将

6、鼠标点击一下tables文件夹，再点击上面的tools,再点击exporttables工具。FileFrojectEditSessionDebugTuoleMacroIlociuTientEReports:D-*、Preferences.ConfigureContipireContigure：ContiMacroPlug-Ins.Tools.DocijfTierLt.Reports.PL/SQLDeveloper-systeBorclWiruluwHelpe环=科炸枱.AllobjectsTQueu已tablesLibrariesDirectoriesnnTables:ll-:ll-:s-:l

7、l-:ll-.:0-:宀兰5三-FnlfnTlITTTlfnTlITTTlrnTInTTlrnTInTTlnnlnTTlnnlnTlnnlnTlnnlfnTlITnlfnTlITTTln-BHnHWHURAHAAOcomsumRMHBRRH-HOHSHQPHHSHCSHOWfnllsRnnsmmBITn1rTITIrTP1rTITIITP1rTITIBTP1ITITIITP1ITITIrTP1rTP1rTP1rTP1rTP1rTP1TP1rTP1rTITIBTn1TITIBTP1BAQ$_INTEFINET_AGENAQ$_INTERNET_AGENAQ$_QUELIESaq：lqueueAQ

8、$_SCHEDULESDEF$_AQLALLdef$_aqef;fiof;DEF$_LALLDESTDEF$_DEFAULTDESTDEF$_DESTINATIUNDEF$_EF；F；OF；DEF$_LOBDEF$_UF；IGINDEFiLPRUFAGATORDEFiLFUSHEClTFIANEDEF$_TEMP$LOBFLUATklTIblETklF1FLUATVALUETMF1HEALTHTMF1HELF1INTMARTINIETIvlF1INTVALUETMF1BrowserBrowserFolders.BrowserFilters.TemplateLitWindowListToolb：

9、=Lt-ExjilainFlanCodeAssistantCodeContEnt.弓ShowCompilerHintsyueryBuilder.FindRntabaseObjects.CompileInvalidObjects.ExportUserObjects.Corrip：=LfeUserObjects.丘空址Mcmitor.Sessions.TestRtiTLager.ExjiortTables.ImportTables.Comp：tHTablela.ta.TextImpor.6：弹出需要选择导出的数据库名称窗口，在这里，选择需要导出的数据名称，即所有以ns开头的文件。疔FL/SQLDe

10、veloper-sysfeasorclT-ln|x|.11objectsE-E-S-E-E-E-S-.QueuetablesLibraries-DirectoriesTablesaq$_intef;net_agenAQ$_INTEF1NET_AGENAQ$_QUELIESAQ$_QUEUE_TABLESAQ$_SCHEDIJLESDEF$_AQLALLDEF$_AQERFIURDEF$_CALLDESTDEF$_DEFAULTDESTDEF$_DESTINATIUNDEF$_EF；F；OF；DEF$_LOBDEF$_ORIGINDEF社PF；匚IF也GAT匚IF；DEF$_PIJSHED_TF

11、IANEdef$_temp$lobFLOATM.iXTIMETMF1FLOATVALUETMF1HEALTHTMF1ITTTlInnllnTTlITTTlITTnFnTlInnlrfTnlnTTlITTnlrnTlInnllwTTTlInTIITTTlInnllnTnlTTTl-rnnrTnirnnTmrnnrnnrTrnrnTiTmrnnrnnrTrnTmTmTmrnnTnirnTiTmiNameTypejJNS_UNITINDICATORNS_UNIT_UNITNS_UPSNS_USERNS_USER_ROLENSVIDEODEVICEffiOL$亟OLSNODESTbiOLSHINTSO

12、racleExportjSQLInsertsPL/SQLDeveloper两Compress厂Consistent两Constraints厂DirectTABL善TABLEgTABLETABLETABLEtaeleJI|7GrantsSuffersize(KB)RIndexes4図丽口厂iiAjtWhereclauseTicici駅1E*potEhbquI：日bl已|D:旧匚怎Ipwch匚t11.2忖北G7：点击Outputfile后面的文件夹图标，选择导出的路径。注意，文件名必须是要dmp格式的，再点击保存。FL/SQLDeveloper-systeaSorclFilsFrojactgdit

13、SessionDebugToolsMacroDocumentEReporWindowHelp:D；3為著龜為气H夢車启囲肆e*=m1XI.llobjects|已|已table$LibrariesDiredoriesTables另存为保存在11):I窗桌面III+我最近的文档El-由El-;s-;由ITnlrTWITTT1ITTT1ITWrnTnmrnlrTnrnrnnw=-=-ITTTlw-gWITTnnTr_HTIITn1ITn1ITrnlTn1ITn1ITn1ITn1HTIITn1ITn1ITn1ITn1ITn1ITn1ITn1ITrnlTn1ITn1一aq$_intef;net_agen

14、aq$_intef;net_agenAQ$_QLIELIESAQ$_QUEIJE_TAEILESAQ$_SCHEDIJLESdef$_aqcalldef$_aqerrurdef$_calldestdef$_defaultdestDEF$_DESTINATIONDEF$_EFIFIOFIDEF$_LOBDEF$_OFIIGINDEFiLPFIOFAGATOFIDEFJ.PUSHEDDEF$_TEMP$LOE：FLUATMAXTIMETMF1FLUATVALIJEIMPHEALTHTMF1桌面我的文档Ar我的电脑网上邻居El我的文档寸我的电脑首网上邻居EjS.2.2ITMaSter5.2.l_bu

15、ildl0034)oracle连接工具jplsqldevnetrn:m三ter50.liinp_20100825保存(S)保存类型IT):IEsportfile取消8：点击后面的Export按钮，导出选择的所有表格，导出后，将在选择的路径里面查看到一个新的文件。名称犬小类型1修改日期1属性1我的文档垂统文件夹乂我的电脑丟统文件夹勺网上邻居丢统文件夹回回收站垂统文件夹.耳工nternetExplorer丟统文件夹巒安全配置向导2KB快捷方式2010-9-212:38AITMaster1KB快捷方式2010-11-116:24AjNavicatLiteforMySQL1KB快捷方式2010-11-

16、2413:51AE至NavicatLitmfurUracle1KB快捷方式2010-12-2712:49AjITMasterS.2.l_buildl0034_20100825文件夹2010-9-1911:04Joracle连接工具文件夹2010-12-2712:49jS.2.2文件夹2010-12-2823:00iplsqldev文件夹2011-1-610:08金ipsJlHv2.71KB快捷方式2010-9-915:14AE快捷方式到RUN_NSTRONGXU.bat1KB快捷方式2010-9-2815:52A磐c-racl已连接工具.zip14,075KBWinEARZIF压缩.2010-

17、12-2710:11A画netmaster50.limp4,164KBDMF文件2010-12-2819:54A_j泾uthenticztidtl.nac1KBNAC文件2010-12-290:28AplEqldev.rar3,860KBWinRAR压缩文件2010-12-2910:48Ajlbeifen.ilnp奏議蟹綾療蠶鹽邀巒鶴1,826KBDMF文件2011-1-610:25A9：当需要还原的时候，将在第5步的时候选择Importtables即可。10：点击后，弹出窗口，点击Importfile后面的文件夹图标，选择备份的文件。三PL/SQLDeveloper一syEteaSorclF

18、ileFrojectEditSessionDebugTools也aeroDociainen.ReporjVinduwHelp-：KaTaportTables-|nlx|.AllobjectsOracleImport|SQLInserts|PL/SQLDeveldper|IIIS-S-S-s-s-s-s-s-s-s-s-s-Queu已tabIesLibrariesDirectoriesTablesaq$_intefinet_agenaq$_intefinet_agenaq$_QueuesAQ$_QUEUE_TABLESAQ$_SCHEDULESDEF$_AQLALLDEF$_AQEFIROF1D

19、EF$_LALLDESTDEF$_DEFAULTDESTDEF$_DESTINATIUNDEF$_ERRUF1DEF$_LOE1ITTTlrTTTlITTTlITTTlITTTlInTTlITTTlITnlrTnlg三兰-昌一rTTnrTTnrTTnrTTnInIrTTnrTTnrTTTIrTTTIrTTTIrTTTIrTW疋AnalyzelCommit帀Constraints两Grants片Ignore疋Indexes两Rows厂ShowBuffersize(KE：j|30gFromUser|二|ToUser|三|ImportExecutable|D:t口日匚：l已匚：lA11.2【p|Importfile11：选择后，点击后面的Import图标，完成还原。疔FL/SQLDeveloper-sys