Home » RDBMS Server » Backup & Recovery » Restore from previous version
Restore from previous version [message #162958] Tue, 14 March 2006 06:06 Go to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
Ok i need a bit of clarification.

5th January - A backup is made of the data on a database running Oracle 9.2.0.1

15th January - The database is then upgraded to version 9.2.0.5


Can the tape made on 5th of january be used to restore teh database now running 9.2.0.5?

[Updated on: Tue, 14 March 2006 06:31]

Report message to a moderator

Re: Restore from previous version [message #163139 is a reply to message #162958] Wed, 15 March 2006 01:04 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
I don't think you can do that.

Alex zeng | Skype me: hans9zeng
Re: Restore from previous version [message #163382 is a reply to message #162958] Thu, 16 March 2006 09:03 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
It depends on what kind of backup you took.
Export from previous version can be imported on new version database.

Instead, if you backed up datafiles and control files..mmm. I don't know, it might work, but i don't know what consequences could be.

I believe that upgrades from 9.2.x.x to 9.2.y.y only updates data in specific dictionary tables and internal packages and things like that. Besides, it updates some oracle binaries files.

Hope it helps.
Re: Restore from previous version [message #223247 is a reply to message #163382] Thu, 08 March 2007 02:52 Go to previous message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi,

It always advisable to take a OS and db backup once it was upgraded and move to some other place.

Previous Topic: - basic question, RMAN steps & view ER dig -- (won't be difficult)
Next Topic: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Goto Forum:
  


Current Time: Tue May 14 23:37:29 CDT 2024