ORA-01111: name for data file is unknown – rename to correct file

Error in dataguard alert log/start managed recovery process:- SYS@XXX>alter database recover managed standby database; alter database recover managed standby database * ERROR at line 1: ORA-00283: recovery session canceled due to errors ORA-01111: name for data file 61 is unknown – rename to correct file ORA-01110: data file 61: ‘/u01/app/oracle/product/12.1.0/db_1/dbs/UNNAMED00061’ ORA-01157: cannot identify/lock data fileContinue reading ORA-01111: name for data file is unknown – rename to correct file

Restore Archivelog from particular sequence to another location using tape backup

Error in DR alert log:- FAL[client]: Failed to request gap sequence GAP – thread 2 sequence 9432-9473 DBID 2085418592 branch 924361120 FAL[client]: All defined FAL servers have been attempted. ———————————————————— Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that’s sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps.Continue reading Restore Archivelog from particular sequence to another location using tape backup

Monitor steps for Logical Standby Database

1.V$LOGSTDBY_PROCESS displays dynamic information about what is happening to the Data Guard log apply services. This view is helpful when diagnosing performance problems during the logical application of archived redo logs to the standby database, and it can be helpful for other problems. This view is for logical standby databases only.   INPUT QUERY:-  Continue reading Monitor steps for Logical Standby Database

Logical Standby Database setup step by step from RAC to Single Instance in 11g

LOGICAL STANDBY DATABASE STEP BY STEP     Primary DB: CLRVMS (ip:10.3.248.5 and 10.3.248.8) Logical Standby DB: CLRVMS_B(ip:10.3.248.129)   Please check whether Primary database is in archivelog or not.It should be in archivelog.   select log_mode from v$database; LOG_MODE ———— ARCHIVELOG   Enable Force Logging, SQL> ALTER DATABASE FORCE LOGGING; Database altered.   Configure Standby Redo LogContinue reading Logical Standby Database setup step by step from RAC to Single Instance in 11g

FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL

FAST START FAILOVER (FSFO) CONFIGURATION USING  FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL   1.For data guard DGMGRL configuration and Far Sync setup please follow below link:- http://clouddba.co/step-step-oracle-active-data-guard-far-sync-rac/   2.Please check current database status DGMGRL> show database  ebilpd1;   Database – ebilpd1   Role:               PRIMARY Intended State:     TRANSPORT-ON Instance(s): EBILPD11 EBILPD12   DatabaseContinue reading FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL

Step by Step Oracle Active Data Guard Far Sync RAC

     Step by Step Oracle Active Data Guard Far Sync RAC Active Data Guard Far Sync, a new capability with Oracle Database 12c, eliminates compromise by extending zero data loss protection to a replica database located at any distance from the primary database. Active Data Guard Far Sync accomplishes this with minimal expense or complexityContinue reading Step by Step Oracle Active Data Guard Far Sync RAC

Script to sync check of applied archive log between 2 RAC databases

1.First create the shell script mentioning all environmental variables adjusted to your environment. vi dataguard_dr_sync_check.sh #!/bin/bash cd /u01/app/oracle/shells for k in ORCL do export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 export ORACLE_SID=$k $ORACLE_HOME/bin/sqlplus -S monitor@”$k”/xxx << EOF >> dataguard_dr_sync_check_orcl_`date +\%d\%m\%Y\%H`.log @dataguard_dr_sync_check_orcl.sql exit EOF done 2.For 2 node RAC,below will be dataguard_dr_sync_check_orcl.sql script .For 4 nodes,just add another 2Continue reading Script to sync check of applied archive log between 2 RAC databases

ORACLE DATA GUARD FOR RAC 12C USING SEPARATE REPLICATION NETWORK

ORACLE DATA GUARD FOR RAC 12C USING SEPERATE REPLICATION NETWORK Table of Contents Revision history   3 1       Environment   4 1.1         Hardware  4 1.2         Software  4 1.3         Networking  4 1.3.1      Primary Site  4 1.3.2      Disaster recovery Site  5 1.4         LISTENER_DG both for primary and standby  5 1.4.1      Listener Configuration Kolkata1  10 1.4.2      Listener Configuration Kolkata2  11Continue reading ORACLE DATA GUARD FOR RAC 12C USING SEPARATE REPLICATION NETWORK

Case Study on Network Bandwidth Calculation in 12c dataguard environment and testing with redo generation rate

Data loading:- create table t(c1 char(2000),c2 char(2000)); insert into t select ‘A’,’B’ from dual connect by rownum<1000000; commit; the data loading of 8 GB data took 160 sec . Now redo generation rate by 2 nodes RAC database as calculated by following example is:- SYS@EBILPD11> select thread#,sequence#,blocks*block_size/1024/1024 MB,(next_time-first_time)*86400 sec, blocks*block_size/1024/1024/((next_time-first_time)*86400) “MB/s” from v$archived_log where ((next_time-first_time)*86400<>0)Continue reading Case Study on Network Bandwidth Calculation in 12c dataguard environment and testing with redo generation rate