/*
|| Oracle 11g DataGuard Listing 5
||
|| Demonstrates how to:
|| - Activate Real Time Query on a physical standby database
|| - Convert a physical standby database to snapshot standby mode
|| - Utilize a snapshot standby database for testing application changes
|| - Convert a snapshot standby database back to physical standby mode
|| in an Oracle Database 11g primary and standby Data Guard environment.
||
|| Author: Jim Czuprynski
||
|| Usage Notes:
|| These examples are provided to demonstrate various Oracle 11gR1 Data Guard
|| features, and they should be carefully proofread before being executed
|| against any existing Oracle database to avoid potential damage!
*/

/* 
|| Listing 5.1:
|| Activating Real Time Query
*/

>>> Alert log entries:
Media Recovery Waiting for thread 1 sequence 266 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 266 Reading mem 0
  Mem# 0: /u01/app/oracle/oradata/stdby/srl02.log
Sun Jul 19 21:20:37 2009
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Sun Jul 19 21:20:37 2009
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /u01/app/oracle/diag/rdbms/orcl_stdby1/orcl_stdby1/trace/orcl_stdby1_mrp0_6595.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Shutting down recovery slaves due to error 16037
Recovery interrupted!
Recovered data files to a consistent state at change 4455257
Waiting for MRP0 pid 6595 to terminate
Errors in file /u01/app/oracle/diag/rdbms/orcl_stdby1/orcl_stdby1/trace/orcl_stdby1_mrp0_6595.trc:
ORA-16037: user requested cancel of managed recovery operation
MRP0: Background Media Recovery process shutdown (orcl_stdby1)
Managed Standby Recovery Canceled (orcl_stdby1)
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Sun Jul 19 21:20:41 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[8]: Assigned to RFS process 6701
RFS[8]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
RFS[8]: Successfully opened standby log 5: '/u01/app/oracle/oradata/stdby/srl02.log'
Sun Jul 19 21:20:59 2009
alter database open
Data Guard Broker initializing...
Data Guard Broker initialization complete
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
Sun Jul 19 21:20:59 2009
SMON: enabling cache recovery
Dictionary check beginning
Sun Jul 19 21:21:00 2009
Errors in file /u01/app/oracle/diag/rdbms/orcl_stdby1/orcl_stdby1/trace/orcl_stdby1_dbw0_6554.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/orcl/temp01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/orcl_stdby1/orcl_stdby1/trace/orcl_stdby1_dbw0_6554.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/orcl/temp01.dbf'
File 201 not verified due to error ORA-01157
Dictionary check complete
Re-creating tempfile /u01/app/oracle/oradata/orcl/temp01.dbf
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
If files cannot be cataloged, then manually delete them
using OS command.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
   then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Physical standby database opened for read only access.
Sun Jul 19 21:21:31 2009
Completed: alter database open
Sun Jul 19 21:21:46 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[9]: Assigned to RFS process 6716
RFS[9]: Identified database type as 'physical standby'
Sun Jul 19 21:21:49 2009
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT  USING CURRENT LOGFILE
Attempt to start background Managed Standby Recovery process (orcl_stdby1)
Sun Jul 19 21:21:49 2009
MRP0 started with pid=26, OS id=6718
MRP0: Background Managed Standby Recovery process started (orcl_stdby1)
Fast Parallel Media Recovery enabled
Managed Standby Recovery starting Real Time Apply
 parallel recovery started with 2 processes
Waiting for all non-current ORLs to be archived...
Media Recovery Log /u01/app/oracle/flash_recovery_area/STDBY/log_266_1_682541003.arc
Media Recovery Waiting for thread 1 sequence 267 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 267 Reading mem 0
  Mem# 0: /u01/app/oracle/oradata/stdby/srl02.log
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE
Media Recovery Waiting for thread 1 sequence 268
Sun Jul 19 21:21:58 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[10]: Assigned to RFS process 6728
RFS[10]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
RFS[10]: Successfully opened standby log 5: '/u01/app/oracle/oradata/stdby/srl02.log'
Sun Jul 19 21:22:02 2009
Recovery of Online Redo Log: Thread 1 Group 5 Seq 268 Reading mem 0
  Mem# 0: /u01/app/oracle/oradata/stdby/srl02.log
/* 
|| Listing 5.2:
|| Converting a physical standby database to snapshot standby mode
*/

>>> Alert log entries:
Fri Aug 14 14:23:38 2009
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Fri Aug 14 14:23:38 2009
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /u01/app/oracle/diag/rdbms/orcl_stdby1/orcl_stdby1/trace/orcl_stdby1_mrp0_5547.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Shutting down recovery slaves due to error 16037
Recovery interrupted!
Recovered data files to a consistent state at change 5045966
Errors in file /u01/app/oracle/diag/rdbms/orcl_stdby1/orcl_stdby1/trace/orcl_stdby1_mrp0_5547.trc:
ORA-16037: user requested cancel of managed recovery operation
MRP0: Background Media Recovery process shutdown (orcl_stdby1)
Managed Standby Recovery Canceled (orcl_stdby1)
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
alter database convert to snapshot standby
Created guaranteed restore point SNAPSHOT_STANDBY_REQUIRED_08/14/2009 14:23:38
tkcrrxms: Killing 3 processes (all RFS)
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Active process 5509 user 'oracle' program 'oracle@11gStdby (TNS V1-V3)'
CLOSE: all sessions shutdown successfully.
Fri Aug 14 14:24:05 2009
SMON: disabling cache recovery
RESETLOGS after incomplete recovery UNTIL CHANGE 5045966
Resetting resetlogs activation ID 1221597403 (0x48d018db)
Online log /u01/app/oracle/oradata/stdby/redo01.log: Thread 1 Group 1 was previously cleared
Online log /u01/app/oracle/oradata/stdby/redo02.log: Thread 1 Group 2 was previously cleared
Online log /u01/app/oracle/oradata/stdby/redo03.log: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 5045964
Fri Aug 14 14:24:05 2009
Setting recovery target incarnation to 6
Converting standby mount to primary mount.
ACTIVATE STANDBY: Complete - Database mounted as primary (orcl_stdby1)
ALTER DATABASE CONVERT TO SNAPSHOT STANDBY: Complete (orcl_stdby1)
Completed: alter database convert to snapshot standby
ALTER DATABASE OPEN
Data Guard Broker initializing...
Data Guard Broker initialization complete
Fri Aug 14 14:24:06 2009
Assigning activation ID 1222645452 (0x48e016cc)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/stdby/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Aug 14 14:24:07 2009
ARC2: Becoming the 'no SRL' ARCH
SMON: enabling cache recovery
Fri Aug 14 14:24:07 2009
idle dispatcher 'D000' terminated, pid = (18, 1)
Successfully onlined Undo Tablespace 2.
Dictionary check beginning
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
Fri Aug 14 14:24:09 2009
Starting background process FBDA
Starting background process SMCO
Fri Aug 14 14:24:09 2009
FBDA started with pid=19, OS id=5601 
Fri Aug 14 14:24:09 2009
SMCO started with pid=21, OS id=5603 
Starting background process QMNC
Fri Aug 14 14:24:13 2009
QMNC started with pid=30, OS id=5605 
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Fri Aug 14 14:24:31 2009
Completed: ALTER DATABASE OPEN
Fri Aug 14 14:24:38 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[7]: Assigned to RFS process 5629
RFS[7]: Identified database type as 'snapshot standby'
RFS[7]: Successfully opened standby log 4: '/u01/app/oracle/oradata/stdby/srl01.log'
Fri Aug 14 14:24:42 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[8]: Assigned to RFS process 5635
RFS[8]: Identified database type as 'snapshot standby'
/* 
|| Listing 5.3:
|| Converting a snapshot standby database back to physical standby mode
*/

>>> Alert log entries:
Fri Aug 14 14:44:35 2009
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Stopping background process QMNC
Fri Aug 14 14:44:37 2009
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
Fri Aug 14 14:44:40 2009
ORA-1089 : opidrv aborting process J000 ospid (10945_3083204288)
License high water mark = 8
All dispatchers and shared servers shutdown
alter database CLOSE NORMAL
Fri Aug 14 14:44:41 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Aug 14 14:44:41 2009
Shutting down archive processes
Archiving is disabled
Fri Aug 14 14:44:41 2009
ARCH shutting down
ARC3: Archival stopped
Fri Aug 14 14:44:41 2009
ARCH shutting down
ARC2: Archival stopped
Fri Aug 14 14:44:41 2009
ARCH shutting down
ARC1: Archival stopped
Fri Aug 14 14:44:41 2009
ARCH shutting down
ARC0: Archival stopped
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Completed: alter database CLOSE NORMAL
alter database DISMOUNT
Completed: alter database DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Shutting down Data Guard Broker processes
Fri Aug 14 14:44:46 2009
Completed: Data Guard Broker shutdown
Fri Aug 14 14:44:48 2009
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Aug 14 14:44:48 2009
Stopping background process VKTM: 
Fri Aug 14 14:44:50 2009
Instance shutdown complete
Fri Aug 14 14:44:51 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.1.0/db_1/dbs/spfileorcl_stdby1.ora
System parameters with non-default values:
  processes                = 150
  sga_target               = 400M
  control_files            = "/u01/app/oracle/oradata/orcl/control01.ctl"
  log_file_name_convert    = "/u01/app/oracle/oradata/orcl/"
  log_file_name_convert    = "/u01/app/oracle/oradata/stdby/"
  db_block_size            = 8192
  compatible               = "11.1.0.0.0"
  log_archive_config       = "dg_config=(orcl_primary,orcl_stdby1)"
  log_archive_dest_1       = "location="/u01/app/oracle/flash_recovery_area/STDBY/""
  log_archive_dest_1       = "valid_for=(ALL_LOGFILES,ALL_ROLES)"
  log_archive_dest_2       = ""
  log_archive_dest_state_1 = "ENABLE"
  log_archive_dest_state_2 = "ENABLE"
  log_archive_max_processes= 4
  log_archive_min_succeed_dest= 1
  log_archive_trace        = 0
  log_archive_format       = "log_%s_%t_%r.arc"
  fal_client               = "orcl_stdby1"
  fal_server               = "orcl_primary"
  archive_lag_target       = 0
  db_recovery_file_dest    = "/u01/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 8G
  standby_file_management  = "AUTO"
  undo_tablespace          = "UNDOTBS1"
  sec_case_sensitive_logon = FALSE
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  audit_file_dest          = "/u01/app/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  db_unique_name           = "orcl_stdby1"
  open_cursors             = 300
  pga_aggregate_target     = 150M
  dg_broker_start          = TRUE
  dg_broker_config_file1   = "/u01/app/oracle/product/11.1.0/db_1/dbs/dr1orcl_stdby1.dat"
  dg_broker_config_file2   = "/u01/app/oracle/product/11.1.0/db_1/dbs/dr2orcl_stdby1.dat"
  diagnostic_dest          = "/u01/app/oracle"
Fri Aug 14 14:44:54 2009
PMON started with pid=2, OS id=12700 
Fri Aug 14 14:44:54 2009
VKTM started with pid=3, OS id=12702 at elevated priority
VKTM running at (20)ms precision

<< ... removed for sake of brevity ... >>

DMON started with pid=18, OS id=12747 
Fri Aug 14 14:44:55 2009
alter database  mount
Setting recovery target incarnation to 6
Successful mount of redo thread 1, with mount id 1222676713
Allocated 3981204 bytes in shared pool for flashback generation buffer
Starting background process RVWR
Fri Aug 14 14:45:02 2009
RVWR started with pid=21, OS id=13610 
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database  mount
Starting Data Guard Broker (DMON)
Fri Aug 14 14:45:03 2009
NSV0 started with pid=22, OS id=13650 
Fri Aug 14 14:45:07 2009
INSV started with pid=23, OS id=14160 
Fri Aug 14 14:45:12 2009
RSM0 started with pid=24, OS id=14656 
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oracle/flash_recovery_area/STDBY/
ALTER SYSTEM SET log_archive_dest_1='location="/u01/app/oracle/flash_recovery_area/STDBY/"','valid_for=(ALL_LOGFILES,ALL_ROLES)' SCOPE=BOTH SID='orcl_stdby1';
ALTER SYSTEM SET log_archive_dest_state_1='ENABLE' SCOPE=BOTH SID='orcl_stdby1';
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='orcl_stdby1';
ALTER SYSTEM SET log_archive_format='log_%s_%t_%r.arc' SCOPE=SPFILE SID='orcl_stdby1';
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_file_name_convert='/u01/app/oracle/oradata/orcl/','/u01/app/oracle/oradata/stdby/' SCOPE=SPFILE;
ALTER SYSTEM SET fal_server='orcl_primary' SCOPE=BOTH;
ALTER SYSTEM SET fal_client='orcl_stdby1' SCOPE=BOTH;
Fri Aug 14 14:45:22 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 15910
RFS[1]: Identified database type as 'snapshot standby'
RFS LogMiner: Client disabled from further notification
RFS[1]: Successfully opened standby log 5: '/u01/app/oracle/oradata/stdby/srl02.log'
Fri Aug 14 14:45:22 2009
alter database convert to physical standby
ALTER DATABASE CONVERT TO PHYSICAL STANDBY (orcl_stdby1)
Flashback Restore Start
Flashback Restore Complete
Guaranteed restore point  dropped
tkcrrxms: Killing 1 processes (all RFS)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 13 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;
Setting recovery target incarnation to 5
Completed: alter database convert to physical standby
Fri Aug 14 14:45:27 2009
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
alter database CLOSE NORMAL
ORA-1109 signalled during: alter database CLOSE NORMAL...
alter database DISMOUNT
Completed: alter database DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Shutting down Data Guard Broker processes
Fri Aug 14 14:45:31 2009
Completed: Data Guard Broker shutdown
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Aug 14 14:45:33 2009
Stopping background process VKTM: 
Fri Aug 14 14:45:35 2009
Instance shutdown complete
Fri Aug 14 14:45:35 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.1.0/db_1/dbs/spfileorcl_stdby1.ora
System parameters with non-default values:
  processes                = 150
  sga_target               = 400M
  control_files            = "/u01/app/oracle/oradata/orcl/control01.ctl"
  log_file_name_convert    = "/u01/app/oracle/oradata/orcl/"
  log_file_name_convert    = "/u01/app/oracle/oradata/stdby/"
  db_block_size            = 8192
  compatible               = "11.1.0.0.0"
  log_archive_config       = "dg_config=(orcl_primary,orcl_stdby1)"
  log_archive_dest_1       = "location="/u01/app/oracle/flash_recovery_area/STDBY/""
  log_archive_dest_1       = "valid_for=(ALL_LOGFILES,ALL_ROLES)"
  log_archive_dest_2       = ""
  log_archive_dest_state_1 = "ENABLE"
  log_archive_dest_state_2 = "ENABLE"
  log_archive_max_processes= 4
  log_archive_min_succeed_dest= 1
  log_archive_trace        = 0
  log_archive_format       = "log_%s_%t_%r.arc"
  fal_client               = "orcl_stdby1"
  fal_server               = "orcl_primary"
  archive_lag_target       = 0
  db_recovery_file_dest    = "/u01/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 8G
  standby_file_management  = "AUTO"
  undo_tablespace          = "UNDOTBS1"
  sec_case_sensitive_logon = FALSE
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  audit_file_dest          = "/u01/app/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  db_unique_name           = "orcl_stdby1"
  open_cursors             = 300
  pga_aggregate_target     = 150M
  dg_broker_start          = TRUE
  dg_broker_config_file1   = "/u01/app/oracle/product/11.1.0/db_1/dbs/dr1orcl_stdby1.dat"
  dg_broker_config_file2   = "/u01/app/oracle/product/11.1.0/db_1/dbs/dr2orcl_stdby1.dat"
  diagnostic_dest          = "/u01/app/oracle"
Fri Aug 14 14:45:36 2009
PMON started with pid=2, OS id=16881 
Fri Aug 14 14:45:36 2009
VKTM started with pid=3, OS id=16883 at elevated priority
VKTM running at (20)ms precision
Fri Aug 14 14:45:36 2009

<< ... removed for sake of brevity ... >>

Fri Aug 14 14:45:37 2009
alter database  mount
Fri Aug 14 14:45:37 2009
DMON started with pid=18, OS id=16922 
Setting recovery target incarnation to 5
ARCH: STARTING ARCH PROCESSES
Fri Aug 14 14:45:44 2009
ARC0 started with pid=20, OS id=17837 
Fri Aug 14 14:45:44 2009
ARC1 started with pid=21, OS id=17839 
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC1: Thread not mounted
ARC0: Becoming the heartbeat ARCH
Fri Aug 14 14:45:44 2009
ARC3 started with pid=23, OS id=17843 
ARC3: Thread not mounted
Fri Aug 14 14:45:44 2009
ARC2 started with pid=22, OS id=17841 
ARC2: Thread not mounted
ARC0: Thread not mounted
Successful mount of redo thread 1, with mount id 1222710548
Allocated 3981204 bytes in shared pool for flashback generation buffer
Starting background process RVWR
Fri Aug 14 14:45:44 2009
RVWR started with pid=24, OS id=17847 
Physical Standby Database mounted.
Lost write protection disabled
Completed: alter database  mount
Starting Data Guard Broker (DMON)
Fri Aug 14 14:45:45 2009
NSV0 started with pid=25, OS id=17899 
Fri Aug 14 14:45:48 2009
INSV started with pid=27, OS id=18288 
Fri Aug 14 14:45:52 2009
RSM0 started with pid=28, OS id=18803 
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oracle/flash_recovery_area/STDBY/
ALTER SYSTEM SET log_archive_dest_1='location="/u01/app/oracle/flash_recovery_area/STDBY/"','valid_for=(ALL_LOGFILES,ALL_ROLES)' SCOPE=BOTH SID='orcl_stdby1';
ALTER SYSTEM SET log_archive_dest_state_1='ENABLE' SCOPE=BOTH SID='orcl_stdby1';
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='orcl_stdby1';
ALTER SYSTEM SET log_archive_format='log_%s_%t_%r.arc' SCOPE=SPFILE SID='orcl_stdby1';
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_file_name_convert='/u01/app/oracle/oradata/orcl/','/u01/app/oracle/oradata/stdby/' SCOPE=SPFILE;
ALTER SYSTEM SET fal_server='orcl_primary' SCOPE=BOTH;
ALTER SYSTEM SET fal_client='orcl_stdby1' SCOPE=BOTH;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  USING CURRENT LOGFILE
Attempt to start background Managed Standby Recovery process (orcl_stdby1)
Fri Aug 14 14:45:58 2009
MRP0 started with pid=29, OS id=19477 
MRP0: Background Managed Standby Recovery process started (orcl_stdby1)
Fast Parallel Media Recovery enabled
Managed Standby Recovery starting Real Time Apply
 parallel recovery started with 2 processes
Waiting for all non-current ORLs to be archived...
Clearing online redo logfile 1 /u01/app/oracle/oradata/stdby/redo01.log
Clearing online log 1 of thread 1 sequence number 1
Fri Aug 14 14:46:04 2009
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  USING CURRENT LOGFILE
Fri Aug 14 14:46:05 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 20251
RFS[1]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
RFS LogMiner: Client disabled from further notification
Primary database is in MAXIMUM PERFORMANCE mode
kcrrvslf: inactive RFS archival for log 5 thread 1 sequence 16
RFS[1]: Successfully opened standby log 4: '/u01/app/oracle/oradata/stdby/srl01.log'
Clearing online redo logfile 1 complete
Media Recovery Log /u01/app/oracle/flash_recovery_area/STDBY/log_14_1_693763762.arc
Media Recovery Waiting for thread 1 sequence 15
Fetching gap sequence in thread 1, gap sequence 15-15
Fri Aug 14 14:46:09 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[2]: Assigned to RFS process 20373
RFS[2]: Identified database type as 'physical standby'
RFS[2]: Archived Log: '/u01/app/oracle/flash_recovery_area/STDBY/log_15_1_693763762.arc'
Fri Aug 14 14:46:39 2009
Media Recovery Log /u01/app/oracle/flash_recovery_area/STDBY/log_15_1_693763762.arc
Recovery of Online Redo Log: Thread 1 Group 5 Seq 16 Reading mem 0
  Mem# 0: /u01/app/oracle/oradata/stdby/srl02.log
Fri Aug 14 14:46:45 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[3]: Assigned to RFS process 25409
RFS[3]: Identified database type as 'physical standby'
RFS[3]: Archived Log: '/u01/app/oracle/flash_recovery_area/STDBY/log_16_1_693763762.arc'
Media Recovery Log /u01/app/oracle/flash_recovery_area/STDBY/log_16_1_693763762.arc
Media Recovery Waiting for thread 1 sequence 17 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 17 Reading mem 0
  Mem# 0: /u01/app/oracle/oradata/stdby/srl01.log