Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)
DataGuard
This content is password protected. To view it please enter your password below: Password:
Maximum Protection Mode 1. No data loss 2. Redo has to be written to both Primary redo logs and standby...
It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log when redo log switch is...
DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will be generated for the whole...
Once an Archive Log is received or archived from a Standby Redo Log on the Standby Database, it is registered...
IN PRIMARY DATABASE :- 1) Check Instance details :- select status,instance_name,database_role from v$database,v$instance; ------------------------------------------------------------------------------------------------------------------------------------ 2) Check redo log and standby...
Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the both the nodes and restarted...
$ ps -ef|grep pmon oracle 2113 1 0 Sep20 ? 00:54:32 ora_pmon_prod1 oracle 30032 29996 0 08:50 pts/0 00:00:00 grep...
Issue : ORA-16047: DGID mismatch between destination setting and target database alert.log alter database register logfile '/opt/data/oracle3/prod101/FRA/prod101/archivelog/2019_12_01/o1_mf_1_190698_gy5z61jw_.arc' There are 1...
A) Recovery Point Objective(RPO) A recovery point objective (RPO) is the maximum length of time permitted that data can be...
1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11 we need to install the...
This content is password protected. To view it please enter your password below: Password:
This content is password protected. To view it please enter your password below: Password:
This content is password protected. To view it please enter your password below: Password:
This content is password protected. To view it please enter your password below: Password:
Overview:As we are already aware that the rolling forward an physical standby database via an incremental SCN based backup method is one of the easiest way of getting your standby database with lag into sync with the primary database.The lag...
Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t...
PROBLEM: When DGMGRL is used to create DG broker configuration it fails with below error : DGMGRL> connect sys Password:...
1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To...
Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown - rename to...
ORA-10567: Redo is inconsistent with data block on standby Issues: ORA-10567: Redo is inconsistent with data block on standby Error:...
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to...
DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use...