[Oracle] [Oracle] Data Guard CPU/PSU补丁安装详细教程

sys@EPAY>select database_role from v$database;
DATABASE_ROLE
----------------
PRIMARY
sys@EPAY>show parameter log_archive_dest_3
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_3           string    SERVICE=sta ASYNC VALID_FOR=(O
                         NLINE_LOGFILES,PRIMARY_ROLE) D
                         B_UNIQUE_NAME=epaybk
log_archive_dest_30          string
log_archive_dest_31          string
sys@EPAY>alter system set log_archive_dest_state_3=defer scope=both;
System altered.

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

sys@EPAY>alter system register;
System altered.

sys@EPAY>alter system set log_archive_dest_state_3=enable scope=both;
System altered.

------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE, 
and that the SYS password is same in the password files.
    returning error ORA-16191
------------------------------------------------------------

sys@EPAY>alter database recover managed standby database disconnect from session;
Database altered.

sys@EPAY>select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
       159

sys@EPAY>select sequence#, applied from v$archived_log;

alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (epay)
Wed Jul 10 06:03:48 2013
MRP0 started with pid=29, OS id=15030 
MRP0: Background Managed Standby Recovery process started (epay)
 started logmerger process
Wed Jul 10 06:03:53 2013
Managed Standby Recovery not using Real Time Apply
Wed Jul 10 06:04:01 2013
Parallel Media Recovery started with 32 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Wed Jul 10 06:04:01 2013
Completed: alter database recover managed standby database disconnect from session
Media Recovery Log /data/oradata/epay/archivelog/1_157_814716635.dbf
Media Recovery Log /data/oradata/epay/archivelog/1_158_814716635.dbf
Media Recovery Log /data/oradata/epay/archivelog/1_159_814716635.dbf
Media Recovery Waiting for thread 1 sequence 160 (in transit)