Re: Is there any problem restoring database from 9G to 9i
Date: Thu, 21 Aug 2008 11:12:11 -0700 (PDT)
On Aug 21, 9:28 am, Richard <RSL..._at_gmail.com> wrote:
> SQL> connect / as sysdba
> SQL> quit
> Disconnected from Oracle9i Enterprise Edition Release 18.104.22.168.0 -
> With the Partitioning, Real Application Clusters, OLAP and Oracle Data
> Mining options
> JServer Release 22.214.171.124.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 126.96.36.199.0.
> Also the new server i need to restore to is:
> Disconnected from Oracle9i Enterprise Edition Release 188.8.131.52.0 -
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 184.108.40.206.0 - Production
> Not exact version, is there a problem ? Thanks Richard
Yes. You should find the patch readme on the 220.127.116.11.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.
-- @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-EquordReceived on Thu Aug 21 2008 - 13:12:11 CDT