The logical standby database is in Read-Write mode means a fully updatable mode. A database can be accessed and potential data may be changed. So Oracle data guard provides a lock. We can configure GUARD on the database at a different level according to our requirement.
A user access can be controlled with GUARD.
We can enable GUARD with ALTER DATABASE GUARD [ALL | STANDBY | NONE] command.
There are three level for GUARD.
- ALL: We can use ALTER DATABASE GUARD ALL statement. It prevents users from making changes to any data in the database.
- STANDBY: It Prevents users from making changes to any data maintained by Data Guard SQL Apply
- NONE: If we provide Guard none then it provides normal security a user which have access to objects can change data in that.
To check Guard_status use following query.
SQL> select guard_status from v$database; GUARD_STATUS ------------------------------ ALL
1. The Data Guard level is automatically set to ALL by the broker on the logical standby database.
2. Database Guard level applies to all users except SYS user.
Stay tuned for More articles on Oracle DataGuard
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp