/* || 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