Migracion de 8i a 10GR1
Via METALINK... completito This is a step by step guide that explains how we can migrate a database to a new server and database release manually using a Cold backup. How to do a cold backup of oracle database and restore it on the new server and then upgrade it. Solution 1) Prerequisites ---------------- - The copy of the datafiles must be done with the database closed. - Source Operating System and destination Operating System need to be the same - Destination sever need to have the 10g installed with the same word size as the 8.1.7.4. Both need to be 32 bit or both need to be 64 bit. - If your database contains user tables with NCHAR columns, you must upgrade the NCHAR columns before they can be used . In the database documentation you have all the steps is detail: Oracle® Database Upgrade Guide 10g Release 2 (10.2) Part Number B14238-02 2) Init.ora or spfile and controlfile ---------------------------------- - You need to copy th...