Time for action – changing the redo transport user

Follow these steps to change the redo transport user in the Data Guard configuration:

1. 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;
   

   Tip

   Don't forget that if the password expires periodically for this user, this will pose a problem in Data Guard redo transport. So ensure that the default profile does not include the PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME settings. If it does, choose another profile for this user.

2. Stop the redo transport from the primary database to the standby databases. We can execute the DEFER command to defer the log destination with the ALTER SYSTEM statement:

   SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = 'DEFER';
   

3. Change the redo transport user by setting the REDO_TRANSPORT_ USER...