SHUTDOWN ABORTat the prompt and press Enter.
HOSTat the prompt and press Enter.
C:\DIGITAL\BACKUP\SYS1ORCL.ORA C:\ORANT\DATABASE\SYS1ORCL.ORAat the prompt and press Enter.
EXITat the prompt and press Enter.
STARTUP MOUNT PFILE=D:\ORANT\DATABASE\INITORCL.ORAat the prompt and press Enter.
ALTER DATABASE DATAFILEC:\ORANT\DATABASE\SYS1ORCL.ORA' ONLINE;at the prompt and press Enter (If the specified datafile is already online, Oracle will ignore this statement).
- To start to recover the database, type
RECOVER DATAFILE C:\ORANT\DATABASE\SYS1ORCL.ORA;at the prompt and press Enter.
- To apply the suggested and subsequent archive logs to the restored file, type
AUTOat the prompt and press Enter.
- 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.
- You have successfully recovered the datafile. This completes the Simulation. Click the Exit button to return to the lesson.