Hello John,
if you migrate to 9i or 10g is one of the hard questions that has to be
answered by you and your organisation. On metalink there is more help to
be found on 9i than on 10g, and 9i is going to be around for at least 3
more years, since Oracle has not yet issued a desupport notice. We are
running 2 Oracle 9.2.0.5 databases on Solaris (one in standard
configuration, and one in RAC configuration), which where installed
without any problems (9.2.0.1 followed by upgrade to 9.2.0.5) apart from
the sad fact that the Installer that comes with 9.2.0.5 does not start,
but then you can use the Installer from 10g to install the 9.2.0.5
Installer.
However, the work to be done is the same.
I don't assume that you have 450+ Gb unused diskspace, so the
export/import model is not feasible.
What I would do is the following:
Create an empty database on the Solaris. I would initially put the Solaris
database in NOARCHIVELOG mode, because you don't want to create 300+ GIG
of redo logs. I would then use export to extract the users and data object
structures (ROWS = N) from the SGI system, and import that information to
the Solaris system.
Then for each schema with data I would do an INSERT INTO table SELECT *
FROM [Email Address Removed] using a database link. This is going to take some time and
I can only hope that you have at least a 100 Mb connection between the
machines. This is going to take you a weekend to move the data.
Once all that is done, and all the invalid objects have been fixed, then
you shutdown the database and DO A COLD BACKUP.
After this point you can start thinking about changing the user
connections, so that they hit the new database when they connect, and
start thinking about daily and weekly backups using RMAN.
No matter how you do it, please remember the 6 P's: Proper Prior Planning
Prevents Poor Performance. And keep at each step a fallback option open,
you may need it for some reason.
Best of luck
Henrik Tuxen
DBA
"John DeUnger " <oracledba-ezmlmshield-x86680510.[Email address protected]
06.10.2004 23:20
An: "LazyDBA Discussion" <[Email address protected]
Kopie:
Thema: 8.1.6 to 9.2.0.4 migration ? [Virus checked]
This is a upgrade question. We're running 8.1.6 on SGI.
Oracle discontinued SGI support a while back. I was told
by the program manager how do we get this to a Solaris machine ?
This s a 300 GIG database - production. We had planned to
go to 8.1.7 but now the terminal release is 8.1.7.4.
If you were building a new system on Solaris I am thinking that I'd
like at least 9.2.0.4.
What steps would you take on the old system and new to get there ?
Do you have to go to 8.1.7.4 on the old first, Can you use
RMAN then to duplicate the database on Solaris using a 8.1.7.4 base
for a 9.2.0.4 system. I need a plan to do this.
Appreciate any ideas you can share.
John DeUnger
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
____________________________________________________________________________
Deutscher Sparkassen Verlag GmbH
Am Wallgraben 115
D-70565 Stuttgart
Telefon: +49 711 782-0
http://www.dsv-gruppe.de
____________________________________________________________________________
Dieses E-Mail einschliesslich evtl. angehaengter Dateien enthaelt vertrauliche
und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige
Adressat sind und Sie dieses E-Mail irrtuemlich erhalten haben, duerfen Sie
weder den Inhalt dieses E-Mails nutzen noch duerfen Sie die evtl.
angehaengten Dateien oeffnen und auch nichts kopieren oder
weitergeben/verbreiten.
Bitte verstaendigen Sie den Absender und loeschen Sie dieses E-Mail und evtl.
angehaengte Dateien umgehend. Vielen Dank!
____________________________________________________________________________
Oracle LazyDBA home page