dawber39
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\orada ta\oraback up\hotback up
And then copy all database files to C:\app\Administrator\orada ta\oraback up\hotback up
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\orada ta\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\ORAD ATA\ORCL45 0\EXAMPLE0 1.DBF'
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: 'C:\APP\ADMINISTRATOR\ORAD ATA\ORCL45 0\EXAMPLE0 1.DBF'
And I am not sure what to do here - can anyone help me out with this??
SQL> alter database begin backup;
From Windows Explorer, create folder: C:\app\Administrator\orada
And then copy all database files to C:\app\Administrator\orada
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\orada
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\ORAD
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: 'C:\APP\ADMINISTRATOR\ORAD
And I am not sure what to do here - can anyone help me out with this??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.