I have no idea why he suggested that.
log_archive_dest_n parameter is modifiable, so if you want the change takes effect immediately and persists after the database shutdown and start up you must use scope=both
scope=spfile will be used for static parameters. changes will effect after shutdown and start up the database only.
Thanks,




Reply With Quote