| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Move ALL Data from 1 Database into Another
Forgive the previous incomplete post.
Hi Ankur
QS. After Migrating the Oracle 7 Database to 8i , Using Transportable Tablespaces Can one Simply use DETACH the Application Tablespaces (OTHER Than SYSTEM) & Attach them to the Newly Created 8i Database ?
Thanks Indeed
Hi Jeremiah
Some of the Data Dictionary Objects are Corrupted in the Live Production Oracle 7 Database & Even after Migration to Oracle 8.1.7.4 the Corruption Still persists .
Nevertheless I missed Some of your Points .
MY QUESTIONS(QS.) TO SOME OF YOUR POINTS ARE IN CAPITALS BELOW :- Thanks indeed
-----Original Message-----
Sent: Thursday, November 14, 2002 5:14 AM
To: Multiple recipients of list ORACLE-L
I don't like any of the suggestions so far, because they take more time than necessary. DB links do ONE ROUND TRIP for every row fetched! That is not efficient. Export is a nightmare of potential failures. I think you can devise the best solution by just copying the database files.
Try this idea on for size:
0. Make sure both versions of Oracle are installed on the host.
QS. CHANGING SID WOULD WARRANT A RESETLOGS . IS THAT CORRECT ? 2. Upgrade the copy to 8.1.7, but keep COMPATIBLE at 7.3.4.
3. Roll the copy forward to the current time using the logs generated by the old 7.3.4 instance, which is still in use.
QS. IS IT POSSIBLE TO APPLY REDO LOGS GENERATED FROM A DIFFERENT SID TO A NEW SID ? 4. Shut down the old instance, apply the last log to the new one, and restart the new one with COMPATIBLE = 8.1.7.
5. Replace the listener with an 8.1.7 listener pointing at the new instance.
This method gives you near zero downtime between kicking the users off the old database and letting them into the new one.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 14 2002 - 01:13:20 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |