No question at this time
The DBA-Village forum
as RSS feed
Site StatisticsEver registered users | 48572 | Total active users | 1389 | Act. users last 24h | 3 | Act. users last hour | 0 | Registered user hits last week | 108 | Registered user hits last month | 299 |
|
Go up
oracle 11.2.0.4 on linux 8
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 |
Subject: |
oracle 11.2.0.4 on linux 8 |
Author: |
Alain Bourgeois, Belgium |
Date: |
Aug 11, 2020, 15:48, 165 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, 165 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, 165 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, 165 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, 163 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, 163 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, 162 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, 162 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, 162 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, 162 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, 162 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
|