<< Click to Display Table of Contents >> Navigation:  All About BASIS Technique > Tips and Tricks > How to Setting Log Mode Oracle Database in SAP > Switching from archivelog to noarchivelog

 

This is the step how to switch oracle database from archivelog into noarchivelog.

 

1. Login to sqlplus.

-sqlplus /nolog

-connect / as sysdba

 

2. Check the database log mode.

-archive log list

 

3. Database must be mounted EXCLUSIVE and not open for alter database operation. Shutdown the database and mount it.

-shutdown immediate

  -startup mount;

 

4. Setting it to noarchivelog mode

-alter database noarchivelog;

 

5. Setting database open for user operation

-alter database open;