All posts

  1. Home
  2. All posts
    3. (
  3. Page 18
    4. )
by Team Ajara

Oracle Database backup configurations.

Oracle DB backup configurations. In this article we will see different media management layer configuration parameters in the run block. To take backup of oracle database we use any one
by Team Ajara

To add two numbers in Shell script

To add two numbers. This article describes how to add two numbers # To Add two numbers a=10 b=5 c=`expr $a + $b` echo  “Sum of two numbers=$c”   reference
by Team Ajara

Script for Monitoring Oracle Database

Script for Monitoring Oracle databases. Script to monitor sessionlocks,current session and tablespace usage details on RAC database Main script calls 3 SQL queries and sends the output in a mail
by Team Ajara

Introduction to Oracle Database Administration

Introduction to Oracle Database Administration. What is Oracle? Oracle database is a relational database management system (RDBMS) from Oracle Corporation. This article will explain a complete overview of the Oracle
by Team Ajara

Tools & Applications for DB Administration

Different Tools and Applications for Database Administration. For performing database administration activities from “Citrix Workspace for web” or from the remote desktop (Virtual Private Network connection), below mentioned tools are
by Team Ajara

script to verify oracle tablespace usage

script to verify oracle tablespace usage set pages 200 lines 150 col TOTAL_MB format 9999999.00 col USED_MB format 9999999.00 col FREE_MB format 9999999.00 col PCT_USED format 999.9 col PCT_FREE format
by Team Ajara

RMAN-03002: failure of delete command

RMAN-03002: failure of delete command . Error received while trying to delete failed backups.   RMAN> run 2> { allocate channel t1 type ‘SBT_TAPE’ parms=’ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCLP.opt)’; delete noprompt force BACKUPSET 72314,72318;