基于ACG的大表的导出的一种方式

1主库 defer
log_archive_dest_4                   string      SERVICE=vposdg LGWR ASYNC VALI
                                                 D_FOR=(ONLINE_LOGFILES,PRIMARY
                                                 _ROLE) DB_UNIQUE_NAME=vposdg

alter system set log_archive_dest_state_4=defer;
alter system archivelog current;

2物理备库
alter database recover managed standby database cancel;
shutdown immediate;
startup mount;
alter database flashback on;

create restore point p_back guarantee flashback database;

alter system set db_recovery_file_dest_size=4g;

select current_scn from v$database;

alter database backup controlfile to '/home/oracle/control_back_20140828.ctl';

alter database recover managed standby database finish force;

alter database commit to switchover to primary;

alter database open;

导出表
expdp maspos/irunwmakxuttxvzn directory=kiwi dumpfile=t_bk_2.dmp logfile=t_bk_2.log tables="(T_BK_APPLY,T_BK_RECORD,T_BK_PE_PAYMENT_ORDER,T_BK_PE_DEAL,T_BK_PE_DEAL_EXT,T_BK_ACCT_CODE,T_BK_ACCT_CODE_HISTORY,T_BK_CONFIG)" flashback_scn=6049103382845 parallel=8


3恢复备库
col standby_became_primary_scn format a999999999999999
select standby_became_primary_scn sp_scn from v$database;

shutdown immediate;

startup mount;

flashback database to restore point p_back;
ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
alter database recover managed standby database using current logfile disconnect from session;