RE: Move ALL Data from 1 Database into Another
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).
Re: Move ALL Data from 1 Database into Another
Hi Jeremiah 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. Are you sure about the one round trip thing. I may be mistaken but I must admit that has not been my experience. Are you thinking of occasions when you use a remote table (accessible via a DBLink) in a local join? In such cases the optimizer might set up the plan to get the remote rows individually rather than doing unproductive remote full or range scans. One would anticipate that a query like INSERT into localtable (select * from remotetable@link) would pull things over in a stream. OCI certainly streams query results like that - I'm not saying that DBLinks are based on OCI - just that there is precedent for this in at least one Oracle networking layer. Kind regards Dale -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Re: Move ALL Data from 1 Database into Another
On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote: Are you sure about the one round trip thing. Turns out you are right about not doing a single round-trip per row. My information was either outdated or apocryphal: SQL select value from v$sesstat ss, v$statname sn where sid = 31 and ss.statistic# = sn.statistic# and sn.name = 'SQL*Net roundtrips to/from dblink'; VALUE -- 0 SQL insert into foobar (select * from foobar@baz); 1660073 rows created. SQL select value from v$sesstat ss, v$statname sn where sid = 31 and ss.statistic# = sn.statistic# and sn.name = 'SQL*Net roundtrips to/from dblink'; VALUE -- 1925 (Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production) However, using DB links can never be as efficient as a parallel datafile copy followed by a near-zero downtime switchover. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton Hi Jeremiah Are you sure about the one round trip thing. I may be mistaken but I must admit that has not been my experience. Are you thinking of occasions when you use a remote table (accessible via a DBLink) in a local join? In such cases the optimizer might set up the plan to get the remote rows individually rather than doing unproductive remote full or range scans. One would anticipate that a query like INSERT into localtable (select * from remotetable@link) would pull things over in a stream. OCI certainly streams query results like that - I'm not saying that DBLinks are based on OCI - just that there is precedent for this in at least one Oracle networking layer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
Move ALL Data from 1 Database into Another
Qs What would be the FASTEST way to Load ALL Data from a Source Database Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ? NOTE - Creation Fresh (NEW) Database is a Must because Some of the Data Dictionary Objects have got Corrupted the Standard Migration of the Same Oracle 7 Database to Oracle 8i did NOT Correct the Corruption Either. Qs Would Creating a Database Link between the 2 Databases using CREATE TABLE TABLE NAME IN 8i DB NOLOGGING PARALLEL (DEGREE n) AS SELECT * FROM TABLE NAME IN 7.3.4 DB@DB_LINK be FASTER than taking Full Database Export (exp) of the Oracle 7 Database Importing (imp) to the Oracle 8i Database ? ASSUMPTION - Both Databases Exist on the SAME Storage Box thus on the Same Machine Thanks -- 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).
RE: Move ALL Data from 1 Database into Another
Vivek - If it is critical, I would test each alternative on a small amount of data. I have had pretty good results from the data link. Depending on the number of CPUs, you can run multiple imports or multiple data links simultaneously. Also watch your disk storage conflicts. For example, you wouldn't want the source tables and destination tables on the same disk. The more you can spread I/O the better because that is likely to end up as your bottleneck. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 13, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Qs What would be the FASTEST way to Load ALL Data from a Source Database Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ? NOTE - Creation Fresh (NEW) Database is a Must because Some of the Data Dictionary Objects have got Corrupted the Standard Migration of the Same Oracle 7 Database to Oracle 8i did NOT Correct the Corruption Either. Qs Would Creating a Database Link between the 2 Databases using CREATE TABLE TABLE NAME IN 8i DB NOLOGGING PARALLEL (DEGREE n) AS SELECT * FROM TABLE NAME IN 7.3.4 DB@DB_LINK be FASTER than taking Full Database Export (exp) of the Oracle 7 Database Importing (imp) to the Oracle 8i Database ? ASSUMPTION - Both Databases Exist on the SAME Storage Box thus on the Same Machine Thanks -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
Re: Move ALL Data from 1 Database into Another
No matter how you do it, do it in parallel. Export and import, or CTAS, by schema or tables so you can run them in parallel. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 7:03 PM Qs What would be the FASTEST way to Load ALL Data from a Source Database Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ? NOTE - Creation Fresh (NEW) Database is a Must because Some of the Data Dictionary Objects have got Corrupted the Standard Migration of the Same Oracle 7 Database to Oracle 8i did NOT Correct the Corruption Either. Qs Would Creating a Database Link between the 2 Databases using CREATE TABLE TABLE NAME IN 8i DB NOLOGGING PARALLEL (DEGREE n) AS SELECT * FROM TABLE NAME IN 7.3.4 DB@DB_LINK be FASTER than taking Full Database Export (exp) of the Oracle 7 Database Importing (imp) to the Oracle 8i Database ? ASSUMPTION - Both Databases Exist on the SAME Storage Box thus on the Same Machine Thanks -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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).
RE: Move ALL Data from 1 Database into Another
What about foreign keys, functions, procedures, synonyms, roles, grants and triggers (if any)? I've used the db link and it's faster than imp/exp but it doesn't do anything for other database objects. Also, if you do have foreign keys then a certain amount of pre-planning is necessary to move data in the right order. DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DWILLIAMS cc: @LIFETOUCH.COSubject: RE: Move ALL Data from 1 Database into Another M Sent by: root 11/13/2002 12:21 PM Please respond to ORACLE-L Vivek - If it is critical, I would test each alternative on a small amount of data. I have had pretty good results from the data link. Depending on the number of CPUs, you can run multiple imports or multiple data links simultaneously. Also watch your disk storage conflicts. For example, you wouldn't want the source tables and destination tables on the same disk. The more you can spread I/O the better because that is likely to end up as your bottleneck. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 13, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Qs What would be the FASTEST way to Load ALL Data from a Source Database Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ? NOTE - Creation Fresh (NEW) Database is a Must because Some of the Data Dictionary Objects have got Corrupted the Standard Migration of the Same Oracle 7 Database to Oracle 8i did NOT Correct the Corruption Either. Qs Would Creating a Database Link between the 2 Databases using CREATE TABLE TABLE NAME IN 8i DB NOLOGGING PARALLEL (DEGREE n) AS SELECT * FROM TABLE NAME IN 7.3.4 DB@DB_LINK be FASTER than taking Full Database Export (exp) of the Oracle 7 Database Importing (imp) to the Oracle 8i Database ? ASSUMPTION - Both Databases Exist on the SAME Storage Box thus on the Same Machine Thanks -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat
Re: Move ALL Data from 1 Database into Another
What about foreign keys, functions, procedures, synonyms, roles, grants and triggers (if any)? I've used the db link and it's faster than imp/exp but it doesn't do anything for other database objects. Also, if you do have foreign keys then a certain amount of pre-planning is necessary to move data in the right order. Actually in this case you can have your cake and eat it too. Use the freeware DBATool to generate the database recreation scripts. Run the the scripts to create all of the structure (including foreign keys, procedures, synonyms etc). The DBATool can also generate scripts to disable (and re-enable) all of the foreign keys. Disable the FK's, pull the table data across via one or more DBLinks and run the FK re-enable script when done. DBATool: http://www.DataBee.com/dt_home.htm Kind Regards Dale Edgar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Re: Move ALL Data from 1 Database into Another
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. 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. 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 On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote: What about foreign keys, functions, procedures, synonyms, roles, grants and triggers (if any)? I've used the db link and it's faster than imp/exp but it doesn't do anything for other database objects. Also, if you do have foreign keys then a certain amount of pre-planning is necessary to move data in the right order. Actually in this case you can have your cake and eat it too. Use the freeware DBATool to generate the database recreation scripts. Run the the scripts to create all of the structure (including foreign keys, procedures, synonyms etc). The DBATool can also generate scripts to disable (and re-enable) all of the foreign keys. Disable the FK's, pull the table data across via one or more DBLinks and run the FK re-enable script when done. DBATool: http://www.DataBee.com/dt_home.htm Kind Regards Dale Edgar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
RE: Move ALL Data from 1 Database into Another
Some of the Data Dictionary Objects are Corrupted in the Live Production Oracle 7 Database -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. 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. 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 On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote: What about foreign keys, functions, procedures, synonyms, roles, grants and triggers (if any)? I've used the db link and it's faster than imp/exp but it doesn't do anything for other database objects. Also, if you do have foreign keys then a certain amount of pre-planning is necessary to move data in the right order. Actually in this case you can have your cake and eat it too. Use the freeware DBATool to generate the database recreation scripts. Run the the scripts to create all of the structure (including foreign keys, procedures, synonyms etc). The DBATool can also generate scripts to disable (and re-enable) all of the foreign keys. Disable the FK's, pull the table data across via one or more DBLinks and run the FK re-enable script when done. DBATool: http://www.DataBee.com/dt_home.htm Kind Regards Dale Edgar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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). -- 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).
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 -- 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).
