DATAGUARD PHYSICAL STANDY下EXPDP資料

startay發表於2016-03-31

在DATAGUARD 物理備機上。

vi out.parm
  1. userid=system/<password>
  2. owner=bigshow
  3. file=out.dmp
  4. log=out.log
  5. STATISTICS = none
登入資料庫，關閉日誌應用
  1. Connected to:
  2. Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
  3. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  5. SQL> alter database recover managed standby database cancel;

  7. Database altered.

  9. SQL> alter database open;

  11. Database altered.

  13. SQL>

匯出資料
  1. /home/oracle:STANDBY >exp parfile=out.parm

  3. Export: Release 11.2.0.2.0 - Production on Fri Feb 17 09:28:27 2012

  5. Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


  8. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
  9. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  10. Export done in US7ASCII character set and AL16UTF16 NCHAR character set
  11. server uses WE8MSWIN1252 character set (possible charset conversion)

  13. About to export specified users ...
  14. . exporting pre-schema procedural objects and actions
  15. . exporting foreign function library names for user BIGSHOW
  16. . exporting PUBLIC type synonyms
  17. . exporting private type synonyms
  18. . exporting object type definitions for user BIGSHOW
  19. About to export BIGSHOW's objects ...
  20. . exporting database links
  21. . exporting sequence numbers
  22. . exporting cluster definitions
  23. . about to export BIGSHOW's tables via Conventional Path ...
  24. . . exporting table CUSTOMER 0 rows exported
  25. . . exporting table CUSTOMER2 0 rows exported
  26. . exporting synonyms
  27. . exporting views
  28. . exporting stored procedures
  29. . exporting operators
  30. . exporting referential integrity constraints
  31. . exporting triggers
  32. . exporting indextypes
  33. . exporting bitmap, functional and extensible indexes
  34. . exporting posttables actions
  35. . exporting materialized views
  36. . exporting snapshot logs
  37. . exporting job queues
  38. . exporting refresh groups and children
  39. . exporting dimensions
  40. . exporting post-schema procedural objects and actions
  41. . exporting statistics
  42. Export terminated successfully without warnings.


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17086096/viewspace-2072921/，如需轉載，請註明出處，否則將追究法律責任。

相關文章