Follow these steps to change the redo transport user in the Data Guard configuration:
Create a new database, which will be used for redo transport in the primary database. Grant the
SYSOPER
privileges to this user and ensure that the standby database has applied these changes:SQL> CREATE USER DGUSER IDENTIFIED BY SOMEPASSWORD; SQL> GRANT SYSOPER to DGUSER;
Stop the redo transport from the primary database to the standby databases. We can execute the
DEFER
command to defer the log destination with theALTER SYSTEM
statement:SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = 'DEFER';
Change the redo transport user by setting the
REDO_TRANSPORT_ USER
...