Would there be any Performance Overhead in the Newly ATTACHED Oracle 8i Database after moving it to production ?
NOTE - Database Size 100 GB with 800 Concurrent Users Currently Are there any Other Pre-requisites / TO DOs to Allow Detaching of Application Tablespaces from the Previously Migrated Oracle 8i Database to the NEWLY Created 8i Database ? Sorry for the Ignorance -----Original Message----- Sent: Thursday, November 14, 2002 12:54 PM To: VIVEK_SHARMA Vivek, This transportable TBS option come with 8i onwards, and once you have migrated to 8i you can detach application tbs and attached these to new 8i database. Thanks & Regards, Vipin Jain -----Original Message----- From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 14, 2002 12:41 PM To: LazyDBA.com Discussion Subject: 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. 1. Make a hot backup or RMAN copy of the database, and start it under a different SID. 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 -------- Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
