Tom Lieberyaitcon.hashnode.dev·May 4, 2024Flashback Data ArchiveExport as DDL: via dbms_metadata Oracle 19c. SE CREATE TABLE "TEST" ("TEST" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 43277 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE , "MA...Discuss·35 readsTL:DR;Oracle
Martyn Rangel Figueiredotuneyourdatabase.hashnode.dev·Feb 6, 2024Disable Archive LogCheck Status and Parameters. Shutdown and startup mount (!Caution). [oracle@orcl ~]$ sqlplus / as sysdba SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. ...DiscussArchive LogArchive Log
Martyn Rangel Figueiredotuneyourdatabase.hashnode.dev·Feb 5, 2024Basic ADRCI CommandsGet and Set ADR_BASE location. [oracle@orcl ~]$ adrci ADRCI: Release 19.0.0.0.0 - Production on Tue Aug 8 15:08:45 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show bas...DiscussAutomatic Diagnostic Repository (ADR)adrci
Martyn Rangel Figueiredotuneyourdatabase.hashnode.dev·Feb 5, 2024Purging alerts with ADRCIPurge Alerts older than 1 month (44640 minutes). adrci> purge -age 44640 -type ALERT Purge Trace Files older than 1 month (44640 minutes). adrci> purge -age 44640 -type TRACE Purge Incidents older than 1 month (44640 minutes). adrci> purge -ag...DiscussAutomatic Diagnostic Repository (ADR)adrci
