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: 

Expert Oracle Exadata 

Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting

Expert Oracle RAC 12c

==========================================================

Please check our other blogs for  Dataguard ,Standby  & DR.

Comments

Popular posts from this blog

Restore MySQL Database from mysqlbackup

Oracle Database 19C Installation on Windows Server 2016

MySQL InnoDB Cluster Restore/Create Issue : - Dba.createCluster: Group Replication failed to start: MySQL Error 3094 (HY000)