2 min read
To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start the database in NOMOUNT mode:...
DataGuard
2 min read
6 min read
Primary --Check DB role (PRIMARY/STANDBY) SELECT DATABASE_ROLE, DB_UNIQUE_NAME AS INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; DATABASE_ROLE INSTANCE OPEN_MODE PROTECTION_MODE...
2 min read
Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as...
3 min read
The ORA-16698 error in Oracle indicates that a Data Guard member has a LOG_ARCHIVE_DEST_n parameter with the SERVICE attribute set,...
42 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
In Oracle Data Guard, changing the protection mode involves adjusting the configuration to one of the three protection modes: Maximum...
2 min read
The ORA-16855 error indicates that the transport lag (the delay in sending redo data from the primary to the standby...
1 min read
Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)
3 min read
Once the standby database is configured and verified to be working properly, we can switch over to the standby database...
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
vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh #!/bin/ksh export ORACLE_SID=<Target_ORACLE_SID> export ORACLE_HOME=/u01/oracle/product/11.2.0.4/db /u01/oracle/product/11.2.0.4/db/bin/sqlplus -s / as sysdba << NACHO > /tmp/standbylag.log set feedback off select...
3 min read
Add the Target Database TNS entry to the Source's tnsnames.ora file(s) (all of them if it's a clustered Source) Set...
1 min read
On Source, as Oracle user: export ORACLE_SID=<source_sid> sqlplus '/as sysdba' alter system set log_archive_dest_state_<whatever_#_used>='DEFER' scope=both sid='*'; alter system set log_archive_dest_<whatever_#_used>=''...
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...
