linux下对oracle备份

红太狼 2022-08-13 19:35 431阅读 0赞

如题，在linux上装了数据库oracle，需要对数据进行备份。

这个命令其实网上很多，这里就说说怎么打linux命令。

  1. 登陆linux后，进入oracle的安装目录下，找到bin那个目录，进入bin目录。
  2. 我们可以先看一看这些命令的所有者：
  3. ls -l
  5. [root@callcenter bin]# 
  6. [root@callcenter bin]# 
  7. [root@callcenter bin]# pwd
  8. /oracle/product/10.2.0/db_1/bin
  9. [root@callcenter bin]# 
  10. [root@callcenter bin]# 
  11. [root@callcenter bin]# 
  12. [root@callcenter bin]# ls -l
  13. total 215932
  14. -rwxr-xr-x. 1 oracle oinstall     13093 Oct 20  2005 adapters
  15. -rwxr-xr-x. 1 oracle oinstall      1891 Aug  9  2005 agentok.sh
  16. -rwxr-x--x. 1 oracle oinstall     95620 Aug 22 17:23 agtctl
  17. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 agtctlO
  18. -rwxr-x--x. 1 oracle oinstall      1542 Aug 22 17:16 aqxmlctl
  19. -rw-r-----. 1 oracle oinstall      1542 Aug 22 17:07 aqxmlctl.ouibak
  20. -rw-r--r--. 1 oracle oinstall      6768 Nov  4  2004 aqxmlctl.pl
  21. -rwxr-xr-x. 1 oracle oinstall      3099 Apr  5  2005 asmcmd
  22. -rwxr-xr-x. 1 oracle oinstall    214856 May 21  2005 asmcmdcore
  23. -rwxr-xr-x. 1 oracle oinstall      2434 Aug 22 17:16 bndlchk
  24. -rwxr-x---. 1 oracle oinstall     63821 Mar 11  2008 cfo
  25. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 clscfg
  26. -rwxr-xr-x. 1 oracle oinstall    716197 Mar  1  2008 clscfg.bin
  27. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 clsfmt
  28. -rwxr-xr-x. 1 oracle oinstall    701777 Mar  1  2008 clsfmt.bin
  29. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 clsid
  30. -rwxr-xr-x. 1 oracle oinstall    627625 Mar  1  2008 clsid.bin
  31. -rwxr-xr-x. 1 oracle oinstall       736 Aug 22 17:17 cluvfy
  32. -rwxr-xr-x. 1 oracle oinstall       531 Aug 22 17:23 commonenv
  33. -rw-r--r--. 1 oracle oinstall        82 Oct 15  2004 commonenv.bat.template
  34. -rwxr-xr-x. 1 oracle oinstall       399 Aug 22 17:14 commonenv.ouibak
  35. -rwxr-xr-x. 1 oracle oinstall       504 Mar 30  2007 commonenv.template
  36. -rwxr-xr-x. 1 oracle oinstall      2854 Jan  1  2000 coraenv
  37. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 crsctl
  38. -rwxr-xr-x. 1 oracle oinstall   3493325 Mar  1  2008 crsctl.bin
  39. -rwxr-xr-x. 1 oracle oinstall    368942 Feb  6  2008 csscan
  40. -rwxr-xr-x. 1 oracle oinstall         0 Jun 22  2005 csscanO
  41. -rwxr-xr-x. 1 oracle oinstall    570816 Feb  5  2008 ctxkbtc
  42. -rwxr-x--x. 1 oracle oinstall    480275 Aug 22 17:22 ctxlc
  43. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 ctxlcO
  44. -rwxr-x--x. 1 oracle oinstall    226112 Aug 22 17:22 ctxload
  45. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 ctxloadO
  46. -rwxr-x--x. 1 oracle oinstall     33359 Aug 22 17:23 cursize
  47. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 cursizeO
  48. -rwxr-xr-x. 1 oracle oinstall      5595 Aug 22 17:23 dbca
  49. -rwxr-xr-x. 1 oracle oinstall      5361 Aug 22 17:14 dbca.ouibak
  50. -rwxr-xr-x. 1 oracle oinstall     11160 Oct 13  2004 DBConsole.pm
  51. -rwxr-x--x. 1 oracle oinstall     13237 Aug 22 17:23 dbfsize
  52. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 dbfsizeO
  53. -rwxr-xr-x. 1 oracle oinstall      2417 Jan  1  2000 dbhome
  54. -rwxr-x---. 1 oracle oinstall      6582 Jan  1  2000 dbshut
  55. -rwxr-x---. 1 oracle oinstall     14088 Jan  1  2000 dbstart
  56. -rwxr-xr-x. 1 oracle oinstall      7232 Aug 22 17:17 dbua
  57. -rwxr-xr-x. 1 oracle oinstall      6000 Aug 22 17:07 dbua.ouibak
  58. -rwxr-x--x. 1 oracle oinstall    383311 Aug 22 17:23 dbv
  59. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 dbvO
  60. -rwxr-xr-x. 1 oracle oinstall      1348 Aug 22 17:17 deploync
  61. -rwxr-xr-x. 1 oracle oinstall      1348 Aug 22 17:07 deploync.ouibak
  62. -rwxr-x--x. 1 oracle oinstall   2284665 Aug 22 17:23 dgmgrl
  63. -rwxr-x--x. 1 oracle oinstall   2284665 Aug 22 17:20 dgmgrlO
  64. -rwxr-xr-x. 1 oracle oinstall      1201 Aug 22 17:17 dropjava
  65. -rwxr-xr-x. 1 oracle oinstall       504 Aug 22 17:07 dropjava.ouibak
  66. -rwxr-x---. 1 oracle oinstall    762975 Aug 22 17:23 dsml2ldif
  67. -rwxr-x--x. 1 oracle oinstall    314923 Aug 22 17:23 dumpsga
  68. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 dumpsga0
  69. -rwxr-x---. 1 oracle oinstall   2253608 Aug 22 17:20 e2eme
  70. -rwxr-xr-x. 1 oracle oinstall         0 May 19  2004 e2eme0
  71. -rwxr-xr-x. 1 oracle oinstall       153 Jun 13  2005 echodo
  72. -rwx------. 1 oracle oinstall     67275 Aug 22 17:20 emagent
  73. -rwxr-xr-x. 1 oracle oinstall         0 May 19  2004 emagent0
  74. -rwxr-xr-x. 1 oracle oinstall      3766 Aug 22 17:23 emagentdeploy.pl
  75. -rwxr-xr-x. 1 oracle oinstall     19227 Nov 19  2006 EMAgent.pm
  76. -rwxr-x---. 1 oracle oinstall     80358 Aug 22 17:20 emagtm
  77. -rwxr-xr-x. 1 oracle oinstall     80279 Feb 29  2008 emagtm0
  78. -rwxr-xr-x. 1 oracle oinstall      1714 Aug 22 17:23 emca
  79. -rwxr--r--. 1 oracle oinstall     12407 Aug 22 17:23 emctl
  80. -rwxr-xr-x. 1 oracle oinstall     30831 Aug 22 17:23 EmctlCommon.pm
  81. -rwxr-xr-x. 1 oracle oinstall     28704 Aug 22 17:14 EmctlCommon.pm.ouibak
  82. -rwxr--r--. 1 oracle oinstall     12086 Aug 22 17:14 emctl.ouibak
  83. -rwxr-xr-x. 1 oracle oinstall     89929 Aug 22 17:23 emctl.pl
  84. -rwxr-xr-x. 1 oracle oinstall     85908 Aug 22 17:14 emctl.pl.ouibak
  85. -rwxr-xr-x. 1 oracle oinstall     12432 Jul 20  2006 emctl.template
  86. -rwx------. 1 oracle oinstall    119862 Aug 22 17:20 emdctl
  87. -rwxr-xr-x. 1 oracle oinstall         0 May 19  2004 emdctl0
  88. -rwxr-xr-x. 1 oracle oinstall     21942 Aug 11  2005 EMDeploy.pm
  89. -rwxr-xr-x. 1 oracle oinstall      1226 Jan 12  2004 emdfail.command
  90. -rwxr-xr-x. 1 oracle oinstall      3944 May 12  2005 emdlctl.template
  91. -rwxr-xr-x. 1 oracle oinstall      3449 May 12  2005 emdrollogs.pl
  92. -rwxr-xr-x. 1 oracle oinstall       767 Jan 12  2004 emlfail.command
  93. -rwxr-xr-x. 1 oracle oinstall      2802 May 12  2005 emrepdown.pl
  94. -rwxr-xr-x. 1 oracle oinstall      1693 Jan 12  2004 emrepdown.sh
  95. -rwxr-xr-x. 1 oracle oinstall      1192 Aug 22 17:23 emtgtctl
  96. -rwsr-s--x. 1 oracle oinstall     96786 Aug 22 17:20 emtgtctl2
  97. -rwxr-xr-x. 1 oracle oinstall         0 May 12  2005 emtgtctl20
  98. -rwxr-xr-x. 1 oracle oinstall       889 Aug 22 17:14 emtgtctl.ouibak
  99. -rwxr-xr-x. 1 oracle oinstall      1146 May  9  2007 emtgtctl.template
  100. -rwxr-xr-x. 1 oracle oinstall      8730 Aug 22 17:23 emutil
  101. -rwxr-xr-x. 1 oracle oinstall      8730 Aug 22 17:14 emutil.ouibak
  102. -rwxr-xr-x. 1 oracle oinstall     25232 Jan 12  2004 emwd
  103. -rwxr-xr-x. 1 oracle oinstall     54634 Apr 24  2007 emwd.pl
  104. -rwxr-x--x. 1 oracle oinstall    713618 Aug 22 17:20 exp
  105. -rwxr-x--x. 1 oracle oinstall    200603 Aug 22 17:20 expdp
  106. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 expdpO
  107. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 expO
  108. -rwsr-x---. 1 root   oinstall     58520 Aug 22 17:23 extjob
  109. -rwx------. 1 oracle oinstall     58520 Aug 22 17:23 extjobo
  110. -rwxr-xr-x. 1 oracle oinstall     59988 Mar 11  2008 extjobO
  111. -rwxr-xr-x. 1 oracle oinstall     59988 Mar 11  2008 extjoboO
  112. -rwxr-x--x. 1 oracle oinstall     63679 Aug 22 17:23 extproc
  113. -rwxr-x--x. 1 oracle oinstall     69653 Aug 22 17:23 extproc32
  114. -rw-r--r--. 1 oracle oinstall     30121 Mar 11  2008 extproc32O
  115. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 extprocO
  116. -rwxr-xr-x. 1 oracle oinstall       315 Aug 22 17:07 extusrupgrade
  117. -rwxr-xr-x. 1 oracle oinstall      2950 Aug 22 17:23 fix_4525303.pl
  118. -rwxr-x---. 1 oracle oinstall    656290 Mar 11  2008 fmputl
  119. -rwxr-x---. 1 oracle oinstall     12309 Mar 11  2008 fmputlhp
  120. -rwxr-xr-x. 1 oracle oinstall      4865 Sep 23  2005 genagtsh
  121. -rwxr-xr-x. 1 oracle oinstall      9668 Sep 26  2005 genclntsh
  122. -rwxr-xr-x. 1 oracle oinstall      5146 Jun 23  2005 genclntst
  123. -rwxr-x--x. 1 oracle oinstall     66218 Aug 22 17:20 genezi
  124. -rwxr-xr-x. 1 oracle oinstall     67542 Mar 11  2008 geneziO
  125. -rwxr-xr-x. 1 oracle oinstall    856381 Mar 11  2008 genksms
  126. -rwxr-xr-x. 1 oracle oinstall      2893 Oct 20  2005 gennfgt
  127. -rwxr-xr-x. 1 oracle oinstall      4902 Mar  2  2008 gennttab
  128. -rwxr-xr-x. 1 oracle oinstall      3528 Feb 20  2007 genoccish
  129. -rwxr-xr-x. 1 oracle oinstall      9590 Feb  6  2008 genorasdksh
  130. -rwxr-xr-x. 1 oracle oinstall      2318 Jan  1  2000 gensyslib
  131. -rwxr-xr-x. 1 oracle oinstall         0 Oct 22  2005 grdcscan
  132. -rwxr-xr-x. 1 oracle oinstall    723078 Mar  1  2008 gsd
  133. -rwxr-xr-x. 1 oracle oinstall      4773 Aug 22 17:17 gsdctl
  134. -rwxr-xr-x. 1 oracle oinstall      4930 Aug 22 17:17 gsd.sh
  135. -rwxr-xr-x. 1 oracle oinstall      2134 Feb 16  2003 helpins
  136. -rwxr-x--x. 1 oracle oinstall    184801 Aug 22 17:23 hsalloci
  137. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 hsallociO
  138. -rwxr-x--x. 1 oracle oinstall     72973 Aug 22 17:23 hsdepxa
  139. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 hsdepxaO
  140. -rwxr-x--x. 1 oracle oinstall   1702229 Aug 22 17:23 hsodbc
  141. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 hsodbcO
  142. -rwxr-x--x. 1 oracle oinstall     71669 Aug 22 17:23 hsots
  143. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 hsotsO
  144. -rwxr-xr-x. 1 oracle oinstall     15719 Apr 17  2007 IASConsole.pm
  145. -rwxr-x--x. 1 oracle oinstall    356498 Aug 22 17:20 imp
  146. -rwxr-x--x. 1 oracle oinstall    205618 Aug 22 17:20 impdp
  147. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 impdpO
  148. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 impO
  149. -rwxr-xr-x. 1 oracle oinstall      3247 Aug 22 17:07 isqlplusctl
  150. -rwxr-xr-x. 1 oracle oinstall     11083 Aug 22 17:17 isqlplusctl.pl
  151. -rwxr-xr-x. 1 oracle oinstall     10904 Aug 22 17:07 isqlplusctl.pl.ouibak
  152. -rwxr-x--x. 1 oracle oinstall   8130798 Aug 22 17:23 kfod
  153. -rwxr-xr-x. 1 oracle oinstall         0 Jun 22  2005 kfod0
  154. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 kfodO
  155. -rwxr-x--x. 1 oracle oinstall    434320 Aug 22 17:23 kgmgr
  156. -rwxr-x--x. 1 oracle oinstall    434320 Aug 22 17:20 kgmgrO
  157. -rwxr-xr-x. 1 oracle oinstall   3758285 Mar 11  2008 kgpmon
  158. lrwxrwxrwx. 1 oracle oinstall        49 Aug 22 17:07 lbuilder -> /oracle/product/10.2.0/db_1/nls/lbuilder/lbuilder
  159. -rwxr-xr-x. 1 oracle oinstall   1079375 Feb  7  2008 lcsscan
  160. -rwxr-x---. 1 oracle oinstall    779813 Aug 22 17:23 ldapadd
  161. -rwxr-x---. 1 oracle oinstall    793136 Aug 22 17:23 ldapaddmt
  162. -rwxr-x---. 1 oracle oinstall    707413 Aug 22 17:23 ldapbind
  163. -rwxr-x---. 1 oracle oinstall    707343 Aug 22 17:23 ldapcompare
  164. -rwxr-x---. 1 oracle oinstall    707390 Aug 22 17:23 ldapdelete
  165. -rwxr-x---. 1 oracle oinstall    707170 Aug 22 17:23 ldapmoddn
  166. -rwxr-x---. 1 oracle oinstall    779813 Aug 22 17:23 ldapmodify
  167. -rwxr-x---. 1 oracle oinstall    793136 Aug 22 17:23 ldapmodifymt
  168. -rwxr-x---. 1 oracle oinstall    728995 Aug 22 17:23 ldapsearch
  169. -rwxr-xr-x. 1 oracle oinstall      1867 Aug 22 17:07 ldifmigrator
  170. -rwxr-xr-x. 1 oracle oinstall      1176 Jun 13  2005 linkshlib
  171. -rwxr-xr-x. 1 oracle oinstall    890211 Feb  7  2008 lmsgen
  172. -rwxr-xr-x. 1 oracle oinstall      1437 Aug 22 17:17 loadjava
  173. -rwxr-xr-x. 1 oracle oinstall       545 Aug 22 17:07 loadjava.ouibak
  174. -rwxr-x--x. 1 oracle oinstall     30029 Aug 22 17:23 loadpsp
  175. -rwxr-x--x. 1 oracle oinstall     30029 Aug 22 17:20 loadpspO
  176. -rwxr-xr-x. 1 oracle oinstall     22589 Aug 22 17:17 localconfig
  177. -rwxr-x--x. 1 oracle oinstall    102917 Aug 22 17:22 lsnrctl
  178. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 lsnrctl0
  179. -rwxr-xr-x. 1 oracle oinstall    544765 Feb  7  2008 lxchknlb
  180. -rwxr-xr-x. 1 oracle oinstall    934744 Feb  7  2008 lxegen
  181. -rwxr-xr-x. 1 oracle oinstall   2656925 Feb  7  2008 lxinst
  182. -rwxr-xr-x. 1 oracle oinstall       485 Aug  4  2006 makerootca.sh
  183. -rwxr-xr-x. 1 oracle oinstall       485 Aug  4  2006 makeserverwlt
  184. -rwxr-x--x. 1 oracle oinstall    315164 Aug 22 17:23 mapsga
  185. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 mapsga0
  186. -rwxr-x--x. 1 oracle oinstall     12995 Aug 22 17:23 maxmem
  187. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 maxmemO
  188. -rwxr-xr-x. 1 oracle oinstall      2214 Aug 22 17:17 mkstore
  189. -rwxr-xr-x. 1 oracle oinstall      2214 Aug 22 17:07 mkstore.ouibak
  190. -rwxr-xr-x. 1 oracle oinstall    188719 Mar  2  2008 mkwallet
  191. -rwxr-xr-x. 1 oracle oinstall      1347 Aug 22 17:17 ncomp
  192. -rwxr-xr-x. 1 oracle oinstall      1347 Aug 22 17:07 ncomp.ouibak
  193. -rwxr-xr-x. 1 oracle oinstall      6400 Aug 22 17:17 netca
  194. -rwxr-xr-x. 1 oracle oinstall       102 Aug 22 17:17 netca_deinst.sh
  195. -rwxr-xr-x. 1 oracle oinstall         0 Aug 31  2005 netca_inst.sh
  196. -rwxr-xr-x. 1 oracle oinstall      6401 Aug 22 17:07 netca.ouibak
  197. -rwxr-xr-x. 1 oracle oinstall      6212 Aug 22 17:17 netmgr
  198. -rwxr-xr-x. 1 oracle oinstall      6213 Aug 22 17:07 netmgr.ouibak
  199. -rwxr-x--x. 1 oracle oinstall    159582 Aug 22 17:23 nid
  200. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 nidO
  201. -rwsr-s---. 1 root   oinstall     18196 Aug 22 17:11 nmb
  202. -rwxr-xr-x. 1 oracle oinstall         0 Oct 22  2005 nmb0
  203. -rwxr-xr-x. 1 oracle oinstall     43626 Feb 29  2008 nmcbufp
  204. -rwxr-x---. 1 oracle oinstall    929164 Aug 22 17:20 nmccollector
  205. -rwxr-xr-x. 1 oracle oinstall    921293 Feb 29  2008 nmccollector0
  206. -rwxr-x---. 1 oracle oinstall    100103 Aug 22 17:20 nmei
  207. -rwxr-xr-x. 1 oracle oinstall         0 May 19  2004 nmei0
  208. -rwsr-s---. 1 root   oinstall     16212 Aug 22 17:11 nmo
  209. -rwxr-xr-x. 1 oracle oinstall         0 Oct 22  2005 nmo0
  210. -rwxr-x---. 1 oracle oinstall     71668 Aug 22 17:20 nmocat
  211. -rwxr-xr-x. 1 oracle oinstall         0 May 19  2004 nmocat0
  212. -rwxr-xr-x. 1 oracle oinstall    365371 Feb 29  2008 nmuct
  213. -rwxr-x---. 1 oracle oinstall     74772 Aug 22 17:20 nmupm
  214. -rwxr-xr-x. 1 oracle oinstall         0 May 19  2004 nmupm0
  215. -rwxr-x---. 1 oracle oinstall     76837 Aug 22 17:20 nmus
  216. -rwxr-xr-x. 1 oracle oinstall         0 May 19  2004 nmus0
  217. -rwxr-xr-x. 1 oracle oinstall      1684 Aug 22 17:07 oclsmon
  218. -rwxr-xr-x. 1 oracle oinstall    629312 Oct 20  2005 oclsmon.bin
  219. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 oclsomon
  220. -rwxr-xr-x. 1 oracle oinstall    640405 Mar  1  2008 oclsomon.bin
  221. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 oclsvmon
  222. -rwxr-xr-x. 1 oracle oinstall    645572 Mar  1  2008 oclsvmon.bin
  223. -rwxr-x---. 1 oracle oinstall    628942 Aug 22 17:23 ocrcheck
  224. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 ocrcheck0
  225. -rwxr-xr-x. 1 oracle oinstall    640002 Mar  1  2008 ocrcheck.bin
  226. -rwxr-x---. 1 oracle oinstall    703131 Aug 22 17:23 ocrconfig
  227. -rwxr-xr-x. 1 oracle oinstall       568 Aug 22 17:17 ocrconfig0
  228. -rwxr-xr-x. 1 oracle oinstall    714871 Mar  1  2008 ocrconfig.bin
  229. -rwxr-x---. 1 oracle oinstall    658610 Aug 22 17:23 ocrdump
  230. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 ocrdump0
  231. -rwxr-xr-x. 1 oracle oinstall    670182 Mar  1  2008 ocrdump.bin
  232. -rwxr-xr-x. 1 oracle oinstall      2268 Aug 22 17:17 ocssd
  233. -rwxr-xr-x. 1 oracle oinstall   1482620 Mar  1  2008 ocssd.bin
  234. -rwxr-xr-x. 1 oracle oinstall       989 Aug 22 17:07 odisrvreg
  235. -rwxr-xr-x. 1 oracle oinstall      2365 Jan  1  2000 oerr
  236. -rwxr-xr-x. 1 oracle oinstall      2008 Aug 22 17:07 oidadmin
  237. -rwxr-xr-x. 1 oracle oinstall      2152 Aug 22 17:07 oidca
  238. -rwxr-xr-x. 1 oracle oinstall      2142 Aug 22 17:16 oidprovtool
  239. -rwxr-xr-x. 1 oracle oinstall      2142 Aug 22 17:07 oidprovtool.ouibak
  240. -rwxr-x---. 1 oracle oinstall    983155 Aug 22 17:23 oifcfg
  241. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 oifcfg0
  242. -rwxr-xr-x. 1 oracle oinstall      1489 Aug 22 17:17 ojvmjava
  243. -rwxr-xr-x. 1 oracle oinstall       500 Aug 22 17:07 ojvmjava.ouibak
  244. -rwxr-x---. 1 oracle oinstall      9806 Aug 22 17:22 okdstry
  245. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 okdstry0
  246. -rwxr-x---. 1 oracle oinstall      7456 Aug 22 17:22 okinit
  247. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 okinit0
  248. -rwxr-x---. 1 oracle oinstall     13059 Aug 22 17:22 oklist
  249. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 oklist0
  250. -rwxr-xr-x. 1 oracle oinstall      1166 Aug 22 17:07 olsadmintool
  251. -rwxr-xr-x. 1 oracle oinstall      1196 Aug 22 17:07 olsoidsync
  252. -rwx------. 1 oracle oinstall      3334 Aug 22 17:23 onsctl
  253. -rwxr-xr-x. 1 oracle oinstall        46 Nov  7  2000 oracg
  254. -rwsr-s--x. 1 oracle oinstall 112468034 Aug 22 17:20 oracle
  255. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 oracleO
  256. -r-sr-s---. 1 root   oinstall     14931 Mar 11  2008 oradism
  257. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 oradismO
  258. -rwxr-xr-x. 1 oracle oinstall      2947 Jan  1  2000 oraenv
  259. -rwxr-xr-x. 1 oracle oinstall        44 Dec  4  2002 orajaxb
  260. -rwxr-xr-x. 1 oracle oinstall        59 Nov 25  2002 orapipe
  261. -rwxr-xr-x. 1 oracle oinstall      3176 Aug 22 17:17 orapki
  262. -rwxr-xr-x. 1 oracle oinstall      3176 Aug 22 17:07 orapki.ouibak
  263. -rwxr-x--x. 1 oracle oinstall     21758 Aug 22 17:23 orapwd
  264. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 orapwdO
  265. -rwxr-xr-x. 1 oracle oinstall   1816142 Feb 29  2008 oratclsh
  266. -rwxr-xr-x. 1 oracle oinstall        48 Sep 25  2000 oraxml
  267. -rwxr-xr-x. 1 oracle oinstall        48 Sep 25  2000 oraxsl
  268. -rwxr-x---. 1 oracle oinstall      7077 Aug 22 17:23 osdbagrp
  269. -rwxr-x---. 1 oracle oinstall      7077 Aug 22 17:23 osdbagrp0
  270. -rwxr-x---. 1 oracle oinstall     10500 Mar 11  2008 osh
  271. -rwxr-xr-x. 1 oracle oinstall       917 Aug 22 17:17 ott
  272. -rwxr-xr-x. 1 oracle oinstall      5396 Aug 22 17:17 owm
  273. -rwxr-xr-x. 1 oracle oinstall      5396 Aug 22 17:07 owm.ouibak
  274. -rwxr-xr-x. 1 oracle oinstall   7485806 Aug 22 17:20 proc
  275. -rw-r--r--. 1 oracle oinstall      1108 May 23  2005 processDef.pl
  276. -rwxr-xr-x. 1 oracle oinstall       691 Oct 22  2005 proxyserv
  277. -rwxr-xr-x. 1 oracle oinstall     53117 Oct 16  2005 proxyserv.bin
  278. -rwxr-xr-x. 1 oracle oinstall      1748 Feb 16  2003 pupbld
  279. -rwxr-x--x. 1 oracle oinstall   1105129 Aug 22 17:23 racgeut
  280. -rwxr-xr-x. 1 oracle oinstall   1109589 Mar  1  2008 racgeutO
  281. -rwxr-x--x. 1 oracle oinstall   1260548 Aug 22 17:23 racgimon
  282. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 racgimonO
  283. -rwxr-x--x. 1 oracle oinstall   1242814 Aug 22 17:23 racgmain
  284. -rwxr-xr-x. 1 oracle oinstall   1245738 Mar  1  2008 racgmainO
  285. -rwxr-x--x. 1 oracle oinstall   1151295 Aug 22 17:23 racgmdb
  286. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 racgmdbO
  287. -rwxr-xr-x. 1 oracle oinstall         0 Aug 22 17:07 racgons
  288. -rwxr-x--x. 1 oracle oinstall      1828 Aug 22 17:17 racgwrap
  289. -rwxr-x--x. 1 oracle oinstall      1333 Aug 22 17:07 racgwrap.ouibak
  290. -rwxr-xr-x. 1 oracle oinstall      1814 Aug  1  2007 racgwrap.sbs
  291. -rwxr-xr-x. 1 oracle oinstall    129870 Mar  1  2008 rawutl
  292. -rwxr-xr-x. 1 oracle oinstall      5337 Aug 22 17:17 rconfig
  293. -rwxr-xr-x. 1 oracle oinstall      5337 Aug 22 17:07 rconfig.ouibak
  294. -rwxr-xr-x. 1 oracle oinstall      8579 Nov 28  2007 relink
  295. -rwxr-xr-x. 1 oracle oinstall      6119 Aug 22 17:23 repo_mig
  296. -rwxr-xr-x. 1 oracle oinstall      6119 Aug 22 17:14 repo_mig.ouibak
  297. -rwxr-xr-x. 1 oracle oinstall      5959 Sep 25  2004 repo_mig.template
  298. -rwxr-x--x. 1 oracle oinstall  12712969 Aug 22 17:20 rman
  299. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 rmanO
  300. -rwxr-xr-x. 1 oracle oinstall      1668 Jan 12  2004 runclass
  301. -rwxr-xr-x. 1 oracle oinstall      2175 Aug 26  2005 sAgentUtils.pm
  302. -rwxr-x--x. 1 oracle oinstall    125172 Aug 22 17:23 sbttest
  303. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 sbttestO
  304. -rwxr-xr-x. 1 oracle oinstall   1608096 Feb  5  2008 schema
  305. -rwxr-xr-x. 1 oracle oinstall       932 Aug 22 17:07 schemasync
  306. -rwxr-x--x. 1 oracle oinstall    734505 Aug 22 17:20 sqlldr
  307. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 sqlldrO
  308. -rwxr-x--x. 1 oracle oinstall      7169 Aug 22 17:23 sqlplus
  309. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 sqlplusO
  310. -rwxr-xr-x. 1 oracle oinstall      4547 Aug 22 17:17 srvconfig
  311. -rwxr-xr-x. 1 oracle oinstall      6226 Aug 22 17:17 srvctl
  312. -rwxr-xr-x. 1 oracle oinstall     12962 Mar  1  2008 srvmspawn
  313. -rwxr-xr-x. 1 oracle oinstall       474 Aug 22 17:23 sslsetup
  314. -rwxr-xr-x. 1 oracle oinstall     34679 Aug 22 17:14 sslsetup.ouibak
  315. -rwxr-xr-x. 1 oracle oinstall      1347 Aug 22 17:17 statusnc
  316. -rwxr-xr-x. 1 oracle oinstall      1347 Aug 22 17:07 statusnc.ouibak
  317. -rwxr-xr-x. 1 oracle oinstall      3261 Jun  7  2005 symfind
  318. -rwxr-xr-x. 1 oracle oinstall     22443 Mar 11  2008 sysresv
  319. -rwxr-xr-x. 1 oracle oinstall      3488 Aug 22 17:23 targetdeploy.pl
  320. -rwxr-x--x. 1 oracle oinstall     62774 Aug 22 17:20 tg4pwd
  321. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 tg4pwdO
  322. -rwxr-x--x. 1 oracle oinstall    138165 Aug 22 17:20 tkprof
  323. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 tkprofO
  324. -rwxr-xr-x. 1 oracle oinstall         0 Oct 22  2005 tnnfg.dbl
  325. -rwxr-x--x. 1 oracle oinstall    443502 Aug 22 17:22 tnslsnr
  326. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 tnslsnr0
  327. -rwxr-x--x. 1 oracle oinstall     13445 Aug 22 17:22 tnsping
  328. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 tnsping0
  329. -rwxr-xr-x. 1 oracle oinstall        45 Sep 25  2001 transx
  330. -rwxr-xr-x. 1 oracle oinstall      2997 Aug 22 17:17 trcasst
  331. -rwxr-xr-x. 1 oracle oinstall      2998 Aug 22 17:07 trcasst.ouibak
  332. -rwxr-xr-x. 1 oracle oinstall         0 Oct 22  2005 trcldr
  333. -rwxr-x--x. 1 oracle oinstall     21586 Aug 22 17:22 trcroute
  334. -rwxr-xr-x. 1 oracle oinstall         0 Mar 12  2008 trcroute0
  335. -rwxr-xr-x. 1 oracle oinstall      2060 Aug 22 17:07 trcsess
  336. -rwxr-x--x. 1 oracle oinstall     22198 Aug 22 17:23 tstshm
  337. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 tstshmO
  338. -rwxr-xr-x. 1 oracle oinstall      3124 Aug 22 17:17 umu
  339. -rwxr-xr-x. 1 oracle oinstall      3124 Aug 22 17:07 umu.ouibak
  340. -rwxr-xr-x. 1 oracle oinstall    101448 Jan  1  2000 unzip
  341. -rwxr-x--x. 1 oracle oinstall   6243095 Aug 22 17:22 wrap
  342. -rwxr-x---. 1 oracle oinstall         0 Mar 12  2008 wrapO
  343. -rwxr-xr-x. 1 oracle oinstall   1967294 Feb  5  2008 xml
  344. -rwxr-xr-x. 1 oracle oinstall   2376548 Feb  5  2008 xmlcg
  345. -rwxr-xr-x. 1 oracle oinstall     39481 Sep  2  2004 xmlwf
  346. -rwxr-xr-x. 1 oracle oinstall   1867426 Feb  5  2008 xsl
  347. -rwxr-xr-x. 1 oracle oinstall       762 Jan 12  2004 xsql
  348. -rwxr-xr-x. 1 oracle oinstall   1798277 Feb  5  2008 xvm
  349. -rwxr-xr-x. 1 oracle oinstall     84086 Feb 12  2008 zip
  350. [root@callcenter bin]# 
  351. [root@callcenter bin]# 
  352. [root@callcenter bin]# 
  355. 可以看出这些命令属于用户oracle。
  356. 要运行这个bin下的oracle命令，需要用oracle用户登陆，
  360. 然后切换用户
  361. [root@callcenter bin]# 
  362. [root@callcenter bin]# 
  363. [root@callcenter bin]# su - oracle
  364. [oracle@callcenter ~]$ 
  365. [oracle@callcenter ~]$ 
  366. [oracle@callcenter ~]$ 
  367. 这时会进入这个用户的主目录/home/oracle，这时可以用oracle的命令了
  368. exp xxx/xxx@11.0.198.1:1521/orcl file=devdb.dmp full=y 
  370. 由于导出是会有很多信息输出，最后完成后我们在屏幕上可能看不全这些输出信息，
  371. 所以可以使用重定向把输出信息写入一个文件。
  374. exp xxx/xxx@11.0.198.1:1521/orcl file=devdb.dmp full=y  >explog 2>&1
  375. （注意，命令可能需要运行一段时间，在此期间你看不到输出信息，因为被重定向到文件explog中去了，耐心等命令
  376. 运行完）运行命令完成后
  377. [oracle@callcenter ~]$ 
  378. [oracle@callcenter ~]$ pwd
  379. /home/oracle
  380. [oracle@callcenter ~]$ 
  381. [oracle@callcenter ~]$ 
  382. [oracle@callcenter ~]$ 
  383. [oracle@callcenter ~]$ ls
  384. 10201_database_linux_x86_64.cpio  Disk1  database  devdb.dmp  explog
  385. [oracle@callcenter ~]$ 
  386. [oracle@callcenter ~]$ 
  387. 这次导出日志文件很长，有2000多行，也有一些错误提示信息，这里就只贴出开始和结尾几行：
  391. Export: Release 10.2.0.4.0 - Production on Fri Nov 7 14:37:11 2014
  393. Copyright (c) 1982, 2007, Oracle.  All rights reserved.
  396. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
  397. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  398. Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
  399. server uses AL32UTF8 character set (possible charset conversion)
  401. About to export the entire database ...
  402. . exporting tablespace definitions
  403. . exporting profiles
  404. . exporting user definitions
  405. . exporting roles
  406. . exporting resource costs
  408. 省略
  410. EXP-00091: Exporting questionable statistics.
  411. . . exporting table             TB_ZJ_SETTINGGRADE         23 rows exported
  412. EXP-00091: Exporting questionable statistics.
  413. EXP-00091: Exporting questionable statistics.
  414. EXP-00091: Exporting questionable statistics.
  415. . . exporting table                          X_SEQ          7 rows exported
  416. EXP-00091: Exporting questionable statistics.
  417. EXP-00091: Exporting questionable statistics.
  418. . exporting synonyms
  419. . exporting views
  420. . exporting referential integrity constraints
  421. . exporting stored procedures
  422. . exporting operators
  423. . exporting indextypes
  424. . exporting bitmap, functional and extensible indexes
  425. . exporting posttables actions
  426. . exporting triggers
  427. . exporting materialized views
  428. . exporting snapshot logs
  429. . exporting job queues
  430. . exporting refresh groups and children
  431. . exporting dimensions
  432. . exporting post-schema procedural objects and actions
  433. . exporting user history table
  434. . exporting default and system auditing options
  435. . exporting statistics
  436. Export terminated successfully with warnings.

发表评论

表情：
评论列表 （有 0 条评论，431人围观）

还没有评论，来说两句吧...

相关阅读

    相关 linux下对oracle备份

    如题，在linux上装了数据库oracle，需要对数据进行备份。 这个命令其实网上很多，这里就说说怎么打linux命令。 登陆linux后，进入

    红太狼红太狼/ 0 赞/ 432 阅读