Re: 8i and 9i rman catalog databases

danthefirst2000_at_yahoo.com wrote in message news:<f5e9c941.0412021404.162e7f80_at_posting.google.com>...
> Guys,
>
> If you have 9i and 8i databases do you need 2 rman catalog databases?
> Because when I run a backup for 8i database (rman catalog is 9i) it
> throws the error as below. This suggests to me that the export stage
> is failing due the current Oracle home being Oracle 8 rather than 9
> and, consequently, not having the libraries necessary for RMANCAT's
> "exp" command to link to.
> This is rather annoying...
>
> Any suggestions?
>
> We use OS-HPUX 11.00 and omniback data protector
>
>
> Oracle8CatalogBackup[48]: 26448 Killed
> [Major] From: ob2rman.exe_at_host "DBNAME" Time: 12/02/04 16:39:42
> Export of the Recovery Catalog Database failed.
>
>
> thnaks
> dan

http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=125303.1 section 11 says you should use nocatalog or a second catalog to backup the catalog database.

Unless I'm really mis-reading your error message. Are you sure you are backing up the 8i database? It looks like the message says you are backing up the catalog. Maybe it would be more clear if you give the commands you are using. It's been long since I've seen omniback, are you selecting something off a screen? I vaguely recall you could look at the command file omniback is generating, but if not, the commands should be in the logs.

Or maybe you have a forgotten catalog in 8i?

jg

--
@home.com is bogus.
Police on ebay:  http://www.signonsandiego.com/uniontrib/20041203/news_7m3former.html