Home » RDBMS Server » Server Administration » downgrading an upgraded database (9i to 8i,windows)
downgrading an upgraded database [message #401808] Wed, 06 May 2009 08:36 Go to next message
aviana
Messages: 101
Registered: July 2007
Senior Member
Hi
Please advise or give me useful docs to downgrading a database from 9i to 8i.
Original database was 8i (8.1.7) personal edition, which was upgraded to 9i(9.1.2.0) enterprise edition and the upgrade was done using DBUA
I had taken a full backup of the original 8i database in the PC before the upgrade.
Now there is only 1 database in the system which is version 9i.
I need this database back to 8i now.

So, is it possible to achieve this by restoring all the files from backup(Changing the new files back to the old one)?
What other changes should I make?
Re: downgrading an upgraded database [message #401809 is a reply to message #401808] Wed, 06 May 2009 08:38 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>What other changes should I make?
Restore 8i DB from backups
Re: downgrading an upgraded database [message #401815 is a reply to message #401809] Wed, 06 May 2009 08:59 Go to previous messageGo to next message
aviana
Messages: 101
Registered: July 2007
Senior Member
Hi, Do you mean just physically copy the files to original location(replacing the new 9i ones with the old ones) and nothing else need to be done?
My doubt is:
1)Whatever I have done extra, needs to be reverted right?
2)How does the database version changes from 9i to 8i , by simply restoring the old files?

[Updated on: Wed, 06 May 2009 10:17]

Report message to a moderator

Re: downgrading an upgraded database [message #401867 is a reply to message #401815] Wed, 06 May 2009 13:13 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
You binaries need to be restored/installed too. Why would you go from one unsupported version of Oracle to an even older unsupported version?

What do you mean "Whatever I have done extra, needs to be reverted?" Simple restore the old version and you are back to where you started.

If you think you can just take your datafiles from 9i and have them work in 8i, you are mistaken.

export/import is how you would move your data, but you would need to export with the 8i binary against the 9i database.
Previous Topic: Login Hang
Next Topic: file missing
Goto Forum:
  


Current Time: Tue Dec 06 13:59:15 CST 2016

Total time taken to generate the page: 0.11898 seconds