log_transport_user - how to verify it's actually being used
edited Apr 3, 2014 12:00PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hi All,
I'm working with a Data Guard configuration using 11GR2 and am trying to find a way to verify that the log_transport_user that I set up is actually being used.
My user, REDO_XFER_USER was created in each database (primary and standby) and assigned the sysoper privilege. I verified that it does exisit in the password file. This was all done prior to creating the DG configuraiton. I used the RMAN
duplicate target for standby using active database commands.
As the standby creation progressed, I monitored the database sessions and did not see any for the REDO_XFER_USER account.
0