• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1081
  • Last Modified:

How to recover after hot backup in Oracle

Doing a project for school - and the instructions were to do a hot backup as follows:

SQL> alter database begin backup;

From Windows Explorer, create folder: C:\app\Administrator\oradata\orabackup\hotbackup
And then copy all database files to C:\app\Administrator\oradata\orabackup\hotbackup

SQL> alter database end backup;

Then we were to insert some filed in the hr.regions example table - simulate a media failure by deleting the EXAMPLE01.DBF file

Then instructions were as follows -

SQL> startup
Note: You will receive an error message.
Action: Now you restore the hot backup EXAMPLE01.DBF file to where it used to be: C:\app\Administrator\oradata\orcl450 directory
Reminder: your backup file doesn’t contain the changes you made to HR.REGIONS table.
SQL> alter database open;
Note: You will receive a different error message.
SQL> recover database;

when I try to recover I get this:

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 5: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL450\EXAMPLE01.DBF'
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL450\EXAMPLE01.DBF'

And I am not sure what to do here - can anyone help me out with this??
0
dawber39
Asked:
dawber39
1 Solution
 
dawber39Author Commented:
Never mind - I see my mistake
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now