How to recover a missing datafile in Oracle?

How to recover a missing datafile in Oracle?

How to Recover a missing  Datafile in Oracle 1-Before starting doing this make sure we have a valid backup of our database prior of dropping the database. We will assume that you have your database on a everyday Rman backup. For the purpose of this tutorial i will make a full backup of my database.

How to get data files back online after media recovery?

After Media Recovery is complete, some data files may be offline. Connect sys/password as sysdba in sqlplus and run the following query to find which datafiles are offline: Select file# from v$datafile where status = ’OFFLINE’; Note all file# numbers that are returned. Then, while in sqlplus connected to the database as sys/password as sysdba.

How to check for data files that need recovery?

Alter database end backup; After all datafiles have been taken out of backup mode, skip to the section titled Bring All Data Files Online. Check for Data Files That Need Recovery This type of recovery will be required for systems that have a sudden loss of power or database crash while not running a tape backup.

How to open alter database datafile 12 online?

Alter database datafile 12 online; Alter database datafile 15 online; After all files are back online, continue to the next step Open the Database. Open the Database To open the database after media recovery is completed, while in sqlplus connect to the database as sys/password as sysdba and type:

How to recover data from a database in SQL?

RECOVER DATAFILE ‘filename1’, ‘filename2’; Generally, you should perform database recovery using Enterprise Manager, which prompts you for information and returns messages from the system. The SQL command equivalent of Enterprise Manager media recovery options is the ALTER DATABASE command with the RECOVER clause.

How are database recovery operations coordinated in Oracle?

The Oracle distributed database architecture is autonomous in nature. Therefore, depending on the type of recovery operation selected for a single, damaged database, recovery operations may, or may not, have to be coordinated globally among all databases in the distributed database system.

Is there a recovery mechanism for Oracle 10g?

Note:This topic has been updated for use with Oracle 10g databases. Introduction Oracle has a highly reliable recovery mechanism built into the database, and transaction loss due to database crash can be prevented if the correct steps are followed.