Re: Interesting RMAN duplicate problem.

  • From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 27 Jan 2010 14:02:09 +0000

Hi,
If you try the "recover database until cancel" command in sql*plus, what
does it ask for?

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.

Regards

Pete

On Wed, Jan 27, 2010 at 1:42 PM, <oracle-l-bounce@xxxxxxxxxxxxx> wrote:

> Hi Chris,
>
> >> I know there's a hidden parameter to force open a database
> >> but I'm not sure if it has the same effect on an RMAN
> >> recovery as it does on a non-RMAN recovery.  I assume it would.
> Yes, the document mentioned by Martin (MOS note 465478.1) mentions "a
> hidden parameter" that can be used - I suspect this is the very one.
>
> Unfortunately, I'd really like to open this database in a valid and
> no-potentially-corrupt manner. The users need a full sized testing
> database for performance testing of a new release (coming soon!) and if
> it has the possibility of being "corrupted" then it's a worthless
> database.
>
> Thanks anyway.
>
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


-- 
Regards

Pete

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2010