Re: Recovery Scenario

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Thu, 21 Jul 2005 14:30:27 -0700 (PDT)
Message-ID: <20050721213028.22373.qmail@web60721.mail.yahoo.com>

Yes. You can recover using day 1 backup as long as you have all archive logs. You can also use a combination of good files from day 1 and day2. They all do not have to be from one day.

Manjula Krishnan <oradba.la_at_gmail.com> wrote: No. I did not lose anything yet. This was to plan for the future.

I have backup scripts to hot backup the database to another server, since this server does not have a tape drive. Tivoli picks up these files after the hotbackup runs. It was working fine for the last several months.

Last couple of weeks, just while copying one of the datafiles over it is timing out. This is the error I get:

cp: /oracle/orabackup/lawprod/hot/lawindex.dbf: A remote host did not respond within the timeout period.

This file is about 4G. I am on AIX 5.2 and Oracle 9.2.0.6. We also have 1GB ethernet. So, I don't know why this is happening.

Thanks,

Manjula

On 7/21/05, Hameed, Amir wrote:
> You can use command:
> Recover database using backup controlfile until cancel ;
> And then cancel recovery at some point in time before the crash.
>
> Did you loose all files after the crash ?
>

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

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 21 2005 - 16:32:29 CDT