Re: Interesting RMAN duplicate problem.
Date: Wed, 27 Jan 2010 14:55:32 +0000
Message-ID: <5e317f311001270655s38a79fe9n18767f593c94cdc6_at_mail.gmail.com>
Hi,
Did you check to make sure that you are using a backup of the control file taken during the hot backup, I think this could mean you have a too recent copy of the control file.
Regards
Pete
On Wed, Jan 27, 2010 at 2:12 PM, Dunbar, Norman < norman.dunbar_at_environment-agency.gov.uk> wrote:
> Hi Pete,
>
> >> If you try the "recover database until cancel" command in
> >> sql*plus, what does it ask for?
> A missing log file that I do not have - sequence 675041. This is higher
> than the range of sequences in the archivelog backup - 674565 - 674627.
>
> >> Also databases opened with the parameter
> >> _alow_resetlogs_corruption, Chris referenced, are usually OK
> >> for use, its just that you cannot back them up and restore
> >> them again, you have to re-create them, not an issue for you.
> Yes, an export takes 50 hours and an import takes a week. There are
> billions of rows in some tables, plus, a lot of IOTs. We did one just
> before christmas - it wasn't fun!
>
> Cheers,
> Norman.
>
>
> Norman Dunbar
> Contract Oracle DBA
> CIS Engineering Services
> Internal : 7 28 2051
> External : 0113 231 2051
>
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else. We have
> checked this email and its attachments for viruses. But you should still
> check any attachment before opening it. We may have to make this message and
> any reply to it public if asked to under the Freedom of Information Act,
> Data Protection Act or for litigation. Email messages and attachments sent
> to or from any Environment Agency address may also be accessed by someone
> other than the sender or recipient, for business purposes. If we have sent
> you information and you wish to use it please read our terms and conditions
> which you can get by calling us on 08708 506 506. Find out more about the
> Environment Agency at www.environment-agency.gov.uk
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else.
>
> We have checked this email and its attachments for viruses. But you should
> still check any attachment before opening it.
> We may have to make this message and any reply to it public if asked to
> under the Freedom of Information Act, Data Protection Act or for litigation.
> Email messages and attachments sent to or from any Environment Agency
> address may also be accessed by someone other than the sender or recipient,
> for business purposes.
>
> If we have sent you information and you wish to use it please read our
> terms and conditions which you can get by calling us on 08708 506 506. Find
> out more about the Environment Agency at www.environment-agency.gov.uk
>
-- Regards Pete -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 27 2010 - 08:55:32 CST