@martynfigueiredo

Martyn Rangel Figueiredo

@martynfigueiredo

Website

Oracle Database Administrator Certified Professional 19c | PL/SQL | MCP Microsoft SQL Server | ITIL

RemoteJoined February 2024

About

Nothing here yet.

Available for

Nothing here yet.

Martyn Rangel Figueiredo's blogs

Exadata Administratortuneyourdatabase.com5 posts

Articles Comments

Recently published

MRMartyn Rangel Figueiredotuneyourdatabase.comFeb 7, 2024 · 1 min read

Enable Archive Log

Connect as DBA. [oracle@orcl ~]$ sql / as sysdba Disconnect all users. Shutdown and startup mount (!Caution). SQL> SHTDOWN IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP MOUNT ORACLE instance star...

MRMartyn Rangel Figueiredotuneyourdatabase.comFeb 6, 2024 · 1 min read

Disable Archive Log

Check 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. ...

MRMartyn Rangel Figueiredotuneyourdatabase.comFeb 5, 2024 · 1 min read

Basic ADRCI Commands

Get 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...

MRMartyn Rangel Figueiredotuneyourdatabase.comFeb 5, 2024 · 1 min read

Purging alerts with ADRCI

Purge 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...

MRMartyn Rangel Figueiredotuneyourdatabase.comFeb 5, 2024 · 2 min read

Viewing Alert Logs from ADRCI

Show Real Time log. [oracle@orcl ~]$ adrci ADRCI: Release 19.0.0.0.0 - Production on Tue Aug 8 15:10:27 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show alert -tail -f...

Martyn Rangel Figueiredo

About

Available for

Martyn Rangel Figueiredo's blogs

Recently published

Enable Archive Log

Disable Archive Log

Basic ADRCI Commands

Purging alerts with ADRCI

Viewing Alert Logs from ADRCI

Search Hashnode

Martyn Rangel Figueiredo

About

Available for

Martyn Rangel Figueiredo's blogs

Recently published

Enable Archive Log

Disable Archive Log

Basic ADRCI Commands

Purging alerts with ADRCI

Viewing Alert Logs from ADRCI