Oracle: Disable ArchiveLog Mode

Sometimes it is unnecessary to use ArchiveLog mode with the Oracle database. If you do not know what ArchiveLog Mode is – here is a short statement:

“Any Oracle database that contains important data should be running in ARCHIVELOG mode. Running in Archive log mode enables you to take hot backups and perform point-in-time recovery.”
So if you do not want this feature you can disable it following these steps:

- Login to your server as oracle user
- start sqlplus as sysdba
sqlplus “/ as sysdba”
- run the following commands
shutdown abort
startup mount
alter database noarchivelog;
alter database open;
- to test if you where successful just run the query:
select name, log_mode from v$database;

Remember that once you disable archive log mode you need to take a fresh backup once archive log mode is turned back on.
Be aware that if a disk failure occurs while in NOARCHIVELOG mode, you can only restore the database to the point of the most recent full database backup.
To switch back from archivelog to noarchivelog mode, just repeat the relevant steps above specifying: ALTER DATABASE NOARCHIVELOG;

For RAC environments, read the following link:

Related Posts

Eclipse: convert upper case text to lower case and viceversa with a simple shortcut


November 7, 2012

Development, Java

No Comment

This is just a quick post to share these 2 little shortcuts to convert text from lower case to uppercase and vice-versa in Eclipse. Lower case: CTRL+SHIFT+Y (CMD+SHIFT+Y on Mac OS X) Upper case: CTRL+SHIFT+X (CMD+SHIFT+X on Mac OS X) Camel case: Anyone knows a shortcut? You can select one or more characters to convert.

Read More

OpenERP: Connect Kettle to OpenERP

[1] [2] [3] [4] [5] [6]

Read More

Leave a Reply