Solved

How to recover after hot backup in Oracle

Posted on 2011-03-12
1
1,070 Views
Last Modified: 2012-06-27
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
Comment
Question by:dawber39
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
dawber39 earned 0 total points
ID: 35118182
Never mind - I see my mistake
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question