Re: recovery scenario
Date: Wed, 11 Mar 2009 19:06:39 -0700
Thanks Riyaj , one thing though will it show the tablespace name also . if not is there a way to find the tablespace name using oradebug
On Wed, Mar 11, 2009 at 7:01 PM, Riyaj Shamsudeen < riyaj.shamsudeen_at_gmail.com> wrote:
> Hi Prakash
> I had similar issue few years ago. Due to a script bug, one of my
> colleague moved files to incorrect file names (In fact, even file names were
> exchanged! ), causing very similar issue.
> You might want to dump the file_hdrs and that should show file names in
> the trace file. Then move those files to correct file names.
> oradebug setmypid
> oradebug dump file_hdrs 15
> Riyaj Shamsudeen
> Principal DBA,
> Ora!nternals - http://www.orainternals.com
> Specialists in Performance, Recovery and EBS11i
> Blog: http://orainternals.wordpress.com
> On Wed, Mar 11, 2009 at 8:10 PM, Prasad <p4cldba_at_gmail.com> wrote:
>> recently I recovered a database where we lost the controlfile from the
>> cold backup.I recreated the controlfile and then I was able to add the read
>> only tablespaces with there corresponding datafile by doing some guesswork .
>> But I was wondering if there is a right way of doing this . Here is the
>> scenario . I appreciate any suggestions.
>> oracle 126.96.36.199
>> - cold backup available without the control file.
>> - restored the cold backup and recreated the controlfile by taking all the
>> - there were 10 read only tablespaces having 15 datafiles out of a total
>> of 247 datafile
>> I dont know which datafiles belong to which read only tablespace and the
>> user is hitting the below error
>> java.sql.SQLException with message, ORA-00376: file 71 cannot be read at
>> this time
>> ORA-01111: name for data file 71 is unknown - rename to correct file
>> ORA-01110: data file 71: '/u1/app/oracle/product/9.2.0/dbs/MISSING00071'
>> what option I have to relate the these read only tablespace to there
>> corresponding datafiles.
>> Thanks in advance