|Answers To FAQ For Restoring Or Duplicating Between Different Versions And Platforms [ID 369644.1]|
|Modified 23-AUG-2011 Type FAQ Status PUBLISHED|
In this Document
Questions and Answers
1) Can I restore or duplicate my previous version database using a later version of Oracle?
2) Can I restore or duplicate between two different patchset levels?
3) Can I restore or duplicate between two different versions of the same operating system?
4) Is it possible to restore or duplicate when the bit level (32 bit or 64 bit) of Oracle does not match?
5) Is it possible to restore a later version backup to an earlier version of Oracle?
6) Can I restore or duplicate my RMAN backup between two different platforms such as Solaris to Linux?
RMAN can restore a backup taken on an older database release into a
newer release. The older backups must be taken on 9.2 or later release.
This method can be used as part of an out-of-place database upgrade, in which the older backups are restored to the newer release database and then the upgrade scripts are run as normal. Since the older database can remain online during the upgrade, this may be preferable to an in-place upgrade, where the database must remain offline.
For example, I want to upgrade a 10.2 database to 11.2, using backups taken on the 10.2 database. The 11.2 database will reside on a new host.
The steps are:
1. Install 11.2 binaries and latest patch sets on new host and prepare the 11.2 Oracle home per this doc.
2. Allow disk and/or tape backups to be accessible from the new host.
3. Restore backups to the 11.2 database and recover the database to a consistent point-in-time per this doc. Do not open the database at this time.
4. Manually upgrade the 10.2 database to 11.2 per the instructions in this doc, starting from the point immediately after the 11.2 software has been installed.
Note: the above procedure is for restoring a 10.2 database that had never been upgraded to 11.2. If the database has already been upgraded, and you need to restore a backup that was created while the database was running as 10.2, you just need to restore and recover it, and media recovery will replay everything done by the upgrade.
RMAN "duplicate" is not supported as it will fail attempting to automatically open the database after recovery (step #3).
As you can restore between different Oracle version, you can also
do so between two different patchset levels. See question #1 for
Because RMAN "duplicate" attempts to
automatically open the database you may not use RMAN duplicate for this
case, only RMAN restore.
For example, can I restore my 188.8.131.52.0 RMAN backup taken against a
host running Solaris 9 to a different machine where 184.108.40.206.0 is
installed but where that host is running Solaris 10?
If the same Oracle Server installation CDs (media pack) can be used to install 220.127.116.11.0 on Solaris 9 and Solaris 10, this type of restore is supportable.
For example, is it possible to restore or duplicate my 9.2. 64-bit database to a 9.2.32-bit installation?
It is preferable to keep the same bit version when performing a
restore/recovery. However, excluding the use of duplicate command, the
use of the same operating system platform. should allow for a
restore/recovery between bit levels (32 bit or 64 bit) of Oracle. Note,
this may be specific to the particular operating system and any problems
with this should be reported to Oracle Support.
If you will be running the 64-bit database against the 32-bit binary files or vice versa, after the recovery has ended the database bit version must be converted using utlirp.sql.
See this note for details on switching between bit sizes:
Note 62290.1 Changing between 32-bit and 64-bit Word Sizes
If you do not run utlirp.sql you will see errors including but not limited to:
ORA-06553: PLS-801: INTERNAL ERROR 
In general, you cannot restore or duplicate between two different platforms.
In versions previous to 10g the only option to migrate from one
platform. to another was using export / import. With 10g, using the RMAN
convert commands, you can cross between platforms using the 10g
Cross-Platform. Transportable Tablespaces option. For more details review
Note 243304.1 Transportable Tablespaces Across Different Platforms
In version 10.2 and later if the source and target OS are the same endian you may issue a "CONVERT DATABASE" so that datafiles are converted and ready for transport to the destination machine. For more details about "CONVERT DATABASE" see:
Oracle Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)
Chapter 15, RMAN Cross-Platform. Transportable Databases and Tablespaces
There are also 3rd party applications for migration between
platforms such as VERITAS Storage Foundation portable data containers:
(Contact Veritas for information about VERITAS Storage Foundation portable data containers)
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11780477/viewspace-705664/，如需转载，请注明出处，否则将追究法律责任。