ARCHIVELOG
Check
Check
SELECT log_mode
FROM v$database;
Enable
Enable
Stop Client Applications
Stop Listener
sqlplus / as sysdba
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
Start Listener
Start Client Application
Disable
Disable
Stop Client Applications
Stop Listener
sqlplus / as sysdba
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE OPEN;
Start Listener
Start Client Applications