Raj,
if it is a smallish database (or it is running on a fast server). You might
be able to create a separate 8.0.6 instance and leave it running with all
the accounts tablespaces etc. Then if the need arises you do an export from
the new version and import into the old version with the full option. If
that will take too long, you can perform the Downgrade procedure as
specified in chapter 13 of the Oracle 8.1.7 Migration book (id A86632-01).
This describes going through a downgrade by basically removing the
incompatible parameters and running the cat*.sql scripts again for the
older version, check out the document though as this is a lengthy procedure
and needs a bit of planning ahead, for cold backups and what not.
Good luck,
Amr
Rajesh.Rao@jpmch
ase.com To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Degrade a database??
09/27/02 11:18
AM
Please respond
to ORACLE-L
Raj,
The customer needs a fallback strategy with "no data loss" upto 3 weeks
after the cutover.
Thanks
Raj
One attachment (0k)
"Jamadagni,
Rajendra" To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
<Rajendra.Jamadagni cc:
@espn.com> Subject: RE: Degrade a
database??
Sent by:
[EMAIL PROTECTED]
September 27, 2002
10:18 AM
Please respond to
ORACLE-L
I have no fresh ideas but how about keeping a file system backup of your
oracle installation and 3 copies (in different locations of course) of a
complete cold backup before the upgrade?
Or copy the existing database on a similar but separate machine, ready to
be brought up, all you need is TNS change.
Raj
--
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: Amr Hambazaza
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).
