Switch oracle database from archivelog into noarchivelog

* Trademark : ORACLE® is a registered trademark of ORACLE Corporation.

Dear Blog,

Hari ini saya berkesempatan share untuk setting log mode pada database oracle yang ada di portable Ides SAP ku. Sebagai catatan, setting ini saya lakukan di OS Windows via CMD.

Oracle Logo

Berikut merupakan langkah-langkah mengubah db oracle  dari archivelog menjadi noarchivelog. ( This is the step how to switch oracle database from archivelog into noarchivelog. )
1. Buka CMD, Login ke sqlplus melalui command berikut. (Open Command Prompt then login to SQL Plus)
-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;

Selesai.. akhirnya database saya sudah di setting noarchivelog. 🙂

0 Responses to “Switch oracle database from archivelog into noarchivelog”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

My Archives


%d bloggers like this: