[20200309]expdp 与read only.txt

--//链接：http://www.itpub.net/thread-2128382-1-1.html问的问题。
--//请教各位大佬，在dataguard的read only模式下，不做转换，如何使用expdp导出数据？

--//在本地read only的情况下，不能使用expdp导出数据的。。

1.环境：
SYS@bookdg> select open_mode from v$database ;
OPEN_MODE
--------------------
READ ONLY WITH APPLY

$ expdp scott/book tables=T
Export: Release 11.2.0.4.0 - Production on Mon Mar 9 10:09:15 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SCOTT.SYS_EXPORT_TABLE_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1038
ORA-16000: database open for read-only access
--//无法建立master table SCOTT.SYS_EXPORT_TABLE_05.

2.可以找一台读写的机器，通过dblink实现到处，甚至导入。

CREATE PUBLIC DATABASE LINK TEST040
 CONNECT TO SCOTT
 IDENTIFIED BY book
 USING 'bookdg';

SYS@book> select sysdate from dual@test040;
SYSDATE
-------------------
2020-03-09 10:14:23

SYS@book> alter system set log_archive_dest_state_2=defer scope=memory;
System altered.

SYS@book> alter system archive log current ;
System altered.

SCOTT@book> insert into t  select * from t where rownum=1;
1 row created.

SCOTT@book> commit ;
Commit complete.

SCOTT@book> select count(*) from t;
COUNT(*)
----------
     85034

$ expdp scott/book NETWORK_LINK=test040  tables=T  DUMPFILE=t.dmp
Export: Release 11.2.0.4.0 - Production on Mon Mar 9 10:21:10 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/a*** NETWORK_LINK=test040 tables=T DUMPFILE=t.dmp
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SCOTT"."T"                                 8.244 MB   85033 rows
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--//我在主库导出，你可以发现我停止日志应用，备库少1条记录。
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  /u01/app/oracle/admin/book/dpdump/t.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Mon Mar 9 10:21:16 2020 elapsed 0 00:00:05
--//OK,导出成功。

3.你还可以直接导入：

$ impdp scott/book NETWORK_LINK=test040  tables=T  REMAP_TABLE=scott.T:scott.T1
Import: Release 11.2.0.4.0 - Production on Mon Mar 9 10:24:12 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_IMPORT_TABLE_01":  scott/a* NETWORK_LINK=test040 tables=T REMAP_TABLE=scott.T:scott.T1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . imported "SCOTT"."SCOTT.T1"                           85033 rows
Job "SCOTT"."SYS_IMPORT_TABLE_01" successfully completed at Mon Mar 9 10:24:18 2020 elapsed 0 00:00:06
--//昏，语法有问题，不过还是导入成功了。不需要在后面schema。

SYS@book> select count(*) from scott."SCOTT.T1";
  COUNT(*)
----------
     85033

SYS@book> select count(*) from SCOTT.T;
  COUNT(*)
----------
     85034