活动第39次(2018-07-14星期六下午)
检查一下在根容器上有没有统一审计,并且打开新的统一审计:select* fromaudit_unified_enabled_policies;
CREATE AUDIT POLICY audit_tablespace
ACTIONS create tablespace;
select* fromaudit_unified_enabled_policies;
audit policy AUDIT_TABLESPACE;
select* fromaudit_unified_enabled_policies;如果要关掉统一审计,并且查看哪些是关掉的统一审计策略:
noaudit policy AUDIT_TABLESPACE;
select * from audit_unified_enabled_policies;
select * from audit_unified_policiesorder by 1;
统一审计轨迹(unified_audit_trail),每个插件数据库看自己的,根容器看全部的:
SELECT dbusername, action_name, object_name
2FROM unified_audit_trail
3;
DBUSERNAME
------------------------------
ACTION_NAME
----------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SYS
CREATE TABLESPACE
TBS_ORCL
SYS
CREATE TABLESPACE
TBS_ORCL
DBUSERNAME
------------------------------
ACTION_NAME
----------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SYS
COMMIT
SYS
COMMIT
DBUSERNAME
------------------------------
ACTION_NAME
----------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SYS
LOGON
SQL> conn sys/oracle_4U@pdb2 as sysdba
Connected.
SELECT dbusername, action_name, object_name
2FROM unified_audit_trail
3;
DBUSERNAME
------------------------------
ACTION_NAME
----------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SYS
DROP USER
LU_PDB2
SYS
LOGON
DBUSERNAME
------------------------------
ACTION_NAME
----------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SYS
COMMIT
SYS
COMMIT
DBUSERNAME
------------------------------
ACTION_NAME
----------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SYS
DROP USER
LU_PDB2
SQL>
根容器上的表空间创建是不会有统一审计的,统一审计只针对插件数据库。
如果找不到审计轨迹,要么等待,要么执行DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL, 然后再去看 unified_audit_trail。
最后需要区分一下cdb_unified_audit_trail和unidied_audit_trail:
-------------------------------------------------------------逻辑备份的FULL TRANSPORTABLE模式:
expdp help=y
找到TRANSPORTABLE
Specify whether transportable method can be used.
Valid keyword values are: ALWAYS and .
采用“嫁接”和“生长”结合的方法移动数据:
$ expdp system/oracle_4Udumpfile=expfull.dmpfull=y transportable=alwayslogfile=expfull.log
Export: Release 12.1.0.2.0 - Production on Sat Jul 14 15:18:49 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates.All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01":system/******** dumpfile=expfull.dmp full=y transportable=always logfile=expfull.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/PLUGTS_FULL/FULL/PLUGTS_TABLESPACE
Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 5.578 MB
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/RADM_FPTM
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/STATISTICS/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/INDEX/INDEX
ORA-39340: unsupported object, INDEX:"SH"."SYS_IL0000092978C00006[ DISCUZ_CODE_3 ]quot; will be skipped.
ORA-39340: unsupported object, INDEX:"SH"."SYS_IL0000092981C00002[ DISCUZ_CODE_3 ]quot; will be skipped.
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
Processing object type DATABASE_EXPORT/END_PLUGTS_BLK
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
. . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.140 KB 42 rows
. . exported "ORDDATA"."ORDDCM_DOCS" 252.9 KB 9 rows
. . exported "WMSYS"."WM$CONSTRAINTS_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."AUD[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$LOCKROWS_INFO[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$UDTRIG_INFO[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows
. . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows
. . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows
. . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows
. . exported "SYS"."DAM_CLEANUP_EVENTS[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."DAM_CLEANUP_JOBS[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."DAM_CONFIG_PARAM[ DISCUZ_CODE_3 ]quot; 6.531 KB 14 rows
. . exported "SYS"."TSDP_ASSOCIATION[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."TSDP_CONDITION[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."TSDP_FEATURE_POLICY[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."TSDP_PARAMETER[ DISCUZ_CODE_3 ]quot; 5.953 KB 1 rows
. . exported "SYS"."TSDP_POLICY[ DISCUZ_CODE_3 ]quot; 5.921 KB 1 rows
. . exported "SYS"."TSDP_PROTECTION[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."TSDP_SENSITIVE_DATA[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."TSDP_SENSITIVE_TYPE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."TSDP_SOURCE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "SYS"."TSDP_SUBPOL[ DISCUZ_CODE_3 ]quot; 6.328 KB 1 rows
. . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows
. . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows
. . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$CONS_COLUMNS[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$ENV_VARS[ DISCUZ_CODE_3 ]quot; 6.015 KB 3 rows
. . exported "WMSYS"."WM$EVENTS_INFO[ DISCUZ_CODE_3 ]quot; 5.812 KB 12 rows
. . exported "WMSYS"."WM$HINT_TABLE[ DISCUZ_CODE_3 ]quot; 9.453 KB 75 rows
. . exported "WMSYS"."WM$MODIFIED_TABLES[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$NEXTVER_TABLE[ DISCUZ_CODE_3 ]quot; 6.375 KB 1 rows
. . exported "WMSYS"."WM$REMOVED_WORKSPACES_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_LOCKING_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE[ DISCUZ_CODE_3 ]quot; 5.984 KB 1 rows
. . exported "WMSYS"."WM$VERSION_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$VT_ERRORS_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "WMSYS"."WM$WORKSPACES_TABLE[ DISCUZ_CODE_3 ]quot; 12.10 KB 1 rows
. . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE[ DISCUZ_CODE_3 ]quot; 7.054 KB 10 rows
. . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE[ DISCUZ_CODE_3 ]quot; 0 KB 0 rows
. . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows
. . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows
. . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows
. . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POL" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows
. . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows
. . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows
. . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows
. . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 9.515 KB 12 rows
. . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows
. . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows
. . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows
. . exported "SYS"."NACL$_ACE_EXP" 9.929 KB 1 rows
. . exported "SYS"."NACL$_HOST_EXP" 6.914 KB 1 rows
. . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows
. . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
/u01/app/oracle/admin/orcl/dpdump/expfull.dmp
******************************************************************************
Datafiles required for transportable tablespace EXAMPLE:
/u01/app/oracle/oradata/orcl/example01.dbf
Datafiles required for transportable tablespace USERS:
/u01/app/oracle/oradata/orcl/users01.dbf
Job "SYSTEM"."SYS_EXPORT_FULL_01" completed with 2 error(s) at Sat Jul 14 15:22:09 2018 elapsed 0 00:03:18
$
/u01/app/oracle/admin/orcl/dpdump/expfull.dmp用于“生长”。拷贝到数据泵的工作目录。
以下用于“嫁接”。拷贝到pdb_orcl的数据文件目录。
Datafiles required for transportable tablespace EXAMPLE:
/u01/app/oracle/oradata/orcl/example01.dbf
Datafiles required for transportable tablespace USERS:
/u01/app/oracle/oradata/orcl/users01.dbf
$ impdp system/oracle_4U@pdb_orcl directory=dp_orcldumpfile=expfull.dmpfull=y transport_datafiles='/u01/app/oracle/oradata/cdb2/pdb_orcl/example01.dbf','/u01/app/oracle/oradata/cdb2/pdb
pdb21/ pdb22/ pdb_orcl/ pdbseed/
$ impdp system/oracle_4U@pdb_orcl directory=dp_orcldumpfile=expfull.dmpfull=y transport_datafiles='/u01/app/oracle/oradata/cdb2/pdb_orcl/example01.dbf','/u01/app/oracle/oradata/cdb2/pdb_orcl/users01.dbf'
Import: Release 12.1.0.2.0 - Production on Sat Jul 14 15:45:24 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates.All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Source time zone is +00:00 and target time zone is -07:00.
Starting "SYSTEM"."SYS_IMPORT_FULL_01":system/********@pdb_orcl directory=dp_orcl dumpfile=expfull.dmp full=y transport_datafiles=/u01/app/oracle/oradata/cdb2/pdb_orcl/example01.dbf,/u01/app/oracle/oradata/cdb2/pdb_orcl/users01.dbf
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39083: Object type TABLESPACE:"UNDOTBS1" failed to create with error:
ORA-01516: nonexistent log file, data file, or temporary file "/u01/app/oracle/oradata/orcl/undotbs01.dbf"
Failing sql is:
ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf' RESIZE 157286400
ORA-31684: Object type TABLESPACE:"TEMP" already exists
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/RADM_FPTM
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-65040: operation not allowed from within a pluggable database
ORA-13900: missing or invalid parameter metric_id
Failing sql is:
BEGIN
dbms_server_alert.set_threshold(2104,dbms_server_alert.operator_GT,'1200',NULL,NULL,1,3,'orcl',dbms_server_alert.object_type_SYSTEM,'');COMMIT; END;
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
. . imported "SYS"."KU$_EXPORT_USER_MAP" 6.140 KB 42 rows
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
. . imported "ORDDATA"."ORDDCM_DOCS_TRANSIENT" 252.9 KB 9 rows
. . imported "WMSYS"."E$CONSTRAINTS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."AMGT$DP$AUD[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$LOCKROWS_INFO[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$UDTRIG_INFO[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM[ DISCUZ_CODE_4 ]quot; 6.531 KB 14 rows
. . imported "SYS"."DP$TSDP_ASSOCIATION[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."DP$TSDP_CONDITION[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."DP$TSDP_FEATURE_POLICY[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."DP$TSDP_PARAMETER[ DISCUZ_CODE_4 ]quot; 5.953 KB 1 rows
. . imported "SYS"."DP$TSDP_POLICY[ DISCUZ_CODE_4 ]quot; 5.921 KB 1 rows
. . imported "SYS"."DP$TSDP_PROTECTION[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."DP$TSDP_SENSITIVE_DATA[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."DP$TSDP_SENSITIVE_TYPE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."DP$TSDP_SOURCE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "SYS"."DP$TSDP_SUBPOL[ DISCUZ_CODE_4 ]quot; 6.328 KB 1 rows
. . imported "SYSTEM"."REDO_DB_TMP" 25.59 KB 1 rows
. . imported "SYSTEM"."REDO_LOG_TMP" 0 KB 0 rows
. . imported "WMSYS"."E$BATCH_COMPRESSIBLE_TABLES[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$CONS_COLUMNS[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$ENV_VARS[ DISCUZ_CODE_4 ]quot; 6.015 KB 3 rows
. . imported "WMSYS"."E$EVENTS_INFO[ DISCUZ_CODE_4 ]quot; 5.812 KB 12 rows
. . imported "WMSYS"."E$HINT_TABLE[ DISCUZ_CODE_4 ]quot; 9.453 KB 75 rows
. . imported "WMSYS"."E$MODIFIED_TABLES[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$MP_GRAPH_WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$MP_PARENT_WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$NESTED_COLUMNS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$NEXTVER_TABLE[ DISCUZ_CODE_4 ]quot; 6.375 KB 1 rows
. . imported "WMSYS"."E$REMOVED_WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$RESOLVE_WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$RIC_LOCKING_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$RIC_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$RIC_TRIGGERS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$UDTRIG_DISPATCH_PROCS[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$VERSION_HIERARCHY_TABLE[ DISCUZ_CODE_4 ]quot; 5.984 KB 1 rows
. . imported "WMSYS"."E$VERSION_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$VT_ERRORS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "WMSYS"."E$WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 12.10 KB 1 rows
. . imported "WMSYS"."E$WORKSPACE_PRIV_TABLE[ DISCUZ_CODE_4 ]quot; 7.054 KB 10 rows
. . imported "WMSYS"."E$WORKSPACE_SAVEPOINTS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$AUDIT" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$COMPARTMENTS" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$GROUPS" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$LAB" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$LEVELS" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$POL" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$POLS" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$POLT" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$PROFILE" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$PROG" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$USER" 0 KB 0 rows
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
. . imported "SYS"."AMGT$DP$FGA_LOG$FOR_EXPORT" 0 KB 0 rows
. . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP" 0 KB 0 rows
. . imported "SYSTEM"."SCHEDULER_PROGRAM_ARGS_TMP" 9.515 KB 12 rows
. . imported "SYS"."AMGT$DP$AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows
. . imported "SYS"."DP$DBA_SENSITIVE_DATA" 0 KB 0 rows
. . imported "SYS"."DP$DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows
. . imported "SYS"."NACL$_ACE_IMP" 9.929 KB 1 rows
. . imported "SYS"."NACL$_HOST_IMP" 6.914 KB 1 rows
. . imported "SYS"."NACL$_WALLET_IMP" 0 KB 0 rows
. . imported "WMSYS"."E$EXP_MAP" 7.718 KB 3 rows
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39360: Table "OE"."ORDERS" was skipped due to transportable import and TSLTZ issues resulting from time zone mismatch.
ORA-39151: Table "OE"."PURCHASEORDER" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39112: Dependent object type OBJECT_GRANT:"OE" skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"OE" skipped, base object type TABLE:"OE"."ORDERS" creation failed
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
ORA-39112: Dependent object type INDEX:"OE"."ORDER_PK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type INDEX:"OE"."ORD_SALES_REP_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type INDEX:"OE"."ORD_CUSTOMER_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type INDEX:"OE"."ORD_ORDER_DATE_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_MODE_LOV" skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_TOTAL_MIN" skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_PK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39083: Object type REF_CONSTRAINT:"OE"."ORDER_ITEMS_ORDER_ID_FK" failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
ALTER TABLE "OE"."ORDER_ITEMS" ADD CONSTRAINT "ORDER_ITEMS_ORDER_ID_FK" FOREIGN KEY ("ORDER_ID") REFERENCES "OE"."ORDERS" ("ORDER_ID") ON DELETE CASCADE ENABLE NOVALIDATE
ORA-39112: Dependent object type REF_CONSTRAINT:"OE"."ORDERS_SALES_REP_FK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
ORA-39112: Dependent object type REF_CONSTRAINT:"OE"."ORDERS_CUSTOMER_ID_FK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/STATISTICS/MARKER
OE.ACTION_TABLE_MEMBERS : sqlerrm = ORA-20000: Unable to set values for index ACTION_TABLE_MEMBERS: does not exist or insufficient privileges
OE.LINEITEM_TABLE_MEMBERS : sqlerrm = ORA-20000: Unable to set values for index LINEITEM_TABLE_MEMBERS: does not exist or insufficient privileges
OE.SYS_C0010299 : sqlerrm = ORA-20000: Unable to set values for index SYS_C0010299: does not exist or insufficient privileges
OE.SYS_C0010300 : sqlerrm = ORA-20000: Unable to set values for index SYS_C0010300: does not exist or insufficient privileges
Importing statistics failed for 4 object(s);
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
ORA-39083: Object type TRIGGER:"OE"."ORDERS_ITEMS_TRG" failed to create with error:
ORA-00904: "ORDER_ITEM_LIST": invalid identifier
Failing sql is:
CREATE EDITIONABLE TRIGGER orders_items_trg INSTEAD OF INSERT ON NESTED
TABLE order_item_list OF oc_orders FOR EACH ROW
DECLARE
prodproduct_information_typ;
BEGIN
SELECT DEREF(:NEW.product_ref) INTO prod FROM DUAL;
INSERT INTO order_items VALUES (prod.product_id, :NEW.order_id,
:NEW.line_item_id, :NEW.unit_pric
Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
Processing object type DATABASE_EXPORT/END_PLUGTS_BLK
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_PURGE_SESSIONS" failed to create with error:
ORA-27477: "APEX_040200"."ORACLE_APEX_PURGE_SESSIONS" already exists
Failing sql is:
BEGIN
dbms_scheduler.create_job('"ORACLE_APEX_PURGE_SESSIONS"',
job_type=>'STORED_PROCEDURE', job_action=>
'WWV_FLOW_CACHE.PURGE_SESSIONS'
, number_of_arguments=>0,
start_date=>TO_TIMESTAMP_TZ('07-JUL-2014 06.29.54.833453000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=>
'FREQ
ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_MAIL_QUEUE" failed to create with error:
ORA-27477: "APEX_040200"."ORACLE_APEX_MAIL_QUEUE" already exists
Failing sql is:
BEGIN
dbms_scheduler.create_job('"ORACLE_APEX_MAIL_QUEUE"',
job_type=>'STORED_PROCEDURE', job_action=>
'WWV_FLOW_MAIL.PUSH_QUEUE_IMMEDIATE'
, number_of_arguments=>0,
start_date=>TO_TIMESTAMP_TZ('07-JUL-2014 06.29.55.278873000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=>
'FREQ=MINUTE
ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS" failed to create with error:
ORA-27477: "APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS" already exists
Failing sql is:
BEGIN
dbms_scheduler.create_job('"ORACLE_APEX_WS_NOTIFICATIONS"',
job_type=>'STORED_PROCEDURE', job_action=>
'WWV_FLOW_WORKSHEET_API.DO_NOTIFY'
, number_of_arguments=>0,
start_date=>TO_TIMESTAMP_TZ('07-JUL-2014 06.29.55.281735000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval
ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_DAILY_MAINTENANCE" failed to create with error:
ORA-27477: "APEX_040200"."ORACLE_APEX_DAILY_MAINTENANCE" already exists
Failing sql is:
BEGIN
dbms_scheduler.create_job('"ORACLE_APEX_DAILY_MAINTENANCE"',
job_type=>'STORED_PROCEDURE', job_action=>
'WWV_FLOW_MAINT.DAILY_MAINTENANCE'
, number_of_arguments=>0,
start_date=>TO_TIMESTAMP_TZ('07-JUL-2014 06.29.55.284760000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_inter
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
ORA-39082: Object type VIEW:"OE"."ORDERS_VIEW" created with compilation warnings
ORA-39082: Object type VIEW:"OE"."OC_CUSTOMERS" created with compilation warnings
ORA-39082: Object type VIEW:"OE"."OC_CORPORATE_CUSTOMERS" created with compilation warnings
ORA-39082: Object type VIEW:"OE"."OC_ORDERS" created with compilation warnings
ORA-39082: Object type TRIGGER:"OE"."ORDERS_TRG" created with compilation warnings
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 40 error(s) at Sat Jul 14 15:47:48 2018 elapsed 0 00:02:20
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 14 15:48:19 2018
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn sys/oracle_4U@pdb_orcl as sysdba
Connected.
SQL> select tablespace_name , status from cdb_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
SYSAUX ONLINE
TEMP ONLINE
EXAMPLE ONLINE
USERS ONLINE
SQL> selectcount(*) from hr.employees;
COUNT(*)
----------
107
SQL>
页:
[1]