expdp 全庫匯入報錯總結

  2014.11.27

環境：11.2.0.3 64位
impdp \'/ as sysdba\' directory=imp27 full=y dumpfile=full_%U.dmp logfile=fullimp.log parallel=10  table_exists_action=replace;
    由於開發的需要，做了一次正式庫全庫匯出，在倒入到測試庫。結果出現一些報錯：
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
ORA-31684: Object type TABLESPACE:"TBS_SD_BL" already exists

ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02494: invalid or missing maximum file size in MAXSIZE clause
Failing sql is:
CREATE TABLESPACE "TBS_VIEW_BL" DATAFILE '/u04/datafile/TBS_VIEW_BL01.dbf' SIZE 8589934592 AUTOEXTEND ON NEXT 10485760 M
AXSIZE 5120M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS  SEGMENT SP
ACE MANAGEMENT AUTO

Failing sql is:
 ALTER USER "SYS" IDENTIFIED BY VALUES 'S:F911CF680FFB1D8DCB017DCCF55D4D464F72B7D45C6CB3E85092DC58D601;CA908C0E625F4F62'
 TEMPORARY TABLESPACE "TEMP2"
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-39083: Object type USER failed to create with error:
ORA-00959: tablespace 'TEMP2' does not exist
Failing sql is:
 ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'S:D8DC00054068D35077EA3B307F27DEA44708DF6F14FB8E364CF2B81F164E;2D594E86F93B17
A1' TEMPORARY TABLESPACE "TEMP2"


ORA-31684: Object type USER:"SYSMAN" already exists
ORA-31684: Object type USER:"MGMT_VIEW" already exists

ORA-31684: Object type ROLE:"SELECT_CATALOG_ROLE" already exists
ORA-31684: Object type ROLE:"EXECUTE_CATALOG_ROLE" already exists

ORA-31684: Object type DB_LINK:"U_CL_CTL"."ZZHD195" already exists

ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_OBJECTS_S" already exists

ORA-39111: Dependent object type OBJECT_GRANT:"OLAPSYS" skipped, base object type SEQUENCE:"OLAPSYS"."CWM2_OLAP_ENABLESE
Q" already exists

ORA-31684: Object type DIRECTORY:"DATA_PUMP_DIR" already exists
ORA-31684: Object type DIRECTORY:"XMLDIR" already exists

ORA-31684: Object type CONTEXT:"EM_USER_CONTEXT" already exists
ORA-31684: Object type CONTEXT:"STORAGE_CONTEXT" already exists
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
ORA-31684: Object type SYNONYM:"PUBLIC"."OL$" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."OL$HINTS" already exist

ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
Failing sql is:
BEGIN
 SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ZBSHOES','x86_64/Linux 2.4.xx');
 END;

上面的報錯資訊，都是安裝倒入日誌的的先後順序，
1、在做全庫倒入的時候，要先把相應的表空間建上，不然可能由於路徑的原因報錯，上面的有建立TBS_VIEW_BL 表空間失敗。
2、全庫倒入的時候，不需要建立使用者，但是我試驗的情況，建上也沒關係，最多提示使用者已存在，其實這個報錯可以忽略。
3、全庫倒入的時候，會一次檢查，使用者，角色，檢視，DIRECTORY，儲存過程，許可權，同義詞... 最後一步就是insert表資料。