Oracle-L: RE: Move ALL Data from 1 Database into Another

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 13 Nov 2002 23:48:40 -0800
Message-ID: <F001.00503046.20021113234840@fatcity.com>

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:VIVEK_SHARMA_at_infosys.com]
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.

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 oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com 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: VIVEK_SHARMA_at_infosys.com

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: 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:48:40 CST