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;

LOG_MODE
------------
NOARCHIVELOG

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

Reactions:

1 comments:

Thanks for sharing this Information, Got to learn new things from your Blog on SAP SD.
http://thecreatingexperts.com/sap-sd-training-in-chennai/

Post a Comment