Re: Recovery Scenario

Looks like more of hardware issues. Did you check for any OS error messages?
1. Did you try ftp''ing the file (if that works you need to look at Tivoli)

Probably the file is lying on a bad sector and the retries attempt are exceeded.

hth

GovindanK

Manjula Krishnan wrote:

>Actually, my database is fine. It is the backups that are failing. One
>file is not getting copied over. Hot backup runs at midnight and there
>is almost no activity in the database at that time.
>
>I just ran a hot backup and it ran in 13 mins (usually 20 min).
>
>Is there a timeout on AIX? I will post another question.
>
>Thanks,
>
>Manjula
>
>On 7/22/05, Eric Valk <listeric1_at_gmail.com> wrote:
>
>>Hello Munjala,
>>
>>First, some assumptions:
>>
>>- database crashed resulting in a damaged database (otherwise all you
>>need is instance recovery).
>>
>>- I assume that it is a datafile that is not backed up on the second day.
>>
>>- I will also assume that the file is lost, if not then recovery is quite easy
>>assuming that you have all required archived redo logs (and possibly
>>event the redo logs not yet backed up including the current online log).
>>
>>- I'll also assume that you have a controlfile that records the lost datafile.
>>
>>Since you now have a database in your backups that is lacking a datafile
>>you'll need to create a new empty datafile that will take the place
>>of the lost datafile. The ALTER DATABASE command has a "create datafile"
>>option specifically for that purpose. Once you accomplish that you can
>>(media) recover your database completely.
>>
>>HtH
>>
>>Regards
>>Eric Valk
>>
>>
>>2005/7/21, Manjula Krishnan <oradba.la_at_gmail.com>:
>>
>>>Say I have the following scenario.
>>>
>>>Day 1: Hot Backup - all files backup successfully
>>>Day 2: Hot Backup - one file does not back up
>>>Day 3: Database crashes
>>>
>>>Using Day 1 backup, can I restore to current time assuming I have all
>>>archive logs needed?
>>>
>>>Thanks,
>>>
>>>Manjula
>>>--
>>>http://www.freelists.org/webpage/oracle-l
>>>
>

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