RE: database degrade ???
Create a clone of 8.1.7 database (using cold backup or hot backup). Connect to the clone under 8.1.7 environment. Review and run Oracle's downgrade script $ORACLE_HOME/rdbms/admin/d080150.sql. Shutdown the clone. Create appropriate init.ora for the clone's 8.1.5 incarnation.. Setup env for 8.1.5 for clone. Adjust oratab, listener.ora etc. Startup the clone under 8.1.5. You may want to re-run catalog, catproc scripts.. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Leslie Lu [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 6:21 PM > To: Multiple recipients of list ORACLE-L > Subject: database degrade ??? > > Hi all, > > We installed 815, 817 on Sun 5.6. There is an 817 > database, and developers requested to build an exactly > same database but at 815 level. > > I don't think I can copy 817's backup files and create > a 815 db, since the backup already has 817 > characteristics. Is there a way to do degrade? > > If I create an 815 db, and do an export/import, how do > I make sure the dmp from 817 only have 815 > characteristics. Full db export won't work, is it? > And does schema export has nothing to do with Oracle > version, if so, I can use schema dmp file. > > Thank you! > > Leslie > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: database degrade ???
First of all, it is pain to several versions on the same box. I think export by schema owner will work. I think this is cleaner way. Bing -Original Message- Sent: Thursday, October 18, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Hi all, We installed 815, 817 on Sun 5.6. There is an 817 database, and developers requested to build an exactly same database but at 815 level. I don't think I can copy 817's backup files and create a 815 db, since the backup already has 817 characteristics. Is there a way to do degrade? If I create an 815 db, and do an export/import, how do I make sure the dmp from 817 only have 815 characteristics. Full db export won't work, is it? And does schema export has nothing to do with Oracle version, if so, I can use schema dmp file. Thank you! Leslie __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: database degrade ???
Title: RE: database degrade ??? > -Original Message- > From: Leslie Lu [mailto:[EMAIL PROTECTED]] > > We installed 815, 817 on Sun 5.6. There is an 817 > database, and developers requested to build an exactly > same database but at 815 level. > > I don't think I can copy 817's backup files and create > a 815 db, since the backup already has 817 > characteristics. Is there a way to do degrade? > > If I create an 815 db, and do an export/import, how do > I make sure the dmp from 817 only have 815 > characteristics. Full db export won't work, is it? > And does schema export has nothing to do with Oracle > version, if so, I can use schema dmp file. N.B. I have not tried the procedure below, we decided against the downgrade, but I was told that this note relates to Oracle 8.1.7 Oracle Metalink Note: 120912.1 Doc ID: Note:120912.1 Subject: Downgrade Scripts Oracle 8.X -> 8.X Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 28-SEP-2000 Last Revision Date: 10-NOV-2000 PURPOSE --- This note is purely a list of the scripts to run moving between Oracle 8 versions only. It is intended to be a quick reference guide to script names only. It is important to read current Oracle8 Server Migration Guide and the README.DOC and READMEMIG.DOC files supplied with the Oracle release that you wish to downgrade to. Important ~ Before downgrading or changing it is advisable to: o Make sure there are no PENDING transactions; o Shut down the database cleanly; o Take a full cold backup; Downgrade Scripts ~ Downgrading To Run Script 8.1.5 d0801050.sql 8.1.4 d0801040.sql 8.1.3 d0801030.sql 8.1.2 Not supported 8.1.1 Not supported 8.0.6 d0800060.sql 8.0.5 d0800050.sql 8.0.4S Not supported 8.0.4 d0800040.sql 8.0.3 d0800030.sql 8.0.2 Not supported 8.0.1 Not supported Note: If the release to which you are downgrading is not included, then see the README files in the new installation for the correct downgrade script to run. The following are notes about running the script: = * You must use the version of the script included with the release from which you are downgrading. * You must run the script in the environment of the release from which you are downgrading. * You only need to run one script, even if your downgrade spans several releases. For example, if you are downgrading to release 8.0.3, then you need to run only d0800030.sql. * If you are using mutually referencing types, then downgrading to release 8.0.3 or 8.0.4.0 is not supported. If you encounter any problems when you run the script, or any of the scripts in the remaining steps, then correct the causes of the problems and rerun the script. RELATED DOCUMENTS - Oracle8i Migration Guide, Chapter: Downgrading to an Older Version 8 Release