Everyone,

I need to make a copy of a database in 9G, and put it on another
server with 9i. Is there any problem with that ? Is 9G database
different than 9i ? The platform is Solaris. And what is the best
tool for this ? Will I use RMAN to take a backup, then restore it on
new server using RMAN again?

Thanks for helping out a newbie Oracle DBA. ~Richard

On Aug 21, 10:09*am, Richard <RSL...@gmail.com> wrote:
> Everyone,
>
> I need to make a copy of a database in 9G, and put it on another
> server with 9i. *Is there any problem with that ? *Is 9G database
> different than 9i ? *The platform is Solaris. And what is the best
> tool for this ? *Will I use RMAN to take a backup, then restore it on
> new server using RMAN again?
>
> Thanks for helping out a newbie Oracle DBA. *~Richard

Where did you obtain this Oracle 9G database? I don't find the
software listed for download at www.oracle.com.


David Fitzjarrell

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.


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

On Aug 21, 11:28*am, Richard <RSL...@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.
>
> 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

Presuming you have sufficient disk space there shouldn't be. But it
depends upon how you're going about this "make a copy of a database in
9G, and put it on another server with 9i." operation. If you're
trying to clone this database then you'll need to run the catpatch.sql
script to bring the catalog 'up to snuff' on the cloned database; this
requires you start the database in migrate mode, run the $ORACLE_HOME/
rdbms/admin/catpatch.sql script then run $ORACLE_HOME/rdbms/admin/
utlrp.sql to recompile all invalidated objects. If you're simply
using exp/imp to accomplish this then the catalog issue goes away (you
should already have an updated 9.2.0.4 catalog in your newly created,
empty database) and it becomes an issue of disk space and file system
configuration.

Since you're 'green' you may want to consider bringing in an
experienced hand to help you with this task.


David Fitzjarrell

Thank you, David.

Will RMAN be a better choice ? I dont want to have to recreate all
the users if I use exp/imp. That is - use RMAN for the round trip.
RMAN out the source db, RMAN into new oracle instance on target
server. Disk space not expected to be issue.

Appreciate the help so far. ~Richard.

On Aug 21, 9:28*am, Richard <RSL...@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