Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Tuesday, February 26, 2013

ORA-01152: file 1 was not restored from a sufficiently old backup

Scenerio: After restring and recovering database got ORA-01152 while opening the database with resetlogs. Backup was taken without taking the archive logs. Perform the following:

Monday, February 25, 2013

RMAN: Taking Cold backup using RMAN and restore it

Cold backup is particular useful when you plan to test some changes on the database and in case something goes wrong you can always fall back to this Cold backup.

Cold backup is a consistent backup when the database has been shutdown immediate or Shutdown Normal.If the database is shutdown with abort option then its not a consistent backup.
Cold backup can be taken by RMAN in mount stage after database has been shutdown immediate.

RMAN: Recovery of missing datafile that is never backed up

Oracle Database 11gR2 on Windows 7
DB in archivelog mode

Assuming that already a tablespace "TS1" is existing with one datafile, if not you can use the statements below.
 create tablespace ts1 datafile 'C:\app\Inam\oradata\orcl\ts01.dbf' size 10m reuse;

Sunday, February 24, 2013

Using Transportable Tablespaces

Oracle transportable tablespaces are the fastest way for moving large volumes of data between two Oracle databases. Using transportable tablespaces, Oracle data files (containing table data, indexes, and almost every other Oracle database object) can be directly transported from one database to another. Furthermore, like import and export, transportable tablespaces provide a mechanism for transporting metadata in addition to transporting data.

RMAN: Recover A Dropped Tablespace Using TSPITR (11gR2)

RMAN automatic Tablespace Point-In-Time Recovery ( TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database.

Saturday, February 23, 2013

ORA-00245 control file backup failed

Environment: Two node Oracle RAC 11gR2 on Windows 2008R2


RMAN backups report errors like :

ORA-00245: control file backup operation failed

Wednesday, February 20, 2013

ORA-12528: TNS: listener: all appropriate instances are blocking new connections

Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.

Monday, February 18, 2013

Installing 11gR2 RAC on Solaris

Environment: OS  Sun Solaris 10 update 10 x86 64bit on OVM, Oracle 11gR2 ( 64bit
See the overview

Read the overview above for Grid infrastructure concepts. As overview is related to Windows OS, difference is given below with respect to Solaris.
ADVM (ASM dynamic volume manager) and ACFS (ASM cluster file system) are currently not available forSolaris. 

11gR2 on Solaris: Create Database

11gR2 on Solaris: RDBMS Software Install

Log out from "grid" user and enter as "oracle" and run installer

11gR2 on Solaris: Oracle Grid Infrastructure Install

Start the RACSOL1 and RACSOL2 virtual machines, login to RACSOL1 as the grid user and start the Oracle GI installer.

11gR2 on Solaris: Prepare the shared storage/Prereq

After installing the basic installation of Solaris there are certain requirements which need to be fulfilled for successful installation of RAC 11g.

11gR2 on Solaris: Installing/configuring vboxguestAddition tool

After installing the OS, you can install the "VBoxGuestAdditions" to get the additional benefits from Oracle Virtual Machine like resolution/full screen capabilities etc. VBoxGuestAdditions' .iso image is found in the installation folder of OVM eg; C:\Program Files\Oracle\VirtualBox.

11gR2 on Solaris: Installing OS (Solaris)

You can get the Solaris media from edelivery. After getting the media attach the .iso image as CDROM to OVM and start the virtual machine. Installation wizard will be started. Here are the images for your reference.