Disable Archive Log
1 min read

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. Total System Global Area 1577055400 bytes Fixed Size 9135272 bytes Variable Size 939524096 bytes Database Buffers 620756992 bytes Redo Buffers 7639040 bytes Database mounted. SQL>
Disable archivelog:
SQL> alter database noarchivelog; Database altered.
Open database:
SQL> alter database open; Database altered.
0
Subscribe to my newsletter
Read articles from Martyn Rangel Figueiredo directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Archive LogOracle LinuxOracle DatabaseOracle Database 19cOracle Database 19c - Performance Management and TuningOCI
Written by