How to turn off redo log

[LeonardoAraujo]

I am running ERP 2005 on a test box (really a simple sandbox for testing).

I don't care about redo logs. I am fine with my offline backups.

I need to increase the performance and I was wondering how to turn off the redo logs.

Could you please provide a hint on how to do it? If there is a way to do it from SAP I would prefer...

Thanks in advance,

Leonardo De Araujo

p.s. Running on Windows

[vince_laurent · Accepted solution]

<a href="http://www.adp-gmbh.ch/ora/admin/backup_recovery/archive_vs_noarchive_log.html">http://www.adp-gmbh.ch/ora/admin/backup_recovery/archive_vs_noarchive_log.html</a>

[Former Member]

Hi,

Actually the redo log files cant be turned off.The archived log can be turned off . What happens by turning off the archive log i,e in noarchivelog mode, the containts of the redo log files are not written to the archive log files instead the redologfile get over written.

To do this u can follow the steps suggested above by Mindaugas Vaitkus

[Former Member]

All the options need restart for short time..

Regards

madhu

[Former Member]

archive_off.bat should do the job.

Peter

[Former Member]

sqlplus /nolog

connect/as sysdba

1. shutdown database

2. startup mount

3. ALTER DATABSE ARCHIVELOG (noarchivelog);

4. ALTER DATABASE OPEN;

5. ARCHIVE LOG LIST;

Mindaugas

[Former Member]

Hi

Use brttols there you will get option to turn off archiving

Thanks

Prince