Export Statspack reportů

Ladění dotazu a kontrola exekučního plánu ORA-00600: internal error code, arguments: [13013]

Tomáš Solař – databázový administrátor Health check zdarma
DBA for reference Nezapomeňte patchovat Monitorování databáze Kontakt

14. 1. 2016
Řešení

C:\>expdp '/ as sysdba' directory=DPUMP_DIR1 dumpfile=perfstat.dmp logfile=perfstat.log PARFILE='c:\Oracle\db02\RDBMS\ADMIN\spuexp.par'
 LRM-00112: multiple values not allowed for parameter 'logfile'

Export: Release 11.2.0.4.0 - Production on Thu Jan 14 14:44:08 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
 LRM-00112: multiple values not allowed for parameter 'logfile'

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
 Legacy Mode Active due to the following parameters:
 Legacy Mode Parameter: "compress=TRUE" Location: Parameter File, ignored.
 Legacy Mode Parameter: "consistent=TRUE" Location: Parameter File, Replaced with: "flashback_time=TO_TIMESTAMP('2016-01-14 14:44:08', 'YYYY-MM-DD HH24
 :MI:SS')"
 Legacy Mode Parameter: "constraints=TRUE" Location: Parameter File, ignored.
 Legacy Mode Parameter: "file=spuexp.dmp" Location: Parameter File, Replaced with: "dumpfile=spuexp.dmp"
 Legacy Mode Parameter: "grants=TRUE" Location: Parameter File, ignored.
 Legacy Mode Parameter: "indexes=TRUE" Location: Parameter File, ignored.
 Legacy Mode Parameter: "log=spuexp.log" Location: Parameter File, Replaced with: "logfile=spuexp.log"
 Legacy Mode Parameter: "owner=PERFSTAT" Location: Parameter File, Replaced with: "schemas=PERFSTAT"
 Legacy Mode Parameter: "rows=TRUE" Location: Parameter File, Replaced with: "content=all"
 Legacy Mode has set reuse_dumpfiles=true parameter.
 Starting "SYS"."SYS_EXPORT_SCHEMA_01": "/******** AS SYSDBA" directory=DPUMP_DIR1 dumpfile=perfstat.dmp logfile=perfstat.log PARFILE='c:\Oracle\db02\
 RDBMS\ADMIN\spuexp.par' reuse_dumpfiles=true
 Estimate in progress using BLOCKS method...
 Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
 Total estimation using BLOCKS method: 890 MB
 Processing object type SCHEMA_EXPORT/USER
 Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
 Processing object type SCHEMA_EXPORT/ROLE_GRANT
 Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
 Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
 Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
 Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
 >>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled
 Processing object type SCHEMA_EXPORT/TABLE/TABLE
 Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
 Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
 Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
 Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
 Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
 Processing object type SCHEMA_EXPORT/VIEW/VIEW
 Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
 Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
 >>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled
 >>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled
 . . exported "PERFSTAT"."STATS$SQL_SUMMARY" 332.0 MB 1577771 rows
 . . exported "PERFSTAT"."STATS$EVENT_HISTOGRAM" 77.52 MB 2535041 rows
 . . exported "PERFSTAT"."STATS$LATCH" 74.72 MB 1152946 rows
 . . exported "PERFSTAT"."STATS$SYSSTAT" 67.84 MB 1299184 rows
 . . exported "PERFSTAT"."STATS$PARAMETER" 38.75 MB 738340 rows
 . . exported "PERFSTAT"."STATS$FILE_HISTOGRAM" 31.92 MB 1151757 rows
 . . exported "PERFSTAT"."STATS$LATCH_MISSES_SUMMARY" 22.06 MB 364270 rows
 . . exported "PERFSTAT"."STATS$SYSTEM_EVENT" 17.74 MB 252505 rows
 . . exported "PERFSTAT"."STATS$FILESTATXS" 12.80 MB 111074 rows
 . . exported "PERFSTAT"."STATS$ENQUEUE_STATISTICS" 10.15 MB 195418 rows
 . . exported "PERFSTAT"."STATS$SQLTEXT" 10.19 MB 77502 rows
 . . exported "PERFSTAT"."STATS$PROCESS_MEMORY_ROLLUP" 7.744 MB 155422 rows
 . . exported "PERFSTAT"."STATS$ROWCACHE_SUMMARY" 7.326 MB 117990 rows
 . . exported "PERFSTAT"."STATS$SQL_PLAN" 608.9 KB 2108 rows
 . . exported "PERFSTAT"."STATS$SQL_PLAN_USAGE" 107.2 KB 887 rows
 . . exported "PERFSTAT"."STATS$DB_CACHE_ADVICE" 2.953 MB 43325 rows
 . . exported "PERFSTAT"."STATS$LIBRARYCACHE" 3.030 MB 51958 rows
 . . exported "PERFSTAT"."STATS$MUTEX_SLEEP" 3.481 MB 67468 rows
 . . exported "PERFSTAT"."STATS$PROCESS_ROLLUP" 3.344 MB 43467 rows
 . . exported "PERFSTAT"."STATS$SHARED_POOL_ADVICE" 2.713 MB 45933 rows
 . . exported "PERFSTAT"."STATS$MEMORY_DYNAMIC_COMPS" 2.203 MB 33120 rows
 . . exported "PERFSTAT"."STATS$ROLLSTAT" 1.810 MB 23798 rows
 . . exported "PERFSTAT"."STATS$SEG_STAT" 90.69 KB 1275 rows
 . . exported "PERFSTAT"."STATS$IOSTAT_FUNCTION" 1.534 MB 28980 rows
 . . exported "PERFSTAT"."STATS$MEMORY_RESIZE_OPS" 1.439 MB 13093 rows
 . . exported "PERFSTAT"."STATS$MEMORY_TARGET_ADVICE" 1.077 MB 28955 rows
 . . exported "PERFSTAT"."STATS$PGASTAT" 1.659 MB 35128 rows
 . . exported "PERFSTAT"."STATS$PGA_TARGET_ADVICE" 1.696 MB 28980 rows
 . . exported "PERFSTAT"."STATS$SGASTAT" 1.492 MB 33279 rows
 . . exported "PERFSTAT"."STATS$SGA_TARGET_ADVICE" 1.297 MB 31028 rows
 . . exported "PERFSTAT"."STATS$SQL_WORKAREA_HISTOGRAM" 1.654 MB 39590 rows
 . . exported "PERFSTAT"."STATS$STREAMS_POOL_ADVICE" 1.318 MB 41400 rows
 . . exported "PERFSTAT"."STATS$SYS_TIME_MODEL" 1.213 MB 39330 rows
 . . exported "PERFSTAT"."STATS$UNDOSTAT" 1.249 MB 12945 rows
 . . exported "PERFSTAT"."STATS$WAITSTAT" 1.350 MB 37260 rows
 . . exported "PERFSTAT"."STATS$BUFFERED_QUEUES" 8.226 KB 0 rows
 . . exported "PERFSTAT"."STATS$BUFFERED_SUBSCRIBERS" 9.890 KB 0 rows
 . . exported "PERFSTAT"."STATS$BUFFER_POOL_STATISTICS" 262.8 KB 2070 rows
 . . exported "PERFSTAT"."STATS$CR_BLOCK_SERVER" 13.55 KB 0 rows
 . . exported "PERFSTAT"."STATS$CURRENT_BLOCK_SERVER" 11.83 KB 0 rows
 . . exported "PERFSTAT"."STATS$DATABASE_INSTANCE" 9.195 KB 6 rows
 . . exported "PERFSTAT"."STATS$DLM_MISC" 7.007 KB 0 rows
 . . exported "PERFSTAT"."STATS$DYNAMIC_REMASTER_STATS" 11.11 KB 0 rows
 . . exported "PERFSTAT"."STATS$IDLE_EVENT" 8.960 KB 135 rows
 . . exported "PERFSTAT"."STATS$INSTANCE_CACHE_TRANSFER" 9.046 KB 0 rows
 . . exported "PERFSTAT"."STATS$INSTANCE_RECOVERY" 120.9 KB 2070 rows
 . . exported "PERFSTAT"."STATS$INTERCONNECT_PINGS" 8.625 KB 0 rows
 . . exported "PERFSTAT"."STATS$IOSTAT_FUNCTION_NAME" 5.664 KB 14 rows
 . . exported "PERFSTAT"."STATS$JAVA_POOL_ADVICE" 864.8 KB 20762 rows
 . . exported "PERFSTAT"."STATS$LATCH_CHILDREN" 11.02 KB 0 rows
 . . exported "PERFSTAT"."STATS$LATCH_PARENT" 11.02 KB 0 rows
 . . exported "PERFSTAT"."STATS$LEVEL_DESCRIPTION" 6.195 KB 5 rows
 . . exported "PERFSTAT"."STATS$OSSTAT" 712.7 KB 26910 rows
 . . exported "PERFSTAT"."STATS$OSSTATNAME" 6.140 KB 13 rows
 . . exported "PERFSTAT"."STATS$PROPAGATION_RECEIVER" 9.507 KB 0 rows
 . . exported "PERFSTAT"."STATS$PROPAGATION_SENDER" 10.31 KB 0 rows
 . . exported "PERFSTAT"."STATS$RESOURCE_LIMIT" 505.7 KB 8280 rows
 . . exported "PERFSTAT"."STATS$RULE_SET" 130.6 KB 2070 rows
 . . exported "PERFSTAT"."STATS$SEG_STAT_OBJ" 70.94 KB 1137 rows
 . . exported "PERFSTAT"."STATS$SESSION_EVENT" 7.828 KB 0 rows
 . . exported "PERFSTAT"."STATS$SESSTAT" 6.609 KB 0 rows
 . . exported "PERFSTAT"."STATS$SESS_TIME_MODEL" 6.609 KB 0 rows
 . . exported "PERFSTAT"."STATS$SGA" 319.8 KB 8280 rows
 . . exported "PERFSTAT"."STATS$SNAPSHOT" 210.3 KB 2070 rows
 . . exported "PERFSTAT"."STATS$SQL_STATISTICS" 95.07 KB 2070 rows
 . . exported "PERFSTAT"."STATS$STATSPACK_PARAMETER" 14.48 KB 1 rows
 . . exported "PERFSTAT"."STATS$STREAMS_APPLY_SUM" 11.22 KB 0 rows
 . . exported "PERFSTAT"."STATS$STREAMS_CAPTURE" 9.921 KB 0 rows
 . . exported "PERFSTAT"."STATS$TEMPSTATXS" 237.0 KB 2070 rows
 . . exported "PERFSTAT"."STATS$THREAD" 99.87 KB 2070 rows
 . . exported "PERFSTAT"."STATS$TIME_MODEL_STATNAME" 6.156 KB 19 rows
 Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
 ******************************************************************************
 Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
 D:\E910\ORCL\CTL\PERFSTAT.DMP
 Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Jan 14 14:45:07 2016 elapsed 0 00:00:51

spuexp.par

#
 # $Header: spuexp.par 16-feb-00.16:50:53 cdialeri Exp $
 #
 # spuexp.sql
 #
 # Copyright (c) Oracle Corporation 1999, 2000. All Rights Reserved.
 #
 # NAME
 # spuexp.par
 #
 # DESCRIPTION
 # Export parameter file used to export the whole STATSPACK user.
 #
 # NOTES
 # Must be run as the STATSPACK owner, PERFSTAT
 #
 # MODIFIED (MM/DD/YY)
 # cdialeri 02/16/00 - 1191805
 # cdialeri 08/13/99 - Created for heri
 #
 file=spuexp.dmp log=spuexp.log compress=y grants=y indexes=y rows=y constraints=y owner=PERFSTAT consistent=y

Komentáře

Kontakt

Zanechte mi telefon nebo e-mail a spojíme se!

databázový administrátor, konzultant a školitel

Tomáš Solař

+420 731 196 647
tom@tomas-solar.com