Go up

Next thread:	Connection Management Call Elapsed Time in AWR Report quite high
Prev thread:	RMAN ckpn SCN and cumulative differential backup

Message	Score	Author	Date
Hi, I have an old hardware, linux 6, oracle 11.2.......		Alain Bourgeois	Aug 11, 2020, 15:48
Instead of restoring the (rman?) backup, create ......		Michel Cadot	Aug 11, 2020, 17:15
Not possible: the db is several Tb big and downtim......		Alain Bourgeois	Aug 11, 2020, 17:22
You have few choices. You can't do as you want ......		Michel Cadot	Aug 11, 2020, 17:42
Hi Alain, why do you want to mess with 11g inst......		Ales Kavsek	Aug 12, 2020, 22:10
"open database with upgrade option" Do you mean t......		Alain Bourgeois	Aug 13, 2020, 09:09
Hi Alain, it's explained in this thread: htt......		Ales Kavsek	Aug 14, 2020, 08:43
The example in this thread is talking about a "col......		Alain Bourgeois	Aug 14, 2020, 09:38
Hi, ok, perhaps I was not clear enough in my po......		Ales Kavsek	Aug 14, 2020, 12:03
Nope, it is not the same db nor the same hardware.......		Alain Bourgeois	Aug 14, 2020, 12:34
Hi, yes, this is the path that I would consider......		Ales Kavsek	Aug 14, 2020, 13:13

Follow up by mail

Click here

---

Subject:	oracle 11.2.0.4 on linux 8
Author:	Alain Bourgeois, Belgium
Date:	Aug 11, 2020, 15:48, 45 days ago
Os info:	OEL 8
Oracle info:	11.2.0.4 SE
Message:	Hi, I have an old hardware, linux 6, oracle 11.2.0.4 SE. New hardware is ready to install and apps are 12.2 compatible, so the plan would be to install new hardware with: * Linux 8 * grid 19.8 * oracle db 11.2.0.4 * oracle db 19.8 then restore 11 backup, dbua 19.8, remove 11g. Problem: according to https://www.guj.com.br/t/erro-na-instalacao-do-oracle-11g-no-oracle-linux-8-instalei-o-java-13-na-maquina/399769, oracle 11 will refuse to install on linux 8. Does someone have a hint to make it run, just the time needed to do restore, recover, open resetlogs (db is several Tb so restore and recover will take several days)? (I would like to avoid linux 7 upgrade to 8, and want to leave old system intact until end of upgrade process). Thanks.
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Michel Cadot, France
Date:	Aug 11, 2020, 17:15, 45 days ago
Message:	Instead of restoring the (rman?) backup, create a Data Pump dump and import it in a newly created 19c db. Regards Michel
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Alain Bourgeois, Belgium
Date:	Aug 11, 2020, 17:22, 45 days ago
Message:	Not possible: the db is several Tb big and downtime is limited to a few hours.
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Michel Cadot, France
Date:	Aug 11, 2020, 17:42, 45 days ago
Score:
Message:	You have few choices. You can't do as you want then you have to do it as you don't want. You can also do it in several steps using several servers (or VM) with OS compatible with subsequent db upgrades 11g->12c->...->19c, which means several downtimes. Regards Michel
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Ales Kavsek, Slovenia
Date:	Aug 12, 2020, 22:10, 44 days ago
Score:
Message:	Hi Alain, why do you want to mess with 11g installation on OEL8 in the first place if you really want an immediate upgrade from 11g to 12c on this new server? You were already told that you can restore/recover 11g RMAN backupset with higher release, such as 19.8. Simply put 11g RMAN backupset on OEL 8 filesystem and then restore RMAN backupset with db 19.8. Of course, you'll have to open database with upgrade option and execute manual upgrade (you can't use DBUA). Regards, Ales
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Alain Bourgeois, Belgium
Date:	Aug 13, 2020, 09:09, 43 days ago
Message:	"open database with upgrade option" Do you mean that after recover, I can type "startup upgrade"? I thought that an "open resetlogs" from 11g was needed before?
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Ales Kavsek, Slovenia
Date:	Aug 14, 2020, 08:43, 42 days ago
Message:	Hi Alain, it's explained in this thread: https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=95068 If you open the link that I provided at the end, you'll find a "demo" of restoring RMAN 9i backup with RMAN 10g. Regards, Aleš
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Alain Bourgeois, Belgium
Date:	Aug 14, 2020, 09:38, 42 days ago
Message:	The example in this thread is talking about a "cold" backup and has no recover. For this case, I have to recover . I think I will have to copy the online redo logs, recreate controlfile then use recover database from sqlplus.
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Ales Kavsek, Slovenia
Date:	Aug 14, 2020, 12:03, 42 days ago
Message:	Hi, ok, perhaps I was not clear enough in my post. RMAN of higher version can restore and recover backup set made with RMAN of lower version. So, you can have as an input cold or hot RMAN backup, the point is that restore and recovery is done by RMAN. When you're at the point that you need to open the database exit RMAN, launch SQL*Plus: sql> alter database open resetlogs upgrade; sql> <--- run all the scripts that you need for an upgrade ---> I suggest that you setup some dummy/test environment to run and test all the upgrade steps. I guess this 11g database is around ~25TB, the DB that you rescued!? One strategy that you can use is to restore DB, then apply with recovery as many daily diffs/(or redo logs) as you want, keeping DB up to date as much as possible, to minimize downtime needed for recovery on D-Day. The size of the database has little impact on time needed for upgrade. Be careful however about no-logging operations (direct-path loads etc.! Regards, Ales
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Alain Bourgeois, Belgium
Date:	Aug 14, 2020, 12:34, 42 days ago
Message:	Nope, it is not the same db nor the same hardware. In this case, source is fine, is still alive (r/w), 5.5Tb. Strategy is as you suggested: stop primary when there is nearly nothing to recover. upgrade db to 19.8 on new hardware, and change connectionstrings meanwhile. Then reset all passwords (case-sensitivity) and upgrade timezone. Then setup SE HA. downtime expected to 3 hours.
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: oracle 11.2.0.4 on linux 8
Author:	Ales Kavsek, Slovenia
Date:	Aug 14, 2020, 13:13, 42 days ago
Score:
Message:	Hi, yes, this is the path that I would consider first. Since you have a new server, you can practice this scenario a couple of times with real database on real HW. The downtime of 3h is achievable, but only if you prepare and practice all the steps, catching any surprises beforehand. For major upgrades of production systems I usually start preparing at least two months before D-day, don't hurry (Mike Dietrich site is always my first stop). Regards, Ales
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here