Recovering form Tablespace corruption Using RMAN

When a  data file is missing  I used following work around .
When Starting up it gave the following error.

Connect to target database using  RMAN

List down the  backup

Create RMAN Catalog DB

Here you have to follow several steps.

First you need to put db in to the Archive log mode.
That will be in my earlier blog ().
Check weather DB in archive log mode.


Connect to the db as sys as sysdba and  carry out  following tasks to

Create a tablespace for RMAN repository.

Create User for RMAN repository.

Grant  recovery_catalog_owner role to the RMAN user.

Verify what  privilege with recovery_catalog_owner.

Connect to RMAN target using following.
provide  target and  catalog databases username and password.

Verify it's working properly.

Linux Delete Logical Volume Group

I wanted to delete the  logical volume of the disk sda 

       dd if=/dev/zero of=/dev/sda

Please make sure before you delete this partition.

Configure Database in Archivelog mode

I have installed Oracle 11g R2 on my PC.

To configure A Database to an Archivelog mode you first want to  configure two parameters mentioned in SPFile/pfile.Those are(Currently database is open and running).

 NAME                                 TYPE                 Values
------------------------------------ -----------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer

you would set values by typing following on the SQL prompt.

Alter system set db_recovery_file_dest='D:\Oracle\Recovery\fin' scope=both;
Alter system set db_recovery_file_dest_size=1024M scope=both;

Give Appropriate values for those db_recovery_file_dest should be an existing location.

Now please shutdown the database and start with the Mount mode.

sql> shutdown immediate;
sql> startup mount;
sql> Alter database archivelog;
sql> Alter database open;

Now database is ready to go with. :)
Thank you!

Re configure the Enterprise Manager (em console)

First of all you need to  de-configure the emctl repository

emca -deconfig dbcontrol db -repos drop


This will ask for your

•  Database SID
•  LISTNER Port Number
•  Passwords for SYS 
•  Passwords for SYSMAN

Then you have to re configure the  emctl repository

emca -config  dbcontrol db -repos create

This will ask for your

• Database SID
• ORACLE_HOME
• Passwords for SYS
• Passwords for DBSNMP
• Passwords for SYSMAN
• Email for notification for Alerts (Optional)
• Outgoin SMTP email for Alerts (Optional)

Now you  have newly created emca repository  :)

now  start  enterprise manager service.

emctl start dbconsole

Adding a new disk to VMWare Virtual Machine in Linux

I have installed VMWare 7.1 on  Windows Server. I already installed RHEL 5-10 64 bit as  the guest operating system.

Adding a new hard disk to the VM.

Go to Initial window   VM  -->Settings
Click Add button  and Choose Hard Disk
Select create a new virtual disk
Choose virtual disk type  SCSI  -- > click Next
Give Maximum disk size --> 20GB
Choose store virtual disk as single file
Give a name to configuration file for this file (.vmdk)

Now already created the ROW disk.

Following steps  are to be carried out

• Partitioning the Disk
• Format the partition
• Create the mount point
• Modify the fstab file  for new partition 

Now make sure that your created disk is listed in /dev folder.
         use                    ll  /dev/sd*
              This will list down the mounted hard disk with partitions disks together.
(My case It is sdc).

• Partitioning the Disk

Type fdisk on  terminal to create and manage partition of hard disk.
                                  fdisk /dev/sdc

please refer following screen shot.

1 )When Its first ask for  command  we  enter  n  first.Because we are creating a new partition.

2 )Then Enters P  since this particular partition is going to be the primary partition.

3 )Then Enters 1 for the particular partition is the first partition and  need to consume all the space of the        disk.

4 )You will have to press w to write the changes to the partitioning table and exit the fdisk.

Now we have created the Partition of the disk.

• Formatting the Partition with the file system

type mkfs   -t   ext3      /dev/sdc1 

This will create a new file system  of  ext3  for  /dev/sdc1 

t is used for tell the type of the file system. ;).

• Create a Mount Point

Now we have formatted the file system  and ready to mount this file system to the system.

mkdir      /u02          (In my case its u02)

mount the file system to the folder.

       mount   -t       ext3       /dev/sdc1      /u02   (t  used for type )

     mounting the sdc1 to /u02

• Modify the fstab file  for new partition 

Add an entry for the fstab file.When boots up(run time) this  partition will be mounted according to given order.

vi  /etc/fstab 

/dev/sdc1     /u02     ext3    defaults       1    2

first location   (/dev/sdc1)    -->  partition name

second location  (/u02)        --> mount location

third location (ext3)     --> file system

fourth location (defaults)  --> mount option

fifth location (1)  -->  for dump  this is to be backed up

sixth location  (2)  -->fsck  determine in what order this shold be run.

Installing Oracle VM Server 3.1.1 (64 bit) on VMWare 7.1