Link to home
Start Free TrialLog in
Avatar of dawber39
dawber39Flag for United States of America

asked on

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??
ASKER CERTIFIED SOLUTION
Avatar of dawber39
dawber39
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial