No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 9400
3 B. Vroman 4800
4 P. Wisse 4300
5 J. Schnackenberg 2900
6 J. PĂ©ran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48524
Total active users1409
Act. users last 24h3
Act. users last hour0
Registered user hits last week77
Registered user hits last month415
Go up

restore-recovery of old database
Next thread: rman performance
Prev thread: restore question

Message Score Author Date
Hi, I have rman backups of oracle 11.2.0.4 data...... Alain Bourgeois Jun 18, 2020, 13:39
Hi Alain <i>Is it supported to restore and reco...... Jan Schnackenberg Jun 18, 2020, 14:43
"But you'll then have to do the upgrade manually"....... Alain Bourgeois Jun 18, 2020, 15:21
Hi Alain, ok, again, yes and no. you can do ...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Jan Schnackenberg Jun 18, 2020, 16:09
So if I understand correctly, using oracle 12 I on...... Alain Bourgeois Jun 18, 2020, 16:17
Hi Alain, actually, now that we are talking abo...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Jan Schnackenberg Jun 18, 2020, 16:27
Yes I will try that. After this data will be migra...... Alain Bourgeois Jun 18, 2020, 16:42
Hi Alain, > So if I understand correctly, using...... Ales Kavsek Jun 18, 2020, 22:59

Follow up by mail Click here


Subject: restore-recovery of old database
Author: Alain Bourgeois, Belgium
Date: Jun 18, 2020, 13:39, 50 days ago
Os info: red hat linux 6
Oracle info: 11.2.0.4 / 12.2.0.1
Message: Hi,

I have rman backups of oracle 11.2.0.4 databases.
Is it supported to restore and recover them using oracle 12.2 / 18 /19 / 20, and to open the database without doing dbua?

Regards.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore-recovery of old database
Author: Jan Schnackenberg, Germany
Date: Jun 18, 2020, 14:43, 50 days ago
Message: Hi Alain

Is it supported to restore and recover them using oracle 12.2 / 18 /19 / 20

I'm not 100% sure about the restrictions on this being SUPPORTED. But it's POSSIBLE (and I've done this).


and to open the database without doing dbua?

Well, yes and no.

It's possible to open it without starting the dbua. But you'll then have to do the upgrade manually. It's not possible open an 11.2 database with 12.2/18/19/20 binaries without doing an upgrade.

Regards,
Jan
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore-recovery of old database
Author: Alain Bourgeois, Belgium
Date: Jun 18, 2020, 15:21, 50 days ago
Message: "But you'll then have to do the upgrade manually".
It's not possible open an 11.2 database.

Please explain. Is open Resetlogs allowed after recovery?

If yes, is it possible, after open resetlogs, to
* export
* read
* update data
using sql without doing a dbua?
What can be done after open and what cannot be done?
(a dbua might require some steps involving updates, removing packages, ...)

Thanks.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore-recovery of old database
Author: Jan Schnackenberg, Germany
Date: Jun 18, 2020, 16:09, 50 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hi Alain,

ok, again, yes and no.

you can do this, but as far as I know you'll only be able to open the database in UPGRADE mode.

Since you cannot do "ALTER DATABASE OPEN RESETLOGS UPGRADE" you'll first have do to "ALTER DATABASE OPEN RESETLOGS" which will do the resetlogs and then FAIL (crashing the instance, because the database is at the wrong version).

Then you'll have to "STARTUP UPGRADE" to then perform the upgrade of the database.

In UPGRADE mode the database will be OPEN but, you'll not be able to do much with it.

See https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/troubleshooting-oracle-database-upgrade.html#GUID-21A033B9-5994-4FFC-8D30-D0ABCBB1AC19 for some details.

Regards,
Jan
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore-recovery of old database
Author: Alain Bourgeois, Belgium
Date: Jun 18, 2020, 16:17, 50 days ago
Message: So if I understand correctly, using oracle 12 I only can do
ALTER DATABASE OPEN RESETLOGS;
and immediatly after
dbua

Better solution:
after restore:
shutdown immediate;
go to oracle 11
alter database open resetlogs;
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore-recovery of old database
Author: Jan Schnackenberg, Germany
Date: Jun 18, 2020, 16:27, 50 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Alain,

actually, now that we are talking about this a little more, I'm not even sure if DBUA is an option in this case. I believe DBUA needs the database that is supposed to be updated OPEN READ WRITE in the original ORACLE_HOME.

So, I think the only upgrade option would be the manual way.

But yes, the alternative MIGHT also work.

On the other hand: If you have the 11g ORACLE_HOME present anyway, why not do the OPEN RESETLOGS with an instance running from that ORACLE_HOME? I know that you couldn't do the restore/recover from 11g. But once that finished, you can just shutdown the instance, start it up from the 11.2 ORACLE_HOME and then do the OPEN RESETLOGS.

Regards,
Jan
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore-recovery of old database
Author: Alain Bourgeois, Belgium
Date: Jun 18, 2020, 16:42, 50 days ago
Message: Yes I will try that. After this data will be migrated somewhere else anyway.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore-recovery of old database
Author: Ales Kavsek, Slovenia
Date: Jun 18, 2020, 22:59, 49 days ago
Message: Hi Alain,

> So if I understand correctly, using oracle 12 I only can do
> ALTER DATABASE OPEN RESETLOGS;
>and immediatly after
> dbua

Jan is right, no, you can not simply open db with resetlogs on 12c, you'll get bootstrap error. You'll first have to open with:
startup upgrade

and then manually run the steps for upgrade (you can not use dbua).

See for example this old post (restoring 9i RMAN backup with 10g):

https://tinyurl.com/ybpdq8pk

No worries about supportability - restore of rman with newer version is supported.

Your proposed solution that you'll first restore with 12c, then open db with 11g instead sounds good. Imho, it should work and is actually smart "workaround".

Anyway, I understand that you're "angry" about Oracle, but I would not dismiss them as easily - if you explain the situation to them, they might just provide you with the patch you need to recover corrupted blocks, even if your company didn't pay for extended support.
After all, it's about company renomme that is at stake, especially in your case where engineered system is involved and where customer expectations are high. Providing a single patch and some pro bono support is cheaper than dealing with headline news how Oracle equipment was involved in catastrophic faiulire of some company.

Regards,
Ales

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here