[oracle@belstat-sdb02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 14 09:49:54 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 — 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP NOMOUNT;
ORACLE instance started.
Total System Global Area 2.0200E+10 bytes
Fixed Size 5294088 bytes
Variable Size 2952792056 bytes
Database Buffers 1.7180E+10 bytes
Redo Buffers 61812736 bytes
SQL> ALTER DATABASE MOUNT;
Database altered.
SQL> ALTER DATABASE NOARCHIVELOG;
Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> SELECT name, log_mode FROM v$database;
NAME LOG_MODE
——— ————
EISGS03 NOARCHIVELOG