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

RMAN incremental Backup cumulative and differential

RMAN Incremental backup This backups only datafile blocks changed since specified previous backup. 1.This strategy could be followed to make incrementally updated backup .These incrementally updated backup will be used to make updated image copy will all roll forward image. 2.Reduce amount of time to take backup. 3.Save network bandwidth To be able to recoverContinue reading RMAN incremental Backup cumulative and differential

ASM overview and commands

  Automatic Storage Management (ASM) A.Overview of Automatic Storage Management (ASM) Automatic Storage Management (ASM) simplifies administration of Oracle related files by allowing the administrator to reference disk groups rather than individual disks and files, which are managed by ASM. The ASM functionality is an extention of the Oracle Managed Files (OMF) functionality that alsoContinue reading ASM overview and commands

Unix basic command and shell script for DBA and SYSADMIN

DIRECTORY STRUCTURE IN UNIX   Directory Contains bin/ Required Boot-time binaries boot/ Boot configuration files for the OS loader and kernel image dev/ Device files etc/ System configuration files and scripts home/ User/Sub branch directories lib/ Main OS shared libraries and kernel modules Lost+found/ Storage directory for “recovered” files mnt/ Temporary point to connect devices toContinue reading Unix basic command and shell script for DBA and SYSADMIN

Basic oracle database creation and maintenance in windows and Linux

  DB CREATION STEPS IN WINDOWS SETTING AN ENVIRONMENT(FOR WINDOWS) ORADIM -new -sid <new_sid> -intpwd oracle -startmode AUTO -pfile c:\oracle\admin\<new_sid>\pfile\init<new_sid>.ora   PASSWORD FILE MANAGEMENT   Check in the initclone.ora REMOTE_LOGIN_PASSWORDFILE is set to    exclusive or shared.  If this is set, then a valid passwordfile should exist in ORACLE_HOME/dbs or created using orapwd  as orapwd file=/u01/oracle/V816/dbs/orapwV722Continue reading Basic oracle database creation and maintenance in windows and Linux

Oracle users,roles,audit and security

  MANAGING SECURITY Managing Profiles 1.Creating profile and Granting it to user CONN sys/password AS SYSDBA CREATE PROFILE my_profile LIMIT FAILED_LOGIN_ATTEMPTS 3  — Account locked after 3 failed logins. PASSWORD_LOCK_TIME 5     — Number of days account is locked for. UNLIMITED required explicit unlock by DBA. PASSWORD_LIFE_TIME 30    — Password expires after 90 days. PASSWORD_GRACE_TIME 3   Continue reading Oracle users,roles,audit and security

MySQL Admin

  Install mysql 5.7 in Ubuntu root@ubuntu:~# sudo apt-get install mysql-server Reading package lists… Done Building dependency tree Reading state information… Done The following additional packages will be installed:  libaio1 libhtml-template-perl mysql-client-5.7 mysql-client-core-5.7  mysql-common mysql-server-5.7 mysql-server-core-5.7 Suggested packages:  libipc-sharedcache-perl mailx tinyca The following NEW packages will be installed:  libaio1 libhtml-template-perl mysql-client-5.7 mysql-client-core-5.7  mysql-common mysql-server mysql-server-5.7Continue reading MySQL Admin

How to add raw disk first in vmware host RHEL 7 from datastore and attach to ASM diskgroup using udev rules and asmca

First Add disk from datastore to the VM server node using following steps Login to vCenter console and Right Click Server -> Edit Settings. Click Add and add a New Disk Create a new virtual disk. Provide capacity and all related setting. Also specify the Datastore.   Select proper settings in Virtual Device Node CheckContinue reading How to add raw disk first in vmware host RHEL 7 from datastore and attach to ASM diskgroup using udev rules and asmca

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