在DATAGUARD 物理备机上。
vi out.parm
-
userid=system/<password>
-
owner=bigshow
-
file=out.dmp
-
log=out.log
- STATISTICS = none
-
Connected to:
-
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
-
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-
-
SQL> alter database recover managed standby database cancel;
-
-
Database altered.
-
-
SQL> alter database open;
-
-
Database altered.
-
- SQL>
导出数据
-
/home/oracle:STANDBY >exp parfile=out.parm
-
-
Export: Release 11.2.0.2.0 - Production on Fri Feb 17 09:28:27 2012
-
-
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
-
-
-
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
-
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
-
server uses WE8MSWIN1252 character set (possible charset conversion)
-
-
About to export specified users ...
-
. exporting pre-schema procedural objects and actions
-
. exporting foreign function library names for user BIGSHOW
-
. exporting PUBLIC type synonyms
-
. exporting private type synonyms
-
. exporting object type definitions for user BIGSHOW
-
About to export BIGSHOW's objects ...
-
. exporting database links
-
. exporting sequence numbers
-
. exporting cluster definitions
-
. about to export BIGSHOW's tables via Conventional Path ...
-
. . exporting table CUSTOMER 0 rows exported
-
. . exporting table CUSTOMER2 0 rows exported
-
. exporting synonyms
-
. exporting views
-
. exporting stored procedures
-
. exporting operators
-
. exporting referential integrity constraints
-
. exporting triggers
-
. exporting indextypes
-
. exporting bitmap, functional and extensible indexes
-
. exporting posttables actions
-
. exporting materialized views
-
. exporting snapshot logs
-
. exporting job queues
-
. exporting refresh groups and children
-
. exporting dimensions
-
. exporting post-schema procedural objects and actions
-
. exporting statistics
- Export terminated successfully without warnings.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/17086096/viewspace-2072921/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
db2diag rc code
下一篇：
利用UDEV管理配置ASMDISK
请登录后发表评论
登录
全部评论
最新文章
- 如何做一份完善的补丁分析
- 'cursor:mutex ..'/ 'cursor:pin ..'/ 'library cache:mutex ..'类型的等待事件
- High Version Count Issues（SQL高Version Count） (文档 ID 296377.1)
- 分享：RAC 环境中最常见的 5 个数据库和/或实例性能问题 (文档 ID 1602076.1)
- Oracle11g使用LOGMNR挖掘日志
- sql monitor中timestamp变量转换可识别格式
- 自适应游标共享
- oracle 11g常用隐含参数
- 聊聊Oracle 11g的Result Cache（三）
- 聊聊Oracle 11g的Result Cache（二）
