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

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.

Unit test case example for Class called UUIDGenerator my test class file path was /test/phpunit/unit/UUIDGeneratorTest.php <?php require_once dirname(__FILE__) . '/../bootstrap/unit.php'; class unit_UUIDGeneratorTest extends sfPHPUnitBaseTestCase { public function testgenerateUUIDLongValid() { $uuidObj = new UUIDGenerator(); $key = 553; $key = $key . rand() . date('Y

copy below phpunit.xml file under the root dir of your project and run tests under (test/phpunit/unit) dir with phpunit configuration /usr/local/php5.3.0/bin/phpunit –configuration phpunit.xml –coverage-html ./testreport/coverage –coverage-clover ./testreport/coverage/coverage.xml test/phpunit/unit <phpunit bootstrap="test/phpunit/bootstrap/unit.php" backupGlobals=&q

Jenkins is an open source continuous integration tool written in Java. The project was forked from Hudson after a dispute with Oracle, which claims the right to trademark the Hudson name and has applied for such a trademark as of December 2010. Wikipedia Jenkins focuses on the following two jobs: Building/testing software projects continuously - It provides continuous integration system, which helps obtain fr

How to create pfile from spfile stored in ASM disk group We can create pfile from spfile stored in ASM Disk Group either using RMAN (complex method) or using bellow SQL command (simple method): 1. First get name and location of spfile stored in ASM disk group. Look pfile content stored in file system; Usually PFILE will contain information similar to below If SPFILE is stored in ASM: $ cat $ORACLE_HOME/dbs/

Introduction By definition, Strategy design pattern allows an object to change its behaviour when its internal state changes. The object will appear to change its class. The Strategy design pattern enables a client to choose which algorithm to use from a family of algorithms and gives it a simple way to access it. The algorithms can also be expressed independently of the data they are using. The Strategy Patter

$this is used to reference methods and properties of the current instance of a class. Declaring class properties or methods as static makes them accessible without needing an instantiation of the class. A property declared as static can not be accessed with an instantiated class object (though a static method can) The keyword self does NOT refer merely to the ‘current class’, at least not in a way 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

How to create pfile from spfile stored in ASM disk group We can create pfile from spfile stored in ASM Disk Group either using RMAN (complex method) or using bellow SQL command (simple method): First get name and location of spfile stored in ASM disk group. Look pfile content stored in file system; Usually PFILE will contain information similar to below If SPFILE is stored in ASM:$ cat $ORACLE_HOME/dbs/initp

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