Re: recovery scenario

From: Prasad <p4cldba_at_gmail.com>
Date: Wed, 11 Mar 2009 19:06:39 -0700
Message-ID: <666b99c70903111906w4def7998k45784193fac054b3_at_mail.gmail.com>

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

-Pk

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
>
> --
> Cheers
>
> 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:
>
>> All,
>>
>> 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.
>>
>> scenario
>>
>> oracle 9.2.0.7
>> - cold backup available without the control file.
>> - restored the cold backup and recreated the controlfile by taking all the
>> datafiles.
>> - 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
>> -Pk
>>
>>
>
>

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

Received on Wed Mar 11 2009 - 21:06:39 CDT