change SYS password in DataGuard environment
We have a situation here.
We need change our password for SYS every 30days. However this is a DataGuard environment, the changing password will make archivelog transporation failed. And we have to stop DataGuard, and shutdown both Primary/Standby database to do it.
Is there anyway, we can change the SYS password without shutdown primary database?
Thanks,