Hello there,
Can anyone please confirm if there be any impact if we change ARCHIVELOG mode from default NOARCHIVELOG mode of oracle database (remote DB).
Also if we use Oracle's inbuilt 3 redo logs instead of RSA recommended# 6 redo logs, will there be any impact ?
Thanks, Amit
You will be fine in ARCHIVELOG mode (provided you manage retention as part of a backup strategy and don't let the archive logs fill all available disk space).
I don't think the number of redo log groups matters, only the total size allocated.
If your volume of data is not huge you don't necessarily need the 6x800 MB prescribed in the official documentation.
However the default 3x50 MB is clearly not enough. The impact would be transactions failing during data collections, errors reported and inconsistent results.