Time for action – changing the SYS password in a Data Guard environment
The way to change the SYS
password without breaking the redo transport service includes copying the primary database's password file to the standby server after changing the password. The following steps show how this can be done:
- Stop redo transport from the primary database to the standby database. 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'; System altered.
If the Data Guard broker is being used, we can use the following statement:
DGMGRL> EDIT DATABASE TURKEY_UN SET STATE = 'LOG-TRANSPORT-OFF';
- Change the
SYS
user's password in the primary database:SQL> ALTER USER ...
Get Oracle Data Guard 11gR2 Administration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.