DBA Hub

📋Steps in this guide1/4

How To Apply PSU Patch On Standby Database

How To Apply Psu Patch On Standby Database ?

oracle configurationintermediate
by OracleDba
14 views
1

Overview

How To Apply Psu Patch On Standby Database ? To apply psu patch on  physical standby database, 1st we need to appy patch on standby, and then on primary. Below are the steps. P.S. Download patch from Oracle Support.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
On Primary, 
SQL> select database_role from v$database;

DATABASE_ROLE
----------------
PRIMARY

On Standby , 
SQL> select database_role from v$database;

SDATABASE_ROLE
----------------
PHYSICAL STANDBY

On Primary , 
SQL>select LOG_ARCHIVED-LOG_APPLIED "LOG_GAP" from
(SELECT MAX(SEQUENCE#) LOG_ARCHIVED
FROM V$ARCHIVED_LOG WHERE DEST_ID=1 AND ARCHIVED='YES'),
(SELECT MAX(SEQUENCE#) LOG_APPLIED
FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND APPLIED='YES');

LOG_GAP
------

0

On PRIMARY
SQL> alter system set log_archive_dest_state_2=defer;

System altered.
2

Section 2

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
On STANDBY
SQL> alter database recover managed standby database cancel;

databas altered.

On STANDBY 
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


STANDBY$ lsnrctl stop

On Standby 
standby$ cd /u01/app/PATCH

standby$ unzip p16056266_11203_linux.zip

standby$cd 16056266
STANDBY$pwd
u01/app/PATCH/16056266

STANDBY$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3
Copyright (c) 2015, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /home/oracle/app/oracle/product/11.2.0/dbhome_1
Oracle Home Inventory : /home/oracle/app/oracle/product/11.2.0/dbhome_1/sainventory
OPatch version : 11.2.0.3
Product information : n/a
Log file location : /home/oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-07-29_08-55-45AM_1.log

Patch history file: /home/oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

node2$ cd /u01/app/PATCH/16056266

node2$ $ORACLE_HOME/OPatch/opatch apply

node2$ lsnrctl start

SQL> startup mount
3

Section 3

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
node1$ lsnrctl stop 

SQL> shutdown immediate;

primary$ cd /u01/app/PATCH
primary$ cd /u01/app/PATCH
primary$ unzip p16056266_11203_linux.zip
primary$ cd 16056266
primary$ pwd
/u01/app/PATCH/16056266
$ unzip p16056266_11203_linux.zip
primary$ cd 16056266
PRIMRAY$ pwd
/u01/app/PATCH/16056266

NODE1$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3
Copyright (c) 2015, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /home/oracle/app/oracle/product/11.2.0/dbhome_1
Oracle Home Inventory : /home/oracle/app/oracle/product/11.2.0/dbhome_1/sainventory
OPatch version : 11.2.0.3
Product information : n/a
Log file location : /home/oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-07-29_08-55-45AM_1.log

Patch history file: /home/oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

NODE1$ cd /u01/app/PATCH/16056266

NODE1$ $ORACLE_HOME/OPatch/opatch apply

NODE1$ lsnrctl start 

SQL> startup
ORACLE instance started.

Total System Global Area 684785664 bytes
Fixed Size 2229640 bytes
Variable Size 222300792 bytes
Database Buffers 457179136 bytes
Redo Buffers 3076096 bytes
Database mounted.
Database opened.

SQL> alter system set log_archive_dest_state_2=enable;

System altered.
4

Section 4

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
NODE2> select PROCESS,CLIENT_PROCESS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby where process = 'MRP0' or client_process='LGWR';
PROCESS CLIENT_P THREAD# SEQUENCE# BLOCK#
--------- -------- ---------- ---------- ----------
RFS LGWR 1 37628 1358


STANDBY> alter database recover managed standby database disconnect;

Database altered.

SQL>@$ORACLE_HOME/rdbms/admin/catbundle.sql psu apply

SQL> SELECT * FROM DBA_REGISTRY_HISTORY;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!