OraFAQ Forum: Backup & Recovery » Can Oracle use recent build backup?

Home » RDBMS Server » Backup & Recovery » Can Oracle use recent build backup? (Oracle 10g SUN SPARK)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can Oracle use recent build backup? [message #361308]

Tue, 25 November 2008 19:41

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!

Report message to a moderator

Re: Can Oracle use recent build backup? [message #361311 is a reply to message #361308]

Tue, 25 November 2008 20:58

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.

Report message to a moderator

Re: Can Oracle use recent build backup? [message #361399 is a reply to message #361308]

Wed, 26 November 2008 04:33

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!

Report message to a moderator

Previous Topic:	catalog upgrade
Next Topic:	ORA- 1427

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 01:54:57 CDT 2024