Sunday, January 19, 2014

Steps to Change ARCHIVELOG to NOARCHIVELOG in oracle database

Change ARCHIVELOG  to NOARCHIVELOG in oracle database

1. Login as ORA<SID>
2. sqlplus "/as sysdba"
3. select log_mode from v$database; - check if value is still as below:
4. Stop SAP (CI and Apps) and Database using scripts.
5. SQL> startup mount;
6. SQL> alter database noarchivelog;
7. SQL> alter database open;
8. SQL> select log_mode from v$database;


9. Restart the system from Apps -> CI -> DB using scripts.
10. Perform health check.



Thanks for sharing this Information, Got to learn new things from your Blog on SAP SD.

Post a Comment