Error 1017 received logging on to the standby Ora-16191
I was forced to scp the password file from the primary to the standby. Simply recreating an identical password on […]
I was forced to scp the password file from the primary to the standby. Simply recreating an identical password on […]
This post also documents standby startup in either regular Data Guard standby or Active Data Guard standby (read only) in
My Environment I used VirtualBox to test Oracle 12c 12.2.0.1 Data Guard setup of one primary and one standby (using
While using dataguard broker is optional with Dataguard, using it adds some complexity and flexibility – expect a little learning
# When DATABASE_ROLE=”PHYSICAL STANDBY” AND “MOUNTED” is the result for OPEN_MODE – the standby is NOT in active dataguard mode,
http://www.oracle.com/us/support/lifetime-support/index.html There are PDFs at the bottom of the page above providing information on an array products.
select db_unique_name, open_mode, log_mode, database_role from v$database; DB_UNIQUE_NAME OPEN_MODE LOG_MODE DATABASE_ROLE ———————— ——————————– ———————————— ———————————————— THEPRDS READ ONLY WITH APPLY
alter session set nls_date_format=’dd-mon-yy hh24:mi’; SELECT A.*, Round(A.Count#*B.AVG#/1024/1024) HOURLY_Avg_Mb FROM (SELECT To_Char(First_Time,’YYYY-MM-DD HH24′) HOUR, Count(1) Count#, Min(RECID) Min#, Max(RECID) Max# FROM v$log_history GROUP BY To_Char(First_Time,’YYYY-MM-DD HH24′) ORDER BY
–set the SLA? –Use a logon trigger to set the maximum delay –whenever a user logs into the standby —
The following view shows Data Guard standby lag via a histogram updated every second since the instance was last booted.