Details für Autonomous Database on Dedicated Exadata Infrastructure

Ressourcen

• Autonome Containerdatenbank
• Autonomous Database

Logkategorien

Verfügbarkeit

Das Logging von Autonomous Database on Dedicated Exadata Infrastructure ist in allen Regionen der kommerziellen Realms verfügbar.

Inhalt eines Datenbanklogs

Inhalt eines Migrationsprotokolls

Beispiellog für autonome Containerdatenbank

Domain Action Reconfiguration complete (total time 0.0 secs)
Decreasing priority of 2 RS
2025-02-07T00:48:08.511875+00:00
PAASSEED(3):Endian type of dictionary set to little
PAASSEED(3):Undo initialization finished serial:0 start:1007380729 end:1007380729 diff:0 ms (0.0 seconds)
PAASSEED(3):Database Characterset for PAASSEED is AL32UTF8
2025-02-07T00:48:09.337531+00:00
PAASSEED(3):SUPLOG: Set PDB SUPLOG SGA at PDB OPEN, old 0x18, new 0x0 (no suplog)
PAASSEED(3):Container IM quota 1 is larger than ROOT IM size 0
PAASSEED(3):Container IM quota reduced to match ROOT IM size
2025-02-07T00:48:09.851997+00:00
PAASSEED(3):Opening pdb with Resource Manager plan: PAAS_PLAN
Completed: Pluggable database PAASSEED opened read only
2025-02-07T00:48:14.714923+00:00
Increasing priority of 2 RS
2025-02-07T00:48:14.715185+00:00
Domain Action Reconfiguration started (domid 3, new da inc 144, cluster inc 6)
Instance 1 is detaching from domain 3 (lazy abort? 0, recovery member? 0)
Global Resource Directory partially frozen for domain action
* domain detach - domain 3 valid ? 1
Non-local Process blocks cleaned out
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Domain Action Reconfiguration complete (total time 0.1 secs)
Decreasing priority of 2 RS
2025-02-07T00:48:15.140422+00:00
PAASSEED(3):Errors in file /u02/app/oracle/diag/rdbms/csbvcbpc_zrh1f/csbvcbpc3/trace/csbvcbpc3_imco_191892.trc:
ORA-12805: parallel query server died unexpectedly
2025-02-07T00:48:16.073660+00:00
Increasing priority of 2 RS
2025-02-07T00:48:16.074107+00:00
Domain Action Reconfiguration started (domid 3, new da inc 145, cluster inc 6)
Instance 2 is detaching from domain 3 (lazy abort? 0, recovery member? 0)
Global Resource Directory partially frozen for domain action
* domain detach - domain 3 valid ? 1
Non-local Process blocks cleaned out
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Domain Action Reconfiguration complete (total time 0.1 secs)
Decreasing priority of 2 RS
2025-02-07T00:48:16.251608+00:00
PAASSEED(3):Pluggable database PAASSEED closing
PAASSEED(3):Increasing priority of 2 RS
PAASSEED(3):JIT: pid 6762 requesting stop
PAASSEED(3):Buffer Cache flush started: 3
PAASSEED(3):Buffer Cache flush finished: 3
PAASSEED(3):queued detach DA request 0x55de32f38 for pdb 3, ospid 6762
2025-02-07T00:48:16.625013+00:00
Domain Action Reconfiguration started (domid 3, new da inc 146, cluster inc 6)
Instance 3 is detaching from domain 3 (lazy abort? 0, recovery member? 0)
Global Resource Directory partially frozen for domain action
* domain detach - domain 3 valid ? 1
Non-local Process blocks cleaned out
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
freeing rdom 3
freeing the fusion rht of pdb 3
freeing the pdb enqueue rht
Domain Action Reconfiguration complete (total time 0.1 secs)
Decreasing priority of 2 RS
2025-02-07T00:48:16.746100+00:00
Completed: Pluggable database PAASSEED closed
2025-02-07T00:48:19.744542+00:00
Restarting dead background process IMCO
Starting background process IMCO
2025-02-07T00:48:19.777053+00:00
IMCO started with pid=106, OS id=206242
2025-02-07T00:48:21.999585+00:00
freeing rdom 3
2025-02-07T00:48:22.135592+00:00
Pluggable database PAASSEED(con_id=3) is already in desired state
2025-02-07T00:48:26.367852+00:00
PAASSEED(3):Pluggable database PAASSEED opening in read only
PAASSEED(3):Increasing priority of 2 RS
PAASSEED(3):SUPLOG: Initialize PDB SUPLOG SGA, old value 0x0, new value 0x18
PAASSEED(3):Autotune of undo retention is turned on.
PAASSEED(3):queued attach DA request 0x55de32ed0 for pdb 3, ospid 6762
2025-02-07T00:48:26.659644+00:00
Domain Action Reconfiguration started (domid 3, new da inc 151, cluster inc 6)
Instance 3 is attaching to domain 3
Global Resource Directory partially frozen for domain action
Non-local Process blocks cleaned out
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Domain Action Reconfiguration complete (total time 0.1 secs)
Decreasing priority of 2 RS
2025-02-07T00:48:26.786897+00:00
PAASSEED(3):Endian type of dictionary set to little
PAASSEED(3):Undo initialization finished serial:0 start:1007399069 end:1007399069 diff:0 ms (0.0 seconds)
PAASSEED(3):Database Characterset for PAASSEED is AL32UTF8
2025-02-07T00:48:27.592834+00:00
PAASSEED(3):SUPLOG: Set PDB SUPLOG SGA at PDB OPEN, old 0x18, new 0x0 (no suplog)
PAASSEED(3):Container IM quota 1 is larger than ROOT IM size 0
PAASSEED(3):Container IM quota reduced to match ROOT IM size
2025-02-07T00:48:28.176618+00:00
PAASSEED(3):Opening pdb with Resource Manager plan: PAAS_PLAN
Completed: Pluggable database PAASSEED opened read only
2025-02-07T00:48:28.692535+00:00
PDB$SEED(2):Pluggable database PDB$SEED closing
PDB$SEED(2):Increasing priority of 2 RS
PDB$SEED(2):JIT: pid 6762 requesting stop
2025-02-07T00:48:29.095764+00:00
Domain Action Reconfiguration started (domid 2, new da inc 140, cluster inc 6)
Instance 2 is detaching from domain 2 (lazy abort? 0, recovery member? 0)
2025-02-07T00:48:29.101375+00:00
PDB$SEED(2):Buffer Cache flush started: 2
2025-02-07T00:48:29.106713+00:00
Global Resource Directory partially frozen for domain action
* domain detach - domain 2 valid ? 1
Non-local Process blocks cleaned out
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
2025-02-07T00:48:29.163617+00:00
PDB$SEED(2):Buffer Cache flush finished: 2
2025-02-07T00:48:29.190185+00:00
PDB$SEED(2):queued detach DA request 0x55de32e68 for pdb 2, ospid 6762
2025-02-07T00:48:29.190185+00:00
Domain Action Reconfiguration complete (total time 0.1 secs)
2025-02-07T00:48:29.227081+00:00
Domain Action Reconfiguration started (domid 2, new da inc 141, cluster inc 6)
Instance 3 is detaching from domain 2 (lazy abort? 0, recovery member? 0)
Global Resource Directory partially frozen for domain action
* domain detach - domain 2 valid ? 1
Non-local Process blocks cleaned out
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
freeing the fusion rht of pdb 2
freeing the pdb enqueue rht
Domain Action Reconfiguration complete (total time 0.1 secs)
Decreasing priority of 2 RS
2025-02-07T00:48:29.364655+00:00
freeing rdom 2
2025-02-07T00:48:29.398476+00:00
Completed: Pluggable database PDB$SEED closed
2025-02-07T00:48:32.611057+00:00
Pluggable database PDB$SEED(con_id=2) is already in desired state
2025-02-07T00:48:33.496777+00:00
freeing rdom 2
2025-02-07T00:48:33.575214+00:00
PDB$SEED(2):Pluggable database PDB$SEED opening in read only
2025-02-07T00:48:33.869858+00:00
PDB$SEED(2):Autotune of undo retention is turned on.
PDB$SEED(2):queued attach DA request 0x55de32e00 for pdb 2, ospid 6762
2025-02-07T00:48:34.078528+00:00
Increasing priority of 2 RS
Domain Action Reconfiguration started (domid 2, new da inc 147, cluster inc 6)
Instance 3 is attaching to domain 2
Global Resource Directory partially frozen for domain action
Non-local Process blocks cleaned out
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Domain Action Reconfiguration complete (total time 0.0 secs)
Decreasing priority of 2 RS
2025-02-07T00:48:34.139646+00:00
PDB$SEED(2):Endian type of dictionary set to little
PDB$SEED(2):Undo initialization finished serial:0 start:1007406365 end:1007406365 diff:0 ms (0.0 seconds)
PDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8
PDB$SEED(2):Container IM quota 1 is larger than ROOT IM size 0
PDB$SEED(2):Container IM quota reduced to match ROOT IM size
2025-02-07T00:48:35.134095+00:00
PDB$SEED(2):Opening pdb with no Resource Manager plan active
Completed: Pluggable database PDB$SEED opened read only
2025-02-07T22:00:27.750701+00:00
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2025-02-07T22:00:33.153421+00:00
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2025-02-08T00:50:33.126733+00:00
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1825 (45695) VALUES LESS THAN (TO_DATE(' 2025-02-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1828 (45695) VALUES LESS THAN (TO_DATE(' 2025-02-09 00:00:00', 'SYYYY-MM-DDHH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2025-02-08T06:00:27.434952+00:00
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2025-02-08T06:00:30.389495+00:00
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2025-02-09T00:49:53.407861+00:00
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1829 (45696) VALUES LESS THAN (TO_DATE(' 2025-02-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1832 (45696) VALUES LESS THAN (TO_DATE(' 2025-02-10 00:00:00', 'SYYYY-MM-DDHH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2025-02-09T06:00:25.926705+00:00
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2025-02-09T06:00:30.976838+00:00
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2025-02-09T09:10:09.144452+00:00
Resize operation completed for file# 3, fname +DATAC8/CSBVCBPC_ZRH1F/DATAFILE/sysaux.290.1184497491, old size 157237248K, new size 161431552K
2025-02-09T13:46:28.550278+00:00
Thread 3 advanced to log sequence 20 (LGWR switch), current SCN: 176774303
Current log# 8 seq# 20 mem# 0: +DATAC8/CSBVCBPC_ZRH1F/ONLINELOG/group_8.288.1184496901
2025-02-09T13:46:59.722073+00:00
ARC3 (PID:6338): Archived Log entry 68 added for B-1184496747.T-3.S-19 LOS:0x0000000009cc1c59 NXS:0x000000000a895c9f NAB:14627695 ID 0x3de4fca1 LAD:1[krse.c:4565]
2025-02-10T22:00:25.751583+00:00
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2025-02-10T22:00:37.918631+00:00
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"

Beispiel für ein Autonomous Database-Migrationslog

;;;
Export: Release 19.0.0.0.0 - Production on Wed Aug 28 02:43:50 2024
Version 19.23.0.1.0
Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Starting "ADMIN"."SYS_EXPORT_SCHEMA_01": admin/********@slcqab02vm03-scan1:1521/
pdb062412_low.atp.oraclecloud.com
schemas=test logfile=Pallab.Rath
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/USER
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/PASSWORD_HISTORY
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
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/VIEW/VIEW
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported "TEST"."T100" 10.65 MB 80991 rows
. . exported "TEST"."T99" 10.65 MB 80990 rows
. . exported "TEST"."T98" 10.65 MB 80989 rows
. . exported "TEST"."T97" 10.65 MB 80988 rows
. . exported "TEST"."T96" 10.65 MB 80987 rows
. . exported "TEST"."T95" 10.65 MB 80986 rows
. . exported "TEST"."T94" 10.65 MB 80985 rows
. . exported "TEST"."T93" 10.65 MB 80984 rows
. . exported "TEST"."T92" 10.65 MB 80983 rows
. . exported "TEST"."T91" 10.65 MB 80982 rows
. . exported "TEST"."T90" 10.65 MB 80981 rows
. . exported "TEST"."T89" 10.65 MB 80980 rows
. . exported "TEST"."T88" 10.65 MB 80979 rows
. . exported "TEST"."T87" 10.65 MB 80978 rows
. . exported "TEST"."T86" 10.65 MB 80977 rows
. . exported "TEST"."T85" 10.65 MB 80976 rows
. . exported "TEST"."T84" 10.65 MB 80975 rows
. . exported "TEST"."T83" 10.65 MB 80974 rows
. . exported "TEST"."T82" 10.65 MB 80973 rows
. . exported "TEST"."T81" 10.65 MB 80972 rows
. . exported "TEST"."T80" 10.65 MB 80971 rows
. . exported "TEST"."T79" 10.65 MB 80970 rows
. . exported "TEST"."T78" 10.65 MB 80969 rows
. . exported "TEST"."T77" 10.65 MB 80968 rows
. . exported "TEST"."T76" 10.65 MB 80967 rows
. . exported "TEST"."T75" 10.65 MB 80966 rows
. . exported "TEST"."T74" 10.65 MB 80965 rows
. . exported "TEST"."T73" 10.65 MB 80964 rows
. . exported "TEST"."T72" 10.65 MB 80963 rows
. . exported "TEST"."T71" 10.65 MB 80962 rows
. . exported "TEST"."T70" 10.64 MB 80961 rows
. . exported "TEST"."T69" 10.64 MB 80960 rows
. . exported "TEST"."T68" 10.64 MB 80959 rows
. . exported "TEST"."T67" 10.64 MB 80958 rows
. . exported "TEST"."T66" 10.64 MB 80957 rows
. . exported "TEST"."T65" 10.64 MB 80956 rows
. . exported "TEST"."T64" 10.64 MB 80955 rows
. . exported "TEST"."T63" 10.64 MB 80954 rows
. . exported "TEST"."T62" 10.64 MB 80953 rows
. . exported "TEST"."T61" 10.64 MB 80952 rows
. . exported "TEST"."T60" 10.64 MB 80951 rows
. . exported "TEST"."T59" 10.64 MB 80950 rows
. . exported "TEST"."T58" 10.64 MB 80949 rows
. . exported "TEST"."T57" 10.64 MB 80948 rows
. . exported "TEST"."T56" 10.64 MB 80947 rows
. . exported "TEST"."T55" 10.64 MB 80946 rows
. . exported "TEST"."T54" 10.64 MB 80945 rows
. . exported "TEST"."T53" 10.64 MB 80944 rows
. . exported "TEST"."T52" 10.64 MB 80943 rows
. . exported "TEST"."T51" 10.64 MB 80942 rows
. . exported "TEST"."T50" 10.64 MB 80941 rows
. . exported "TEST"."T49" 10.64 MB 80940 rows
. . exported "TEST"."T48" 10.64 MB 80939 rows
. . exported "TEST"."T47" 10.64 MB 80938 rows
. . exported "TEST"."T46" 10.64 MB 80937 rows
. . exported "TEST"."T45" 10.64 MB 80936 rows
. . exported "TEST"."T44" 10.64 MB 80935 rows
. . exported "TEST"."T43" 10.64 MB 80934 rows
. . exported "TEST"."T42" 10.64 MB 80933 rows
. . exported "TEST"."T41" 10.64 MB 80932 rows
. . exported "TEST"."T40" 10.64 MB 80931 rows
. . exported "TEST"."T39" 10.64 MB 80930 rows
. . exported "TEST"."T38" 10.64 MB 80929 rows
. . exported "TEST"."T37" 10.64 MB 80928 rows
. . exported "TEST"."T36" 10.64 MB 80927 rows
. . exported "TEST"."T35" 10.64 MB 80926 rows
. . exported "TEST"."T34" 10.64 MB 80925 rows
. . exported "TEST"."T32" 10.64 MB 80923 rows
. . exported "TEST"."T31" 10.64 MB 80922 rows
. . exported "TEST"."T30" 10.64 MB 80921 rows
. . exported "TEST"."T29" 10.64 MB 80920 rows
. . exported "TEST"."T28" 10.64 MB 80919 rows
. . exported "TEST"."T27" 10.64 MB 80918 rows
. . exported "TEST"."T26" 10.64 MB 80917 rows
. . exported "TEST"."T25" 10.64 MB 80916 rows
. . exported "TEST"."T24" 10.64 MB 80915 rows
. . exported "TEST"."T23" 10.64 MB 80914 rows
. . exported "TEST"."T22" 10.64 MB 80913 rows
. . exported "TEST"."T21" 10.64 MB 80912 rows
. . exported "TEST"."T20" 10.64 MB 80911 rows
. . exported "TEST"."T19" 10.64 MB 80910 rows
. . exported "TEST"."T18" 10.64 MB 80909 rows
. . exported "TEST"."T17" 10.64 MB 80908 rows
. . exported "TEST"."T16" 10.64 MB 80907 rows
. . exported "TEST"."T15" 10.64 MB 80906 rows
. . exported "TEST"."T14" 10.64 MB 80905 rows
. . exported "TEST"."T13" 10.64 MB 80904 rows
. . exported "TEST"."T12" 10.64 MB 80903 rows
. . exported "TEST"."T11" 10.64 MB 80902 rows
. . exported "TEST"."T10" 10.64 MB 80901 rows
. . exported "TEST"."T9" 10.64 MB 80900 rows
. . exported "TEST"."T8" 10.64 MB 80899 rows
. . exported "TEST"."T7" 10.64 MB 80898 rows
. . exported "TEST"."T6" 10.64 MB 80897 rows
. . exported "TEST"."T5" 10.64 MB 80896 rows
. . exported "TEST"."T4" 10.64 MB 80895 rows
. . exported "TEST"."T3" 10.64 MB 80894 rows
. . exported "TEST"."T2" 10.64 MB 80893 rows
. . exported "TEST"."T1" 10.64 MB 80892 rows
ORA-39173: Encrypted data has been stored unencrypted in dump file set.
Master table "ADMIN"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for ADMIN.SYS_EXPORT_SCHEMA_01 is:
/u02/data/dbfs/db06241/198393EA39FB35A6E0634958F90A9D24/expdat.dmp
Job "ADMIN"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Aug 28 02:45:23 2024 elapsed 0 00:01:30