RE: Missing datafiles
- From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- To: <kanwar.plaha@xxxxxx>, "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- Date: Mon, 2 Jul 2007 09:45:15 -0500
You need to change the REUSE to SET in the create controlfile.
Pat
-----Original Message-----
From: Kanwar Plaha [mailto:kanwar.plaha@xxxxxx]
Sent: Friday, June 29, 2007 7:44 PM
To: Dennis Williams
Cc: Elliott, Patrick; oracle-l@xxxxxxxxxxxxx
Subject: Re: Missing datafiles
Hi Dennis,
Thanks for your input. Unfortunately, the process failed. When I tried
recreating the controlfile to include the missing datafiles, it
complained of the file headers having incorrect database name. This is
because the first time the database was renamed (say from ORCL01 to
ORCL02) and opened with a resetlogs.
Anyway, the apps team is not considering doing the entire copy again.
Thanks for all your replies.
Cheers,
Kanwar
On Sat, 30 Jun 2007 12:33:41 am Dennis Williams wrote:
> Kanwar,
>
> Based on the limited information you provided, here is another
> possible route for you to consider, depending on your situation and
> your success with the method that Pat has described:
> If you still have the original datafiles (maybe on a backup),
> 1. Create the database on a test server as you had originally
> planned, including the missing datafiles.
> 2. Determine the missing data. If there are full tables missing,
> exp/imp them to the new database. If there are missing rows, exp them
> using the query option.
> 3. Import the missing data into the new database.
>
> Dennis Williams
___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is
intended for use only by the individual or entity to which it is addressed, and
may contain information that is private, privileged, confidential or exempt
from disclosure under applicable law. If you are not the intended recipient or
it appears that this mail has been forwarded to you without proper authority,
you are notified that any use or dissemination of this information in any
manner is strictly prohibited. In such cases, please delete this mail from your
records.
To view this notice in other languages you can either select the following link
or manually copy and paste the link into the address bar of a web browser:
http://emaildisclaimer.medtronic.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
