ALTER DATABASE NO FORCE LOGGING; select FORCE_LOGGING from v$database;
{}
ARCHIVE LOG LIST SHUTDOWN IMMEDIATE STARTUP MOUNT ALTER DATABASE NOARCHIVELOG; ALTER DATABASE OPEN; SELECT log_mode FROM v$database;