How to catalog backups / archivelogs / datafile copies / control file copies, etc. in various versions of Oracle (Oracle Server Version 9.2.0.8.0 to 11.1)RMAN Catalog: It is mainly used for following:
Can store database backup scripts and backup information to safe place(RMAN Repository) apart from target database control file.
Can add backup pieces and image copies of backup on disk to the RMAN repository.
Hello Friends,
I am sharing the information how to deal with Oracle physical block corruption with example in detail.
Physical block corruption is recorded as ORA-1578 in database alert log file every time oracle reads any corrupted block including the corrupted object information from Oracle 10g onwards. Oracle calculates the checksum of data block before it actually fetch the data block from disk, if t
Introduction:
Recovery Manager (RMAN) first introduced in Oracle 8.0. It is a client/server based Oracle utility used to backup, restore, and recover database files.
RMAN utility is included in Oracle software and installed automatically so no additional installation or license is needed for use.
RMAN always stores metadata (RMAN Repository) of its operations (backup/restore/recovery) primarily in the control f
We can create pfile from spfile stored in ASM Disk Group either using RMAN (complex method) or using bellow SQL command (simple method)
1. Look pfile content (If SPFILE is stored in ASM then pfile stored in filsystem has genrally bellow line): $ cat $ORACLE_HOME/dbs/initprod.ora SPFILE=’+DB_DATA/PROD/spfileprod.ora’
2. We can use bellow query in ASM instance to get Spfile inform
Recovery Catalog database is a database (RMAN Repository) that contains a special schema which record backup and recovery information(Metadata) performed on the target database by RMAN in Tables and Other supporting Objects of that schema. Recovery Catalog is optional because RMAN always records backup and recovery information in control file of target database.
In this artical we will discuss:
How to create a
Problem: Database is crashed and not functioning due to one missing non system datafile.
Additional Information:
Oracle database version Oracle 8.1.7.0.0 (8i) of size 10 GB is running on Solaris 5.8.
Database is running in archive log mode and Online Full database backup RMAN tape backup is configured with Data protector (DPRMAN) no catalog is used for RMAN backup.
No file system backup is available for that m
The intent
The intent of the Singleton pattern as defined in Design Patterns is to “ensure a class has only one instance, and provide a global point of access to it”.
When to Use Singleton
Application needs one, and only one, instance of an object. Additionally, lazy initialization and global access are necessary.
Several identical instances in different parts of the program represent the same th
Each pattern describes a problem which occurs over and over again in our environment, and then describes the core of the solution to that problem, in such a way that you can use this solution a million times over, without ever doing it the same way twice.
[Christopher Alexander]
In software engineering, a design pattern is a general repeatable solution to a commonly occurring problem in software design.
Using Gii
Gii is implemented in terms of a module and must be used within an existing Yii application. To use Gii, we first modify the application configuration as follows:
return array(
......
'modules'=>array(
'gii'=>array(
'class'=>'system.gii.GiiModule',
'password'=>'pick up a password here',
// 'ipFilters'=>array(...a
To enable/disable debug in Yii please go to
<Your project folder>/index.php and search for
YII_DEBUG line or check for below line
defined('YII_DEBUG') or define('YII_DEBUG',true);
You’ll want debugging enabled when developing a site, but disabled once live. To disable debuggin, remove or comment out that line.
I normally just comment it out, so that I can re-enabled debugging later. Or you can
Hi Here I am sharing how to create hibernate configuration file for different database.
For Hibernates configuration, we can use a simple hibernate.properties file, a more sophisticated hibernate.cfg.xml file, or even complete programmatic setup. Most users prefer the XML configuration file.
Configuration for PostGresql
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibern
Getting Started
To use Git you will have to setup a repository. You can take an existing directory to make a Git repository, or create an empty directory.
To make your current directory a Git repository we simply run init.
git init
To make a new directory that is a Git repository we just specify a directory.
git init newrepo
From here on out we’ll assume that you are in the root of the Git repository unle
