Re: Is there any problem restoring database from 9G to 9i

On Aug 21, 9:28 am, Richard <RSL..._at_gmail.com> wrote:
> SQL> connect / as sysdba
> Connected.
> SQL> quit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
> Production
> With the Partitioning, Real Application Clusters, OLAP and Oracle Data
> Mining options
> JServer Release 9.2.0.1.0 - Production
>
> Hmm...it is 9i. Then the mystery deepens. We deployed the db on a RAC
> cluster. I presumed it had to be a G (for grid configuration ), but
> maybe RAC is not Grid and Grid only found in Oracle 10 ?  Like I said
> I inherited this Oracle system from someone else who's left the
> company and I am just starting to get familiar with Oracle.

"The grid" is just a bunch of marketing BS. When posting here, the important thing is to post the exact version(s) like 9.2.0.4.0.

>
> Also the new server i need to restore to is:
>
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 -
> Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.4.0 - Production
>
> Not exact version, is there a problem ?   Thanks Richard

Yes. You should find the patch readme on the 9.2.0.4.0 db, and look at the part about "upgrade the database," which mentions running a couple of scripts like catpatch and utlrp. If you can't find the readme, go to metalink.oracle.com and click on the patches tab, then find your patch if you can. You should probably open a Service Request to have support walk you through this the first time.

If restoration is what you really want to do. The information you've posted so far is insufficient to determine that.

First of all, are you using the Oracle definition of "database?" I ask because many newbies here don't, and are really referring to a schema, instead. What exactly are you trying to accomplish? If you are just moving data, you should perhaps use the exp/imp tools, which are better about being blind to slight version differences (or major version or platform differences, with some caveats). There are also other methods, such as unloading to a flat file and using sqlloader, or dblinks for direct transfer.

The normal purpose of restoration is to lead to a recovery, which usually means something like you need to keep from losing a bunch of transactional data. Another normal purpose would be cloning for testing/development purposes. The latter may be further constrained if you have some app that has special requirements. So, what are you trying to achieve? For my particular obscure enterprise app, I pretty much have to use a moderately complicated process together with exp/ imp.

jg

--
@home.com is bogus.  "I divide my officers into four classes; the
clever, the lazy, the industrious, and the stupid. Each officer
possesses at least two of these qualities. Those who are clever and
industrious are fitted for the highest staff appointments. Use can be
made of those who are stupid and lazy. The man who is clever and lazy
however is for the very highest command; he has the temperament and
nerves to deal with all situations. But whoever is stupid and
industrious is a menace and must be removed immediately." - Kurt von
Hammerstein-Equord