Home » RDBMS Server » Backup & Recovery » Can Oracle use recent build backup? (Oracle 10g SUN SPARK)
Can Oracle use recent build backup? [message #361308] Tue, 25 November 2008 19:41 Go to next message
crazypeter2005
Messages: 29
Registered: September 2008
Location: Peking China
Junior Member
In oracle 10g 10.2.0.3 sun spark OS,
I backup a DB after I shutdown DB.
I backuped 3 control files, 3 redo files, and all the datafile.

In normal state(no oracle update), I replace the control/redo/data file, and then I can start using the backup.


I wonder if I update to 10.2.0.4, can I use the backup which I backup in 10.2.0.3?

Or do I have to use dbua on 10.2.0.4 to update the backup DB then I can use it?
Similar, can I use a 9207 DB backup when I update to 9208?

Thanks!
Re: Can Oracle use recent build backup? [message #361311 is a reply to message #361308] Tue, 25 November 2008 20:58 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes, but you'll still have to run the necessary post-install scripts (ie. catupgrd.sql, etc.) on the 10.2.0.3 database once you restore it.

Check the readme that came with the patchset for the full procedures.
Re: Can Oracle use recent build backup? [message #361399 is a reply to message #361308] Wed, 26 November 2008 04:33 Go to previous message
crazypeter2005
Messages: 29
Registered: September 2008
Location: Peking China
Junior Member
I tried your solution:
If I start directly:
ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Then I tried these way to solved it:
1 SQL> startup upgrade
2 @?/rdbms/admin/catupgrd.sql -- this will keep for 20 mins around.
3 @?/rdbms/admin/utlrp.sql
4 select comp_name,version from dba_registry; and verify it works.
Thanks!
Previous Topic: catalog upgrade
Next Topic: ORA- 1427
Goto Forum:
  


Current Time: Mon Nov 25 18:01:18 CST 2024