Enabling / Disabling Flashback Database in 11gR2

Flashback database was introduced in Oracle 10g and offer’s a simple way for performing a point in time recovery. To enable this, your database must be running in archivelog mode and flash recovery must be enabled.

In 10g We would have had to issue the following commands:

But with 11gR2, We can now turn flashback on / off, when the database is OPEN

We can check the current status of flashback.

Lets set the flashback retention target

Now with the database open, we will set the flashback on.

Now with the database open, we will set the flashback off.

Lets enable the flashback.

Check the flashback retention

After a while if you run the following you can see how far we can flashback the database.

Standalone Oracle Database Patching with ASM

Some Useful links:

Information Center: Patching and Maintaining Oracle Database Server/Client Installations (Doc ID 1351428.2)

Introduction to Oracle Recommended Patches (Doc ID 756388.1)

Oracle Recommended Patches — Oracle Database (Doc ID 756671.1)

Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1)

Before you download any patches, you need to find out what is your current Software version. You should check all the Oracle Homes and patch them as needed. Notice that Grid Infrastructure (with ASM) must be Patched first as it must be on a same or higher level than any Oracle Database Homes.

Log in to the servers as Oracle Software owner (usually oracle), set the proper Oracle environment and run the opatch utility.

. oraenv -> +ASM
$ORACLE_HOME/OPatch/opatch version (opatch version)
$ORACLE_HOME/OPatch/opatch lspatches (show Patches only)
$ORACLE_HOME/OPatch/opatch lsinventory (show Software details)

. oraenv -> DB SID
$ORACLE_HOME/OPatch/opatch version (opatch version)
$ORACLE_HOME/OPatch/opatch lspatches (show Patches only)
$ORACLE_HOME/OPatch/opatch lsinventory (show Software details)

Repeat same steps on all the Oracle Database Homes.

IN Action:

Patch GRID_HOME and ORACLE HOME
1.
[oracle@skynet ~]$. ./asm_profile.sh
[oracle@skynet ~]$ cd $ORACLE_HOME
[oracle@skynet grid]$ cd OPatch
[oracle@skynet OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.
[oracle@skynet OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home.
[oracle@skynet OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/opatch2015-10-14_09-19-58AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2015-10-14_09-19-58AM.txt

——————————————————————————–
Installed Top-level Products (1):

Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
——————————————————————————–

OPatch succeeded.

[oracle@skynet ~]$ . ./db_profile.sh
[oracle@skynet ~]$ cd $ORACLE_HOME
[oracle@skynet dbhome_1]$ cd OPatch
[oracle@skynet OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.
[oracle@skynet OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home.
[oracle@skynet OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-10-14_09-28-19AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-10-14_09-28-19AM.txt

——————————————————————————–
Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
——————————————————————————–

OPatch succeeded.

Lets download the Patch’s

Now, log in to MOS and, click on “Patches & Updates”, then choose “Recommended Patch Advisor”.
Under “Product”, type “Real Application Clusters”, choose proper Release “11.2.0.4” and Platform “Linux x86-64”, now click on “Check recommendations when used with another product.” and choose “Oracle Clusterware”, “11.2.0.4” and “Linux x86-64”, then “Search”
Result should be this: “Patch 20485808: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.6 (APR2015)” (This includes all the Patches, including Patches for the Database Homes)

Click “Download” to get the Patch
Click “Read Me” to read the Patch details and instructions.

I would recommend to click on “View Related Knowledge to this Patch”. Sometimes it has very useful information about the Patch itself, like “Known issues”, Bug details etc.

Before applying any Oracle patches, make sure you have the latest version of OPatch! The Patch ReadMe has a note about it, and you can download it from here: https://updates.oracle.com/download/6880880.html

Choose Release: “11.2.0.0.0”, Platform: “Linux x86-64”, should get this to download:
“OPatch patch of version 11.2.0.3.11 for Oracle software releases 11.2.0.x (JUN 2015)”

When your download completes, copy these patches on all the Servers you plan to patch and you’re ready for Patching.

1. Log in to the Server as Oracle Software Owner (“oracle”), run the following to check the databases)

select Comp_name, status, Version From Dba_Registry order by Comp_name; (Check that all Components are VALID!)

2. Shutdown all the databases, then the asm,
3. Leave has/listener running.
4.
. Set the environment for the Grid Infrastructure:
. oraenv -> +ASM

5. Backup the current Opatch directory:

[root@skynet grid]# mv OPatch OPatch14102015

3. Check OPatch version and then Update OPatch:

[oracle@skynet OPatch]$ su
Password:
[root@skynet OPatch]# echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/grid
[oracle@skynet OPatch]$ cd /skynet1/source/kiran_oracle_patch_oct2015/OPatch
[oracle@skynet OPatch]$ ls
p6880880_112000_Linux-x86-64.zip
[oracle@skynet OPatch]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
Archive: p6880880_112000_Linux-x86-64.zip
creating: /u01/app/oracle/product/11.2.0/grid/OPatch/
inflating: /u01/app/oracle/product/11.2.0/grid/OPatch/opatchdiag
inflating: /u01/app/oracle/product/11.2.0/grid/OPatch/opatch.pl
creating: /u01/app/oracle/product/11.2.0/grid/OPatch/jlib/
..
..
.

[root@skynet grid]# chown -R oracle:oinstall OPatch

[oracle@skynet OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.12

OPatch succeeded.

. Set the environment for the Oracle Infrastructure:
. oraenv -> DB

1. Backup the current Opatch directory:

[root@skynet grid]# mv OPatch OPatch14102015

3. Check OPatch version and then Update OPatch:

[oracle@skynet OPatch]$ cd /skynet1/source/kiran_oracle_patch_oct2015/OPatch
[oracle@skynet OPatch]$ ls
p6880880_112000_Linux-x86-64.zip
[oracle@skynet OPatch]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
Archive: p6880880_112000_Linux-x86-64.zip
creating: /u01/app/oracle/product/11.2.0/grid/OPatch/
inflating: /u01/app/oracle/product/11.2.0/grid/OPatch/opatchdiag
inflating: /u01/app/oracle/product/11.2.0/grid/OPatch/opatch.pl
creating: /u01/app/oracle/product/11.2.0/grid/OPatch/jlib/
..
..
.

[oracle@skynet OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@skynet OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.12

OPatch succeeded.
4. Create the OCM “dummy” response file:
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -output /tmp/ocm.rsp (You don’t need to specify any details)

[oracle@skynet Grid]$ pwd
/skynet1/source/kiran_oracle_patch_oct2015/Grid
[oracle@skynet Grid]$ unzip p20996923_112040_Linux-x86-64.zip

5. Patch Oracle Grid Infrastructure and Oracle RAC Database Homes together, as “root” user:
. oraenv -> +ASM
$ORACLE_HOME/OPatch/opatch auto /stage/<UNZIPPED_PATCH_LOCATION> -ocmrf /tmp/ocm.rsp

[oracle@skynet OPatch]$ cd /u01/app/oracle/product/11.2.0/grid/OPatch
[oracle@skynet OPatch]$ su
Password:
[root@skynet OPatch]#

[root@skynet OPatch]# ./opatch auto /skynet1/source/kiran_oracle_patch_oct2015/Grid/20996923 -ocmrf /tmp/ocm.rsp

Executing /u01/app/oracle/product/11.2.0/grid/perl/bin/perl ./crs/patch11203.pl -patchdir /skynet1/source/kiran_oracle_patch_oct2015/Grid -patchn 20996923 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2015-10-14_14-20-44.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2015-10-14_14-20-44.report.log

2015-10-14 14:20:44: Starting Oracle Restart Patch Setup
Using configuration parameter file: /u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/dbhome_1 …
Stopped RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

patch /skynet1/source/kiran_oracle_patch_oct2015/Grid/20996923/20760982 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1
patch /skynet1/source/kiran_oracle_patch_oct2015/Grid/20996923/20831122/custom/server/20831122 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1

Stopping CRS…
Stopped CRS successfully

patch /skynet1/source/kiran_oracle_patch_oct2015/Grid/20996923/20760982 apply successful for home /u01/app/oracle/product/11.2.0/grid
patch /skynet1/source/kiran_oracle_patch_oct2015/Grid/20996923/20831122 apply successful for home /u01/app/oracle/product/11.2.0/grid
patch /skynet1/source/kiran_oracle_patch_oct2015/Grid/20996923/20299019 apply successful for home /u01/app/oracle/product/11.2.0/grid

Starting CRS…
CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0/dbhome_1 …
Started RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

opatch auto succeeded.
You have new mail in /var/spool/mail/oracle

*Note that this is the simplest way to Patch everything. Most of the time I have done this myself, but on more complex systems I choose to apply patches in several different steps, where first I patch Grid Infrastructure and if successful then Oracle Database Homes.

6. When Patching completes, check the screen and log files and confirm if it was successful. Check the software version:

. oraenv -> +ASM
$ORACLE_HOME/OPatch/opatch version (opatch version)
$ORACLE_HOME/OPatch/opatch lspatches (show Patches only)
$ORACLE_HOME/OPatch/opatch lsinventory (show Software details)

[oracle@skynet OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.12

OPatch succeeded.
[oracle@skynet OPatch]$ ./opatch lspatches
20299019;ACFS Patch set update : 11.2.0.4.6 (20299019)
20831122;OCW Patch Set Update : 11.2.0.4.7 (20831122)
20760982;Database Patch Set Update : 11.2.0.4.7 (20760982)

OPatch succeeded.
[oracle@skynet OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/opatch2015-10-14_15-09-05PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2015-10-14_15-09-05PM.txt

——————————————————————————–
Local Machine Information::
Hostname: skynet.op.skynetglobal.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :

Patch 20299019 : applied on Wed Oct 14 15:02:37 BST 2015
Unique Patch ID: 18573450
Patch description: “ACFS Patch set update : 11.2.0.4.6 (20299019)”
Created on 27 Mar 2015, 15:26:30 hrs
Bugs fixed:
17510275, 17172303, 16318126, 19690653, 17203009, 17376318, 17503605
20140148, 17611362, 17721778, 17164243, 19053182, 17696547, 17699423
17488768, 18915417, 18155334, 18321597, 19919907, 18168684, 17363999
17636008, 18143006, 17428148, 17070158, 17475946

Patch 20831122 : applied on Wed Oct 14 15:01:59 BST 2015
Unique Patch ID: 18923533
Patch description: “OCW Patch Set Update : 11.2.0.4.7 (20831122)”
Created on 1 Jul 2015, 06:26:45 hrs PST8PDT
Bugs fixed:
19270660, 18328800, 18691572, 20365005, 17750548, 17387214, 17617807
14497275, 17733927, 18180541, 18962892, 17292250, 17378618, 16759171
20110156, 17065496, 13991403, 17273020, 17155238, 18261183, 18053580
20218012, 17039197, 17947785, 16317771, 10052729, 20340620, 18199185
18399991, 20186278, 18024089, 20746251, 20246071, 14270845, 18414137
17001914, 17927970, 14378120, 16346413, 15986647, 18068871, 21222147
18143836, 16206997, 19168690, 20235511, 18343490, 16613232, 19276791
17722664, 12928658, 18520351, 16249829, 18226143, 18265482, 18229842
17172091, 17818075, 18231837, 14373486, 17483479, 18120545, 18729166
13843841, 21225209, 17405302, 18709496, 18330979, 18744838, 20531190
14525998, 18187697, 14385860, 18348155, 19479503, 12928592, 17516024
18370031, 17764053, 17551223, 14671408, 18272135, 14207615, 17500165
18875012, 18464784, 19558324, 18848125, 19241857, 14851828, 17955615
20315294, 14693336, 16284825, 17352230, 20014326, 17238586, 17089344
17405605, 17531342, 17159489, 17640316, 16543190, 17983675, 17481314
16281493, 18346135, 15986311, 17208793, 18700935, 18999857, 14076173
18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 16206882
20141091, 17305100, 15832129, 19885321, 16901346, 17985714, 18536826
17780903, 18752378, 18946768, 16876500, 16875342, 19955755, 16429265
18336452, 17273003, 19319357, 17059927, 17046460, 18053631, 16867761
20235486, 15869775, 19642566, 17447588, 15920201

Patch 20760982 : applied on Wed Oct 14 14:56:51 BST 2015
Unique Patch ID: 18908105
Patch description: “Database Patch Set Update : 11.2.0.4.7 (20760982)”
Created on 4 Jun 2015, 00:23:20 hrs PST8PDT
Sub-patch 20299013; “Database Patch Set Update : 11.2.0.4.6 (20299013)”
Sub-patch 19769489; “Database Patch Set Update : 11.2.0.4.5 (19769489)”
Sub-patch 19121551; “Database Patch Set Update : 11.2.0.4.4 (19121551)”
Sub-patch 18522509; “Database Patch Set Update : 11.2.0.4.3 (18522509)”
Sub-patch 18031668; “Database Patch Set Update : 11.2.0.4.2 (18031668)”
Sub-patch 17478514; “Database Patch Set Update : 11.2.0.4.1 (17478514)”
Bugs fixed:
17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699
17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817
16992075, 17446237, 14015842, 19972569, 17449815, 17375354, 19463897
17982555, 17235750, 13866822, 18317531, 17478514, 18235390, 14338435
20803583, 13944971, 20142975, 17811789, 16929165, 18704244, 20506706
17546973, 20334344, 14054676, 17088068, 18264060, 17346091, 17343514
19680952, 18471685, 19211724, 13951456, 16315398, 18744139, 16850630
19049453, 18673304, 17883081, 19915271, 18641419, 18262334, 17006183
18277454, 16833527, 10136473, 18051556, 17865671, 17852463, 18554871
17853498, 18334586, 17588480, 17551709, 19827973, 17842825, 17344412
18828868, 17025461, 11883252, 13609098, 17239687, 17602269, 19197175
18316692, 17313525, 12611721, 19544839, 18964939, 17600719, 18191164
19393542, 17571306, 20777150, 18482502, 19466309, 17040527, 17165204
18098207, 16785708, 17174582, 16180763, 17465741, 16777840, 12982566
19463893, 12816846, 16875449, 17237521, 19358317, 17811438, 17811447
17945983, 18762750, 17184721, 16912439, 18061914, 17282229, 18331850
18202441, 17082359, 18723434, 19554106, 14034426, 18339044, 19458377
17752995, 17891943, 17258090, 17767676, 16668584, 18384391, 17040764
17381384, 15913355, 18356166, 14084247, 20506715, 13853126, 18203837
14245531, 16043574, 17848897, 17877323, 17468141, 17786518, 17912217
17037130, 18155762, 16956380, 17478145, 17394950, 18189036, 18641461
18619917, 17027426, 16268425, 19584068, 18436307, 17265217, 17634921
13498382, 20004087, 17443671, 18000422, 20004021, 17571039, 21067387
16344544, 18009564, 14354737, 18135678, 18614015, 18362222, 17835048
16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775
16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359
18203835, 17297939, 16731148, 17811456, 17215560, 13829543, 14133975
17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634
18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
17393915, 17957017, 17274537, 18096714, 17308789, 18436647, 14285317
19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671
18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160
17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606
13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015
17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058
18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568
19788842, 18508861, 14657740, 17332800, 13837378, 19972564, 17186905
18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024
17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551
19854503, 19309466, 18681862, 20558005, 17390160, 18554763, 18456514
13955826, 16306373, 18139690, 17501491, 17299889, 17752121, 17889583
18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136
17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222
16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668
16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305
16392068, 19271443, 18092127, 17614227, 18440047, 14106803, 16903536
18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717
17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 17267114
19972570, 18244962, 18765602, 18203838, 16198143, 17246576, 14829250
17835627, 18247991, 14458214, 21051862, 16692232, 17786278, 17227277
16042673, 16314254, 16228604, 16837842, 17393683, 17787259, 20331945
20074391, 15861775, 16399083, 18018515, 21051858, 18260550, 17036973
16613964, 17080436, 16579084, 18384537, 18280813, 20296213, 16901385
15979965, 18441944, 16450169, 9756271, 17892268, 11733603, 17587063
16285691, 16538760, 18180390, 18193833, 21051833, 17238511, 17824637
16571443, 18306996, 14852021, 18674047, 17853456, 12364061

——————————————————————————–

OPatch succeeded.
[oracle@skynet OPatch]$

. oraenv -> DB SID
$ORACLE_HOME/OPatch/opatch version (opatch version)
$ORACLE_HOME/OPatch/opatch lspatches (show Patches only)
$ORACLE_HOME/OPatch/opatch lsinventory (show Software details)
[oracle@skynet OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.12

OPatch succeeded.
[oracle@skynet OPatch]$ ./opatch lspatches
20831122;OCW Patch Set Update : 11.2.0.4.7 (20831122)
20760982;Database Patch Set Update : 11.2.0.4.7 (20760982)

OPatch succeeded.
[oracle@skynet OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-10-14_15-10-17PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-10-14_15-10-17PM.txt

——————————————————————————–
Local Machine Information::
Hostname: skynet.op.skynetglobal.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :

Patch 20831122 : applied on Wed Oct 14 14:27:35 BST 2015
Unique Patch ID: 18923533
Patch description: “OCW Patch Set Update : 11.2.0.4.7 (20831122)”
Created on 1 Jul 2015, 06:26:39 hrs PST8PDT
Bugs fixed:
19270660, 18328800, 18691572, 20365005, 17750548, 17387214, 17617807
14497275, 17733927, 18180541, 18962892, 17292250, 17378618, 16759171
20110156, 17065496, 13991403, 17273020, 17155238, 18261183, 18053580
20218012, 17039197, 17947785, 16317771, 10052729, 20340620, 18199185
18399991, 20186278, 18024089, 20746251, 20246071, 14270845, 18414137
17001914, 17927970, 14378120, 16346413, 15986647, 18068871, 21222147
18143836, 16206997, 19168690, 20235511, 18343490, 16613232, 19276791
17722664, 12928658, 18520351, 16249829, 18226143, 18265482, 18229842
17172091, 17818075, 18231837, 14373486, 17483479, 18120545, 18729166
13843841, 21225209, 17405302, 18709496, 18330979, 18744838, 20531190
14525998, 18187697, 14385860, 18348155, 19479503, 12928592, 17516024
18370031, 17764053, 17551223, 14671408, 18272135, 14207615, 17500165
18875012, 18464784, 19558324, 18848125, 19241857, 14851828, 17955615
20315294, 14693336, 16284825, 17352230, 20014326, 17238586, 17089344
17405605, 17531342, 17159489, 17640316, 16543190, 17983675, 17481314
16281493, 18346135, 15986311, 17208793, 18700935, 18999857, 14076173
18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 16206882
20141091, 17305100, 15832129, 19885321, 16901346, 17985714, 18536826
17780903, 18752378, 18946768, 16876500, 16875342, 19955755, 16429265
18336452, 17273003, 19319357, 17059927, 17046460, 18053631, 16867761
20235486, 15869775, 19642566, 17447588, 15920201

Patch 20760982 : applied on Wed Oct 14 14:26:47 BST 2015
Unique Patch ID: 18908105
Patch description: “Database Patch Set Update : 11.2.0.4.7 (20760982)”
Created on 4 Jun 2015, 00:23:20 hrs PST8PDT
Sub-patch 20299013; “Database Patch Set Update : 11.2.0.4.6 (20299013)”
Sub-patch 19769489; “Database Patch Set Update : 11.2.0.4.5 (19769489)”
Sub-patch 19121551; “Database Patch Set Update : 11.2.0.4.4 (19121551)”
Sub-patch 18522509; “Database Patch Set Update : 11.2.0.4.3 (18522509)”
Sub-patch 18031668; “Database Patch Set Update : 11.2.0.4.2 (18031668)”
Sub-patch 17478514; “Database Patch Set Update : 11.2.0.4.1 (17478514)”
Bugs fixed:
17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699
17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817
16992075, 17446237, 14015842, 19972569, 17449815, 17375354, 19463897
17982555, 17235750, 13866822, 18317531, 17478514, 18235390, 14338435
20803583, 13944971, 20142975, 17811789, 16929165, 18704244, 20506706
17546973, 20334344, 14054676, 17088068, 18264060, 17346091, 17343514
19680952, 18471685, 19211724, 13951456, 16315398, 18744139, 16850630
19049453, 18673304, 17883081, 19915271, 18641419, 18262334, 17006183
18277454, 16833527, 10136473, 18051556, 17865671, 17852463, 18554871
17853498, 18334586, 17588480, 17551709, 19827973, 17842825, 17344412
18828868, 17025461, 11883252, 13609098, 17239687, 17602269, 19197175
18316692, 17313525, 12611721, 19544839, 18964939, 17600719, 18191164
19393542, 17571306, 20777150, 18482502, 19466309, 17040527, 17165204
18098207, 16785708, 17174582, 16180763, 17465741, 16777840, 12982566
19463893, 12816846, 16875449, 17237521, 19358317, 17811438, 17811447
17945983, 18762750, 17184721, 16912439, 18061914, 17282229, 18331850
18202441, 17082359, 18723434, 19554106, 14034426, 18339044, 19458377
17752995, 17891943, 17258090, 17767676, 16668584, 18384391, 17040764
17381384, 15913355, 18356166, 14084247, 20506715, 13853126, 18203837
14245531, 16043574, 17848897, 17877323, 17468141, 17786518, 17912217
17037130, 18155762, 16956380, 17478145, 17394950, 18189036, 18641461
18619917, 17027426, 16268425, 19584068, 18436307, 17265217, 17634921
13498382, 20004087, 17443671, 18000422, 20004021, 17571039, 21067387
16344544, 18009564, 14354737, 18135678, 18614015, 18362222, 17835048
16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775
16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359
18203835, 17297939, 16731148, 17811456, 17215560, 13829543, 14133975
17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634
18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
17393915, 17957017, 17274537, 18096714, 17308789, 18436647, 14285317
19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671
18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160
17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606
13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015
17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058
18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568
19788842, 18508861, 14657740, 17332800, 13837378, 19972564, 17186905
18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024
17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551
19854503, 19309466, 18681862, 20558005, 17390160, 18554763, 18456514
13955826, 16306373, 18139690, 17501491, 17299889, 17752121, 17889583
18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136
17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222
16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668
16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305
16392068, 19271443, 18092127, 17614227, 18440047, 14106803, 16903536
18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717
17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 17267114
19972570, 18244962, 18765602, 18203838, 16198143, 17246576, 14829250
17835627, 18247991, 14458214, 21051862, 16692232, 17786278, 17227277
16042673, 16314254, 16228604, 16837842, 17393683, 17787259, 20331945
20074391, 15861775, 16399083, 18018515, 21051858, 18260550, 17036973
16613964, 17080436, 16579084, 18384537, 18280813, 20296213, 16901385
15979965, 18441944, 16450169, 9756271, 17892268, 11733603, 17587063
16285691, 16538760, 18180390, 18193833, 21051833, 17238511, 17824637
16571443, 18306996, 14852021, 18674047, 17853456, 12364061

 

——————————————————————————–

OPatch succeeded.

etc.

7. Patch post-installation instructions. These are the steps you need to run on every Database part of the Oracle Database Homes you just patched.
. oraenv -> DB SID
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL> @catbundle.sql psu apply
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_REPODEV_APPLY_2015Oct14_15_15_18.log

/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_SANADEV_APPLY_2015Oct14_15_19_13.log

/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_S82DEV1_APPLY_2015Oct14_15_57_27.log

/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_S82DEV2_APPLY_2015Oct14_16_02_20.log
SQL> @utlrp.sql

Check Patch status in the database:
SQL> select * from dba_registry_history;
SQL> set lines 140 pages 100
SQL> col Comp_name Format a40
SQL> col Status Format a12
SQL> select Comp_name, status, Version From Dba_Registry order by Comp_name; (Check that all Components are VALID!)

!!! Notice that:
If you are using the Oracle Recovery Manager, the catalog needs to be upgraded. Enter the following command to upgrade it:
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;

And you’re done! 🙂

 

EXPDP and IMPDP with Query and REMAP_TABLE

Here we have a table called requests under the SAMPLE schema, what we are going to do is export it and then re import changing its name and the tablespace with a filter.

1. Create export par file and export –

2. Create tablespace for reimport

3. Create import par file and import

Summary

We have exported and imported a table into a different tablespace, but at the same time renamed the tables using the REMAP_TABLE and REMAP_TABLESPACE parameters.