Re: RMAN and re-do logs

From: joel garry <joel-garry_at_home.com>
Date: Wed, 15 Apr 2009 10:10:25 -0700 (PDT)
Message-ID: <8fcc693c-f942-484c-85c0-a06b6bb677b7_at_z8g2000prd.googlegroups.com>

On Apr 14, 8:44 am, chris.br..._at_providentinsurance.co.uk wrote:
> Oracle 10.2.0.4 production RAC on windows 2003 x 64
>
> We are completing a restore procedure that includes clearing out redo-
> logs from an ASM directory and doing the usual restore & recover
>
> For some reason we get a problem with redo / we do have to do rename
> the disk group as this has changed from source database to target
> database
>
> ORA-00313: open failed for members of log group 5 of thread 3
> ORA-00312: online log 5 thread 3: '+CLMREDOB/lvclaims/onlinelog/
> group_5.257.684071335'
>
> Please could someone explain at what point rman recreates redo and why
> we may be getting a problem
> / I am confident that the redo log directory does exist as we got
> round problem by using ...recover using from backup controlfile syntax
>
> cheers
> Chris B

I think you have people confused because the "usual restore and recover" doesn't mean destroying the online logs. So that's why people are asking if you are cloning. It's sounds to me like you are cloning, except back into the same place. So Michael's pointer to the docs ought to be correct. I think to finish John's suggestion, you would need to apply the redo as though it were archived, unless you are restoring a cold backup.

Please let us know.

jg

--
_at_home.com is bogus.
http://www3.signonsandiego.com/stories/2009/apr/15/1n15renters003434-renters-become-unwitting-victims/?uniontrib

Received on Wed Apr 15 2009 - 12:10:25 CDT