1 min read
Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)
DataGuard
1 min read
5 min read
This content is password protected. To view it please enter your password below: Password:
2 min read
Maximum Protection Mode 1. No data loss 2. Redo has to be written to both Primary redo logs and standby...
6 min read
It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log when redo log switch is...
1 min read
DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will be generated for the whole...
3 min read
Once an Archive Log is received or archived from a Standby Redo Log on the Standby Database, it is registered...
6 min read
IN PRIMARY DATABASE :- 1) Check Instance details :- select status,instance_name,database_role from v$database,v$instance; ------------------------------------------------------------------------------------------------------------------------------------ 2) Check redo log and standby...
4 min read
Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the both the nodes and restarted...
3 min read
$ 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...
2 min read
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...
2 min read
A) Recovery Point Objective(RPO) A recovery point objective (RPO) is the maximum length of time permitted that data can be...
27 min read
1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11 we need to install the...
13 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
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...
5 min read
Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t...
1 min read
PROBLEM: When DGMGRL is used to create DG broker configuration it fails with below error : DGMGRL> connect sys Password:...
4 min read
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...
2 min read
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...
2 min read
ORA-10567: Redo is inconsistent with data block on standby Issues: ORA-10567: Redo is inconsistent with data block on standby Error:...
1 min read
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
1 min read
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to...
2 min read
DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use...
