Recovery with Archiving  «Prev  Next»
Lesson 6 Recovering an open database, initially open
Objective Demonstrate the steps to perform recover open database, initially open.

Recover open Database Oracle

Recovering open Database | initially open

SVRMGR> SELECT FILE_ID, FILE_NAME, TABLESPACE_NAME, STATUS FROM 
      > DBA_DATA_FILES;
FILE FILE_NAME                            TABLESPACE   STATUS
---- -----------------------------------  -------- ---------
     1     C:\ORANT\DATABASE\SYS1ORCL.ORA   SYSTEM      AVAILABLE
     2     C:\ORANT\DATABASE\USR1ORCL.ORA   USER_DATA AVAILABLE
     3     C:\ORANT\DATABASE\RBS1ORCL.ORA   RBS         AVAILABLE
... 

If one of your junior DBAs informed you that he accidentally deleted the datafile USR1ORCL.ORA using an operating system command, what might you do? Since you know the database is currently open, you must determine to which tablespace the datafile belongs. Click the View Code button to see the command.
From the results of the command, you find out that the removed datafile USR1ORCL.ORA does not belong to the system or rollback segment tablespaces. In this case, the best option for recovery, is to use the method recover open database, initially open.
The following SlideShow walks you through the steps of the recover open database, initially open method.
You may also preview all steps.

  1. The DBA accesses the Server Manager and (2)connects as sysdba.
  2. Since the file is offline, the DBA can restore the file. This is a required step before performing recovery.
  3. (9) After the recovery is finished, the DBA needs to bring the datafile

Recover open Database initially Open
The next lesson demonstrates how to recover an open database, initially closed.

Steps for Complete Recovery of Open Datbase

Click the link below to read about complete recovery of an open database, initially open.
Steps for Complete Recovery of Open Datbase