非Data Guard的補丁安裝教程可參考《[Oracle] CPU/PSU補丁安裝詳細教程》
下面是一個具體例子
sys@EPAY>select database_role from v$database;
DATABASE_ROLE
PRIMARY
sys@EPAY>show parameter log_archive_dest_
NAME TYPE VALUE
log_archive_dest_
NLINE_LOGFILES
B_UNIQUE_NAME=epaybk
log_archive_dest_
log_archive_dest_
sys@EPAY>alter system set log_archive_dest_state_
System altered
(注意
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle
SQL> QUIT
sys@EPAY>alter system register;
System altered
sys@EPAY>alter system set log_archive_dest_state_
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
根據錯誤信息的提示
sys@EPAY>alter database recover managed standby database disconnect from session;
Database altered
在primary端查詢當前最大的歸檔日志序號
sys@EPAY>select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
在standby端查詢已傳過來的歸檔日志
sys@EPAY>select sequence#
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (epay)
Wed Jul
MRP
MRP
started logmerger process
Wed Jul
Managed Standby Recovery not using Real Time Apply
Wed Jul
Parallel Media Recovery started with
Waiting for all non
All non
Wed Jul
Completed: alter database recover managed standby database disconnect from session
Media Recovery Log /data/oradata/epay/archivelog/
Media Recovery Log /data/oradata/epay/archivelog/
Media Recovery Log /data/oradata/epay/archivelog/
Media Recovery Waiting for thread
From:http://tw.wingwit.com/Article/program/Oracle/201311/19113.html