Re: Standby database looking for old archive

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Mon, 25 Feb 2008 11:11:31 -0500
Message-ID: <74f79c6b0802250811j5e748bf4u7eb4e8ca38b884d5@mail.gmail.com>


kathy,

You don't say this, so I'm going to ask. After you put the tablespaces in hot backup mode and copied them over, did you also copy over archive logs since putting the tablespaces in backup mode up until after you took them back out of backup mode and applied them to the standby? (I know it's obvious, but sometimes....)

Finn

On 2/25/08, kathy duret <katpopins21_at_yahoo.com> wrote:
>
> Sorry I forgot 9i on Windows
>
> and when I do a recover standby database it gives me
>
> ORA-01194: file system needs more recovery to be consistent
>
> I already put that tablespace into backup mode and recopied it over again
>
> still the same deal.
>
> K
>
> *kathy duret <katpopins21_at_yahoo.com>* wrote:
>
> My brain isn't working... I know there is an easy way to determine what I
> screwed up...
>
> Anyway... my standby database got corrupted so I put did a hot backup and
> had to copied over all the files this weekend.
>
> Created a new standby controlfile.
>
> Started up the standby and it is asking for an old archive log.
>
> I thought I did this before and figured out which datafile wasn't copied
> correctly, put the tablespace in backup mode and recopied it over and voila
> it worked.
> But for the life of me I can't remember how I did this the last time...
> old age I guess...
>
> I don't want to have to copy the whole thing over again.
>
> Any one have any ideas?
>
> Thanks,
>
> Kathy
> ------------------------------
> Looking for last minute shopping deals? Find them fast with Yahoo! Search.<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping>
>
>
> ------------------------------
> Looking for last minute shopping deals? Find them fast with Yahoo! Search.<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 25 2008 - 10:11:31 CST

Original text of this message