Help w/ RMAN....

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 <mailto:mark.bobak_at_il.proquest.com> 
www.proquest.com <http://www.proquest.com> 
www.csa.com <http://www.csa.com> 

ProQuest...Start here. 

 


--
http://www.freelists.org/webpage/oracle-l