Database Reference
In-Depth Information
exeRCiSe 13.2
(continued)
14.
Connect to the root as a user who has the DV_OWNER role.
sqlplus c##sec_admin/password
15.
Since you previously granted DV_PATCH_ADMIN to
SYS
, you will need to revoke
DV_PATCH_ADMIN from user
SYS
with
CONTAINER = CURRENT
.
REVOKE DV_PATCH_ADMIN FROM SYS CONTAINER = CURRENT;
16.
Connect to the new Database Vault-enabled PDB as user
SYS
with the SYSDBA
system privilege.
CONNECT SYS@ pdb2 AS SYSDBA
17.
Restart this database.
SHUTDOWN IMMMEDIATE
STARUP
18.
Revoke DV_PATCH_ADMIN from user
SYS
.
REVOKE DV_PATCH_ADMIN FROM SYS;
Data Guard
Oracle Data Guard provides high availability, data protection, and disaster recovery
for Oracle databases. Oracle Data Guard is a set of services that you use to create and
manage standby databases as copies of primary databases. When the primary database is
unavailable, Oracle Data Guard fails over to a standby database. To provide a very high
level of availability, Oracle Data Guard can be used in addition to backup, restore, storage
replication, and clustering.
In an Oracle Data Guard environment one primary database can have up to 30 standby
destinations, connected by Oracle Net. Geographical location, or more precisely distance
from the primary to the standby databases, is not a restriction. You can have multiple remote
standby databases that are geographically dispersed, as long as the primary can communicate
with the standby.
Physical Standby Database
A
physical standby database
is a physically identical block-wise
copy of the primary database. The database schemas are identical between the primary and
physical standby. Redo Apply is used to keep the physical standby in sync with the primary.
Logical Standby Database
A
logical standby database
contains the same logical information
as the production database but the physical structure and organization of the database can be
different. SQL Apply is used to keep the logical standby database in sync with the primary.
Search WWH ::
Custom Search