Recover Datafile in Standby Database in Data Guard Environment

In the previous article, we have to seen Recovering Primary Database Datafile using Standby Database if it’s not deleted from Standby Database. Recover Data File in Primary Database in Data Guard Environment Here we will see what if datafile gets corrupted or deleted from Standby Database. Step 1: In the below code, we can see […]

Read More

Recover a datafile from copy

Let’s recover if some datafile is unavailable. Let’s delete users01.dbf datafile which is in USERS tablespace.

Let’s try to create a table name A in tablespace Users.

We need to restore and recover the datafile. Restore means copy from backup, recover means applying changes since the backup is taken.

Restore datafile:

[…]

Read More

Move Datafile From File System To ASM Disk In 11g

Today, we are going to learn about those steps which use to move Datafile from file system to ASM disk in Oracle 11g.Being an Oracle DBA we have deep knowledge of Datafiles. We know there importance of Datafiles in the database. Somes lines explain about the technical definition. A data file is a file that is […]

Read More

ACCIDENTALLY data file is added without “+” sign

In RAC or ASM environment, we missed the ‘+’ sign while adding datafile in tablespace. we got error in ora-01110, ora-27037 in alert log.

Solution 1.  Find out the data file number( It is available in the alert log) 2.  use the rman to copy the data to ASM disk group. 3.  offline the […]

Read More