Oracle Data Guard 11gR2 Administration Beginner's Guide

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