ConFigure Recoship User for Oracle Standby Database
For Security reasons, DBA have been asked multiple time not to use sys user for DBA activity or replication. In this blog, We will list down to step to setup replication user for oracle standby database.
1) Create user for redo shipping on Primary database.
2)Backup password file on primary and secondary side.
3) Grant below privileges to redo ship user
grants sysoper to redoship;
grant create session to redoship;
4) Copy the password file to remailing nodes.
5)Confirm redoship user is reflecting on all instanced.
select * from gv$pwfile_users where username='REDOSHIP';
6) Confirm user have been created on the standby database.
select * from gv$pwfile_users where username='REDOSHIP';
7) Defer the log shipping to standby database.
alter system set log_archive_dest_state_2=enable scope=both sid='*';
8) Copy the password file from primary node to all standby db nodes.
9) Verify redoship user is reflected in the password table on standby.
select * from gv$pwfile_users where username='REDOSHIP';
10) Set redo transport user to redoship on primary and standby.
On primary and on secondary
alter system set redo_transport_user='REDOSHIP' sid='*';
show parameter REDO_TRANSPORT_USER
11) Enable redo shipment
alter system set log_archive_dest_state_2=enable scope=both sid='*';
You can learn more about oracle database administration:
==========================================================
Comments
Post a Comment
Please do not enter any spam link in comment Section suggestions are Always Appreciated. Thanks.. !