Category: Oracle

Oracle Database Health Check up Checklist

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

Database Health Check up Checklist 1. Basic Server Status Basic Server related configuration collection CPU Speed Physical Memory, Swap size Disk layouts Log storage Number of database running on the server & in what mode e. (Open or Mount) mode.   Database up/down Whether the database shutdown / started up Any abnormalities noted during the startup or shutdown i.e. any Oracle background process terminated while …

Oracle Database Crash During Hot Backup

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

Oracle Database Crash During Hot Backup SCOPE — There can be many reasons for the database to crash during a hot backup—a power outage or rebooting of the server, for example. If these were to happen during a hot backup, chances are that tablespace would be left in backup mode. In that case you must manually recover the files involved, and the recovery operation would …

Oracle Data Pump Overview

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

Oracle Data Pump Overview Introduction This white paper gives an overview of the Data Pump architecture, description of the important features of Data Pump, some best practices to use and a comparison of the Data Pump Export and Import utilities to the Export (Exp) and Import (Imp) utilities. Data Pump Overview Data Pump is a fully integrated feature of Oracle Database that provides very high-speed …

Data Block Corruption In Oracle

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

Data Block Corruption In Oracle Case Study :- Once I faced the Data block corruption problem on DishTv site in one of our Oracle Database server. The corrupted block was referring to a table. We tried everything like rebuilding index, correcting the data corruption etc but finally it was detected as a physical data corruption and hence we raised the call with Os vendor. We …

DataGuard Implementation steps

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

DataGuard Implementation steps Create similar directory structure on Primary and Standby nodes for storing backups and Archive log files. In the test Dataguard Machine, the following Directories were created. Eg mkdir /misc/arch – for specifying a local location of the archive files mkdir /misc/backup – for specifying a backup location for RMAN backup. Please note that this is the directory that stores the RMAN backup …

RMAN for an APPS DBA

October 12, 2016 by S4

Filed under Oracle

Last modified October 12, 2016

RMAN for an APPS DBA   Its been long since i but up a post here. But have been tied up with a new project lately, i also apologize that i could not get back to your comments in time but will have them answered as soon as possible. Also lately i have been working with RMAN, and found out that it has a steep …

11G Migration Using Rolling Upgrade

October 12, 2016 by S4

Filed under Oracle

Last modified October 12, 2016

1      INTRODUCTION 1.1     Objective Database upgrade and patch applying takes considerable amount of down time of production server.Oracle 11 G provides rolling upgrade method which allows up gradation /patch applying activities with no down time. This document explains migrating oracle 10G to 11G using data guard rolling upgrade method. 1.2     Scope What is covered in this document. Rolling update for 11g Migration Switchover Best practices …

Oracle 11g Data Recovery Advisor

October 12, 2016 by S4

Filed under Oracle

Last modified October 12, 2016

1.1 Introduction   Oracle 11g has introduced the new tool for automatically diagnose and repair data failures and corruption, which is called as Data Recovery Advisor. It analyzes failures and determines optimal repair strategies.   1.2 Scope The scope of this document is restricted to the Data Recovery Advisor feature of Oracle 11g with RMAN.   1.3 Overview In oracle 11g Data Recovery Advisor is …

10g Data Guard, Physical Standby Creation, step by step

October 12, 2016 by S4

Filed under Oracle

Last modified October 12, 2016

Creating a Data Guard Physical Standby environment, General Review. Manually setting up a Physical standby database is a simple task when all prerequisites and setup steps are carefully met and executed. In this example I did use 2 hosts, that host a RAC database. All RAC preinstall requisites are then in place and no additional configuration was necessary to implement Data Guard Physical Standby manually. …

RMAN in RAC Environment

October 12, 2016 by S4

Filed under Oracle

Last modified October 12, 2016

Introduction We are familiar with the following characteristics of RMAN in Oracle  9i , Backup the database, tablespaces, datafiles, control files and archive logs Store frequently executed backup and recovery operations Perform incremental block-level backup Skip unused blocks Specify limits for backups Detect corrupted blocks during backup Increase performance through: Automatic parallelization Manage backup and recovery tasks RMAN repository is metadata about target database, backup …