Flashback Feature in Oracle Database

 Download the following document which discuss in details the flashback feature of oracle database 11i.

Oracle Data Guard Physical Standby Database Creation

I have followed the following documents to create a Physical Standby

Brief tutorial on oracle PL/SQL

PL SQL Introduction

Generic Section

Declare

Oracle DBA Health Checkup and performance scripts Part 2 Checking the database Alert Log in automatic manner for new alert or error

This script finds errors encountered in alert.log, if any. Also this script is written in the manner that it'll only show the errors those have not been

Oracle DBA Health Checkup and performance scripts Part 1 Tablespace and datafile monitoring scripts

The following script is a master oracle database performance monitoring script for checking the

database space usage by tablespace basis. The following scripts reports the

Oracle Apps DBA Health Checkup and performance scripts Part 3 Apache, Form and Report log file deletion scripts in R12

The following scripts will delete old report, form and apache log files. Save the following code segments in a shell scripts.

Oracle Apps DBA Health Checkup and performance scripts Part 2 Details Oracle Apps Auditing and performance check

The following script is a master script which audits and checks various Oracle Ebusiness Suite parameters in a single run. It runs a variety of Oracle Apps Health Checks. Warning section at beginning should usually return no rows.

Oracle Apps DBA Health Checkup and performance scripts Part 1 OMPN process check in R12

The following scripts is a useful script to check the opmn status of oracle apps R12 server at once. This is a handy script to check the status in one shot. Here I am checking the opmn status of $ADMIN_SCRIPTS_HOME. Alternatively

Oracle RMAN Tutorial Part 3 Recovery Operation

Block Media Recovery


check the corrupted block using following sql command.
SQL> select * from v$ database_block_corruption;

Oracle RMAN Tutorial Part 2 BACKUP OPERATION

Full database backup using RMAN


RMAN> backup as backupset database spfile;
RMAN> sql 'alter system archive log current';

Oracle RMAN Tutorial Part 1 Creating and configuring RMAN repository

Here are the basic description on RMAN configuration and setup. By reading this article you can configure a RMAN by yourself in a very practical manner. I have only concentrated on RMAN practical implementation perspective here.

Brief steps for Installing and Configuring RAC oracle database on ASM

software that is required
1. oracle database [11]
2. oracle clusterware

How to change the init parameter when oracle database is using SPFILE

first check db is running in SPFILE or PFILE using the following script.

SQL> SELECT  instance_name,