Recovery with Archiving  «Prev 

Perform a Closed Database Recovery

  1. If the database is open, shut it down using the SHUTDOWN ABORT. Type SHUTDOWN ABORT at the prompt and press Enter.
  2. To access the operating system, type HOST at the prompt and press Enter.
  3. To restore the damaged file, type COPY C:\DIGITAL\BACKUP\SYS1ORCL.ORA C:\ORANT\DATABASE\SYS1ORCL.ORA at the prompt and press Enter.
  4. Now you need to go back to Server Manager to start the database in mount mode. To access Server Manager, type EXIT at the prompt and press Enter.
  5. To startup the database in mount mode, type STARTUP MOUNT PFILE=D:\ORANT\DATABASE\INITORCL.ORA at the prompt and press Enter.
  6. To make sure that the datafile needing recovery is online during complete recovery, type ALTER DATABASE DATAFILE
    C:\ORANT\DATABASE\SYS1ORCL.ORA' ONLINE;
    
    at the prompt and press Enter (If the specified datafile is already online, Oracle will ignore this statement).
  7. To start to recover the database, type RECOVER DATAFILE C:\ORANT\DATABASE\SYS1ORCL.ORA; at the prompt and press Enter.
  8. To apply the suggested and subsequent archive logs to the restored file, type AUTO at the prompt and press Enter.
  9. Oracle automatically applies each logfile in sequence. Each logfile takes some time to apply, depending upon the volume of information it contains. This simulation lets you see the final result immediately. After media recovery is reported complete, you are ready to start the database. Type ALTER DATABASE OPEN; at the prompt and press Enter.
  10. You have successfully recovered the datafile. This completes the Simulation. Click the Exit button to return to the lesson.