Re: Help w/ RMAN....

From: Prasad <p4cldba_at_gmail.com>
Date: Tue, 8 Jan 2008 12:36:15 -0800
Message-ID: <666b99c70801081236s42f8947dwc524eec8088711f9@mail.gmail.com>


Hi Mark,

This error

RMAN-20088: Message 20088 not found; product=RDBMS; facility=RMAN

seems to be coming for different RMAN software version between the rman used for the backup you have and the restore you are doing . in this case you might do a disaster recovery first and then do the upgrade .

hth
-Prasad

On Jan 8, 2008 9:07 AM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:

> Hi,
>
>
>
> Wondering if anyone can help me here. I have a 9.2.0.6 database running
> 64-bit on Sparc Solaris, that I want to upgrade to 10gR2 (10.2.0.3). So,
> I install 10.2.0.1, patch up to 10.2.0.3, start upgrade. Run into bug
> 5752399, where Oracle can't write to a VxFS filesystem. Track that down,
> get it straightened out. Restart upgrade, this time I hit bug 5755471,
> which causes upgrade to blow up (OERI[22635]) if you're upgrading with64-bit
> Oracle, if the database was originally created as 32-bit, even if it's most
> recent previous release was already 64-bit. If 32-bit was in it's history,
> this bug pops up. I track down a patch for this one, it says to "apply the
> patch BEFORE the upgrade"..I'm thinking, ok, little late to mention that
> now, don't you think!?!?
>
>
>
> So, here I am. I have a valid backup, or at least I think I do.
>
>
>
> So, I do:
>
> (w/ 10g environment)
>
> Sqlplus / as sysdba
>
> Shutdown immediate
>
> Exit
>
> (edit /var/opt/oracle/oratab set back to 9i home)
>
> . oraenv
>
> Sqlplus "/ as sysdba"
>
> Startup nomount
>
> Exit
>
> Rman target / catalog rman/password_at_rmancat
>
> run {
>
> allocate channel t1 type 'sbt_tape';
>
> restore controlfile; --I was running the catupgrd script when the error
> occurred, so, I assume I need to restore a 9i controlfile.
>
> Sql "alter database mount";
>
> Restore database until time '2007-01-09 14:30:00';
>
> Recover database until time '2007-01-09 14:30:00';
>
> Release channel t1;
>
> }
>
>
>
> And it seems to work, initially, and restores the controlfile successfully
> and mounts it.
>
>
>
> But, then when it's time to do the restore, I get:
>
> RMAN-00571: ===========================================================
>
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>
> RMAN-00571: ===========================================================
>
> RMAN-03002: failure of allocate command at 01/08/2008 11:43:04
>
> RMAN-03014: implicit resync of recovery catalog failed
>
> RMAN-03009: failure of partial resync command on default channel at
> 01/08/2008 11:43:04
>
> RMAN-20088: Message 20088 not found; product=RDBMS; facility=RMAN
>
>
>
> There's a brief reference to RMAN-20088 in MetaLink, but it's having to do
> w/ 10gR1 and 10gR2, and Google was useless.
>
>
>
> If I try to explicitly resync, I get:
>
> RMAN> resync catalog;
>
>
>
> RMAN-00571: ===========================================================
>
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>
> RMAN-00571: ===========================================================
>
> RMAN-03009: failure of resync command on default channel at 01/08/2008
> 12:00:28
>
> ORA-00236: snapshot operation disallowed: mounted controlfile is a backup
>
>
>
> If I try:
>
> RMAN> resync catalog from controlfilecopy
> '/oracle/product/9.2.0/dbs/snapcf_inpdvl.f';
>
>
>
> I get:
>
> RMAN-00571: ===========================================================
>
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>
> RMAN-00571: ===========================================================
>
> RMAN-03009: failure of resync command on default channel at 01/08/2008
> 12:01:29
>
> RMAN-20034: resync not needed
>
>
>
> And the other commands continue to fail.
>
>
>
> So, I'm at a loss. I'll open an SR if I have to, but if someone can slap
> me upside the head and point me in the right direction, I'd be grateful.
>
>
>
> Thanks!
>
>
>
> -Mark
>
>
>
> *--
> Mark J. Bobak*
> *Senior Database Administrator, System & Product Technologies*
> ProQuest
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> mark.bobak_at_il.proquest.com
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 08 2008 - 14:36:15 CST

Original text of this message