
	Home > Ask the Oracle Experts > Database Backup and Recovery Questions & Answers > Manual upgrade vs. export and import

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Manual upgrade vs. export and import

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 10 March 2008
I am ready to upgrade. My database size is 200gb and it is an unsupported version of Oracle to upgrade to 10g(8.1.6.2 to 10g). It's O/S is on HP-UX, so could you tell me whether the best process for upgrade is to follow the manual upgrade process or by using the export & import to the new Oracle Database? If I follow the manual method then I have to apply the 8i to 8i Patches then to 10g . If I follow exp/imp then I need more down time. Which process should I follow?

Also, after applying the patchset of 8.1.7 on 8.1.6 database, we upgrade the database to 8.1.7 manually, we are saying that direct upgrade is possible from 8.1.7.4 to 10g. I want to ask you whether there is no need of applying 10g patchset at os level on 8.1.7.4 to upgrade 10g. Is it possible to upgrade the 10g database without applying 10g patchset at os level?

EXPERT RESPONSE
If you perform the manual upgrade process, then you will have to be at least at Oracle 8.1.7 before you can begin. So to go from 8.1.6.2 to 10g, you will need two upgrades with this path. If you use export/import, then you will only need one upgrade. On average, each manual upgrade will take about 1 hour, but this time can vary. So without knowing more about your environment, the manual upgrade process will require about 2 hours of downtime. Using export/import for a 200GB database will probably take longer. So the big question to answer here is how much downtime can you take for the upgrade? If you had a larger downtime window, then you might use exp/imp for the upgrade. The exp/imp method also lets you perform some reorganization like moving objects to new tablespaces.

You do not need to apply any 10g patchsets before you do the upgrade. This is not a requirement.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Database Backup and Recovery
	How to recover a control file
	The USING BACKUP CONTROLFILE clause in Oracle commands
	Backup and recoveries of Oracle RAC 10gR2
	Backup and recovery of Oracle 10g with forgotten admin password
	How to use the OPatch Utility in Oracle
	How to get history of modified data from Oracle databases
	Export dump with files larger than 2 GB
	What is Unix shell scripting?
	Performing a backup with table locks
	How to move data faster with a database link

Oracle database administration (DBA)

Why am I getting an Oracle error when issuing the RECOVER DATABASE command?

Can I add multiple datafiles and make use of all the temporary datafiles at the same time?

Checkpoint vs. commit process

What's the best tape backup strategy for 10g RAC?

Can I resize the SYSTEM tablespace?

How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?

How to recover a control file

The USING BACKUP CONTROLFILE clause in Oracle commands

Backup and recovery of Oracle 10g with forgotten admin password

How to use the OPatch Utility in Oracle

Oracle database administration (DBA) Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy