[SAP BASIS] - How to Setting Log Mode Oracle Database in SAP


Article/Tutorial Switching from archivelog to noarchivelog
Support
Contributor
Ervan Prayogo ( ervan.prayogo@gmail.com )
This is the step how to switch oracle database from archivelog into noarchivelog.
1. Login to sqlplus.
-sqlplus /nolog
-connect / as sysdba
bst311
2. Check the database log mode.
-archive log list
bst312
3. Database must be mounted EXCLUSIVE and not open for alter database operation. Shutdown the database and mount it.
-shutdown immediate
bst313
-startup mount;
bst314
4. Setting it to noarchivelog mode
-alter database noarchivelog;
bst315
5. Setting database open for user operation
-alter database open;
bst316



Comments