ORACLE - Temporal change in archivelog mode

I n开发者_StackOverfloweed to change temporarly (in order to run a proccess) the archiving mode to noarchivelog. After switching back to archivelog, do I need to open the database with resetlogs option?

Resetlogs is not required. You can turn Archive Mode on and off at will, just be aware that any log switches that occur during while it is off will mean you will have gaps in logs saved on disk.

This means you may be sacrificing recoverability. After turning Archive Mode back ON I would perform a full backup.

After running in noarchivelog mode, your archive logs are not usable anymore. Therefore you need to reset after opening again. Remember to take a backup before and after the operation.

You may be able to get away with using NOLOGGING on objects without requiring to restart to set NOARCHIVELOG mode.