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

PSU patch Oracle 11gR2 oracle single instance HA

1.OPatch installation Copy the opatch binary using root user to $ORACLE_HOME and $GRID_HOME. Then please keep backup of old OPatch directory. Unzip the binary in the $ORACLE_HOME and $GRID_HOME. unzip -o -d $ORACLE_HOME /oracle/soft/p6880880_112000_Linux-x86-64.zip unzip -o -d $GRID_HOME /oracle/soft/p6880880_112000_Linux-x86-64.zip Change owner of the folder OPatch. chown -R oracle:oinstall $ORACLE_HOME/OPatch chown -R oracle:oinstall $GRID_HOME/OPatch 2.Stop EMContinue reading PSU patch Oracle 11gR2 oracle single instance HA

Grid and Oracle PSU patching using OPatch 11gR2 RAC

1.Please download latest version of OPatch and install under $ORACLE_HOME and $GRID_HOE Copy the opatch binary using root user to $ORACLE_HOME and $GRID_HOME. Then please keep backup of old OPatch directory. Unzip the binary in the $ORACLE_HOME and $GRID_HOME. unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0/grid unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0/db_1 Change owner of the folder OPatch. chown -RContinue reading Grid and Oracle PSU patching using OPatch 11gR2 RAC

Automated sql code deployment using Github and Jenkins DevOps

Install GitHub Download Git https://git-scm.com/download/win Installation Steps After finish,Please create repository where code will be saved   There is no code now I am creating sample code in c:\mygitrep directory     We need to again login to git from program and rescan. Now stage unchanged Now sign off Please commit now Now we willContinue reading Automated sql code deployment using Github and Jenkins DevOps

Create new mount point using LVM in RHEL 7

First install gdisk utility (you may use old fdisk utility if LUN/drive size is less than 2 TB) -bash-4.1$ yum install gdisk Loaded plugins: fastestmirror, security You need to be root to perform this command. -bash-4.1$ su Password: [root@LinuxAcademy linuxacademy]# yum install gdisk Loaded plugins: fastestmirror, security Setting up Install Process Determining fastest mirrors *Continue reading Create new mount point using LVM in RHEL 7

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

FLASHBACK DATABASE AND QUERIES

FLASHBACK FEATURES   Purging the Recycle Bin   purge table sales.woodscrews; purge index sales.woodscrews_pk_idx; purge tablespace sales; purge recyclebin;   Undropping Objects in the Recycle Bin   flashback table ws_app.woodscrews to before drop; select object_name, original_name, droptime, dropscn from user_recyclebin; flashback table bonus to before drop rename to bonus_deb;   ———–Accidentaly Delete——————————————   Accidentally droppedContinue reading FLASHBACK DATABASE AND QUERIES

Network configuration listener and tnsnames in oracle

Oracle Network Configuration =========================== In its most basic form, Oracle uses three files (listener.ora, tnsnames.ora & sqlnet.ora) for network configuration. This article gives an example of each file as a starting point for simple network configuration. •Assumptions •Listener.ora •Tnsnames.ora •Sqlnet.ora •Testing Assumptions ========== The example files below are relevant for an Oracle installation and instanceContinue reading Network configuration listener and tnsnames in oracle

Memory and Process in Oracle generic note

MEMORY MANAGEMENT 11g ===================== http://blog.tanelpoder.com/2007/08/21/oracle-11g-internals-part-1-automatic-memory-management/ PGA+SGA=MEMORY_TARGET what are the shared memory IDs for my instance $ sysresv corresponding SysV SHM segments: $ ipcs -m mapped memory for an Oracle instance process – as the SGA should be definitely mapped there! $ pmap `pgrep -f lgwr` $ ls -l /dev/shm Removing Shared Memory Sometimes after anContinue reading Memory and Process in Oracle generic note