From: Kanwar Plaha <kanwar.plaha@hp.com>
Organization: Hewlett-Packard Company
To: "Jordan Casey" <Casey.Jordan@brickstreet.com>
Subject: Re: Missing datafiles
Date: Fri, 29 Jun 2007 08:04:35 +1000
User-Agent: KMail/1.9.7
References: <34A1525E7603124D8AA357C6AEAD73CB0A542132@BMI-MAIL.brickstreet.local>
In-Reply-To: <34A1525E7603124D8AA357C6AEAD73CB0A542132@BMI-MAIL.brickstreet.local>
Cc: oracle-l@freelists.org
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Disposition: inline
Message-Id: <200706290804.35946.kanwar.plaha@hp.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: kanwar.plaha@hp.com

Hi Jordan,
Thanks for your reply. You are right. However, I do have the original datafiles on
disk. Its just that the first time they were not included in the controlfle.
I cannot do it right now but will this work:

Suppose I recreate the controlfile, this time with the missing files
Then, when it asks for an archivelog to apply for recovery (since there are new
files now), I can use the existing redo log to recover. I have done this in the past
in a slightly different situation where I had to recreate the controlfile when some
files were missed out. It works.

Maybe I will give it a go. In the meanwhile, if you have another hunch, do let me know.

Thanks,
Kanwar

On Fri, 29 Jun 2007 07:58:32 am you wrote:
> In my opinion you can not recover from this.  I have done this several
> times in the past(even today) and have not seen any way to restore the
> files.   The problem is that when you recreate the control file you must
> do a "alter database open resetlogs".   Once this is done any previous
> backups are invalid.
> 
> I could be wrong but I really don't think this can be fixed without
> restore the entire database again. You could drop the Tablespace used by
> the missing data files and recreate it.  Then do a export/import of the
> data from production.
> 
> 
> 
> 
> 
> -----Original Message-----
> From: oracle-l-bounce@freelists.org
> [mailto:oracle-l-bounce@freelists.org] On Behalf Of Kanwar Plaha
> Sent: Thursday, June 28, 2007 5:36 PM
> To: oracle-l@freelists.org
> Subject: Missing datafiles
> 
> Hi,
> A database was copied from another one and the controlfile to create it
> missed out couple of datafiles.
> The database now has missing datafiles listed in it. 
> Also, the fact that some datafiles are missing was not known until a few
> days when some changes to the
> database have taken place.
> My question is if its possible to 'restore' the database now? I can see
> the missing datafiles on disk although
> with an older timestamp than the ones that are online. 
> The database is in NOARCHIVELOG mode. However I checked v$log and found
> that since database build, no
> log switch has happened yet. Does this means shutting the database down
> and recreating the controlfile
> with the missing datafiles can bring the database to a consistent state?
> Can it use the current redo log for
> recovery, if required?
> 
> This is rather urgent, although not critical since its not a production
> environment.
> 
> Thank you,
> Kanwar
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> "Notice of Confidentiality" The information contained in this e-mail
> message is intended for the use of the individual or entity named above.
>  If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution, or copy of the
> communication is strictly prohibited.
> 
> "Notice of Confidentiality" The information contained in this e-mail
> message is intended for the use of the individual or entity named above.
>  If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution, or copy of the
> communication is strictly prohibited.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
> 

--
http://www.freelists.org/webpage/oracle-l