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…
7 years ago
ASM overview and commands
Automatic Storage Management (ASM) A.Overview of Automatic Storage Management (ASM) Automatic Storage Management (ASM) simplifies administration of Oracle related…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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 …
7 years ago
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…
7 years ago
Lambda to Start EC2 Instances on schedule and send instant public IP over email to multiple recipients using SNS
Following article will describe how to start EC2 Instances on schedule using Lambda and send the public IP instantly to…
7 years ago