Details for Autonomous Database on Dedicated Exadata Infrastructure

Resources 🔗

• Autonomous Container Database
• Autonomous Database

Log Categories 🔗

Availability 🔗

Autonomous Database on Dedicated Exadata Infrastructure logging is available in all the regions of the commercial realms.

Contents of a Database Log 🔗

Contents of a Migration Log

Example Autonomous Container Database Log 🔗

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"

Example Autonomous Database Migration Log 🔗

;;;
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