2 Replies Latest reply on Oct 9, 2018 9:39 AM by Staniša Avdalović

data guard sys lock

Staniša Avdalović Oct 9, 2018 9:03 AM

Hi,

We have data guard. We use sys account for data guard. Now we have to lock system and sys account. What will happen with data guard functioning? May we lock as suggested sys and system accounts? Can we establish again data guard?

Best regards

1. Re: data guard sys lock

Joerg.Sobottka Oct 9, 2018 9:34 AM (in response to Staniša Avdalović)

The REDO transport is done by the SYS user account by default, so if you lock the account, the redo transport to the standby will fail.
Create a new REDO_TRANSPORT_USER before you lock SYS.
How to create a REDO_TRANSPORT_USER cookbook:
https://blog.dbi-services.com/oracle-12cr2-dataguard-and-the-redo_transport_user/

Regards
Joerg
Like Show 0 Likes(0)

Actions
2. Re: data guard sys lock

Staniša Avdalović Oct 9, 2018 9:39 AM (in response to Joerg.Sobottka)

Thanks. We will try the solution.
Like Show 1 Likes(1)

Actions

Go to original post

Incoming Links

Re: data guard sys lock