DATAGUARD PHYSICAL STANDY下EXPDP数据

在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
   
4. 
   
5. SQL> alter database recover managed standby database cancel;
   
6. 
   
7. Database altered.
   
8. 
   
9. SQL> alter database open;
   
10. 
    
11. Database altered.
    
12. 
    
13. SQL>

导出数据

1. /home/oracle:STANDBY >exp parfile=out.parm
   
2. 
   
3. Export: Release 11.2.0.2.0 - Production on Fri Feb 17 09:28:27 2012
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
   
6. 
   
7. 
   
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)
    
12. 
    
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17086096/viewspace-2072921/