DGMGRL手工切换简单一条命令
当然前提是你把环境全搭建好了参考
--先查看命令的帮助
DGMGRL> help switchover;
Switches roles between a primary and standby database
Syntax:
SWITCHOVER TO <standby database name>;
--执行角色切换
DGMGRL> switchover to 'orcldg';
Performing switchover NOW, please wait...
Operation requires a connection to instance "orcl" on database "orcldg"
Connecting to instance "orcl"...
Connected.
New primary database "orcldg" is opening...
Operation requires startup of instance "orcl" on database "orclms"
Starting instance "orcl"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "orcldg"
--重新退出并登陆备库SQLPLUS 环境
col name format a10;
col db_unique_name format a10;
col open_mode format a20;
col protection_mode format a20;
col database_role format a20;
col switchover_status format a20;
SELECT NAME,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS,DB_UNIQUE_NAME FROM V$DATABASE;
NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_
---------- -------------------- -------------------- -------------------- -------------------- ----------
ORCL READ WRITE MAXIMUM AVAILABILITY PRIMARY SESSIONS ACTIVE orcldg
Elapsed: 00:00:00.01
SQL>
--重新退出并登陆主库SQLPLUS 环境
col name format a10;
col db_unique_name format a10;
col open_mode format a20;
col protection_mode format a20;
col database_role format a20;
col switchover_status format a20;
SQL> SELECT NAME,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS,DB_UNIQUE_NAME FROM V$DATABASE;
NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_
---------- -------------------- -------------------- -------------------- -------------------- ----------
ORCL READ ONLY WITH APPLY MAXIMUM AVAILABILITY PHYSICAL STANDBY NOT ALLOWED orclms
Elapsed: 00:00:00.01
--在主库的DGMGRL下再次查看配置情况
DGMGRL> show configuration;
Configuration - dg_broker_master
Protection Mode: MaxAvailability
Databases:
orcldg - Primary database
orclms - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
--查看各个库情况
DGMGRL> show database verbose orcldg;
Database - orcldg
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s): orcl
Properties:
DGConnectIdentifier = 'orcldg'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '5'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u02/ora_data/orcl, u02/ora_data/orcl'
LogFileNameConvert = '/u02/ora_data/orcl, u02/ora_redo/orcl'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'orcl'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbslave)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcldg_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/ora_archive/orcl'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> show database verbose orclms;
Database - orclms
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Rate: 32.00 KByte/s
Real Time Query: ON
Instance(s):
orcl
Properties:
DGConnectIdentifier = 'orclms'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'orcl'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbmater)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orclms_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01/ora_archive/orcl'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
下面是主备库的TRAC信息，有利于我们DBA深入理解DGMGRL后台的工作
备库TRAC信息：
Recovery interrupted!
Sun Mar 25 23:13:35 2018
MRP0: Background Media Recovery process shutdown (orcl)
Managed Standby Recovery Canceled (orcl)
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WAIT WITH SESSION SHUTDOWN
ALTER DATABASE SWITCHOVER TO PRIMARY (orcl)
Maximum wait for role transition is 15 minutes.
Killing 3 processes with pids 10276,8378,8386 (all RFS) in order to disallow current and future RFS connections. Requested by OS process 10041
All dispatchers and shared servers shutdown
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
Sun Mar 25 23:13:40 2018
SMON: disabling cache recovery
Backup controlfile written to trace file u01/ora_diag/diag/rdbms/orcldg/orcl/trace/orcl_rsm0_10041.trc
SwitchOver after complete recovery through change 1203705
Online log u02/ora_redo/orcl/redo01.log: Thread 1 Group 1 was previously cleared
Online log u02/ora_redo/orcl/redo02.log: Thread 1 Group 2 was previously cleared
Online log u02/ora_redo/orcl/redo03.log: Thread 1 Group 3 was previously cleared
Online log u02/ora_redo/orcl/redo04.log: Thread 1 Group 4 was previously cleared
Standby became primary SCN: 1203703
AUDIT_TRAIL initialization parameter is changed back to its original value as specified in the parameter file.
Switchover: Complete - Database mounted as primary
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WAIT WITH SESSION SHUTDOWN
Sun Mar 25 23:13:45 2018
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/ora_archive/orcl
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
ALTER DATABASE OPEN
Data Guard Broker initializing...
Sun Mar 25 23:13:45 2018
Assigning activation ID 1499408693 (0x595f2935)
LGWR: Primary database is in MAXIMUM AVAILABILITY mode
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
Thread 1 advanced to log sequence 32 (thread open)
Sun Mar 25 23:13:45 2018
ARC4: Becoming the 'no SRL' ARCH
Thread 1 opened at log sequence 32
Current log# 2 seq# 32 mem# 0: /u02/ora_redo/orcl/redo02.log
Sun Mar 25 23:13:45 2018
ARC0: Becoming the 'no SRL' ARCH
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Mar 25 23:13:45 2018
ARC1: Becoming the 'no SRL' ARCH
SMON: enabling cache recoverySun Mar 25 23:13:45 2018
***********************************************************************
Fatal NI connect error 12528, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.128)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orclms)(CID=(PROGRAM=oracle)(HOST=dbslave)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 25-MAR-2018 23:13:49
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Error 12528 received logging on to the standby
Error 12528 for archive log file 3 to 'orclms'
LGWR: Failed to archive log 3 thread 1 sequence 33 (12528)
Thread 1 advanced to log sequence 33 (LGWR switch)
Current log# 3 seq# 33 mem# 0: /u02/ora_redo/orcl/redo03.log
Starting background process CJQ0
Sun Mar 25 23:13:49 2018
CJQ0 started with pid=30, OS id=10346
Expanded controlfile section 11 from 28 to 123 records
Requested to grow by 95 records; added 4 blocks of records
Archived Log entry 29 added for thread 1 sequence 32 ID 0x595f2935 dest 1:
Setting Resource Manager plan SCHEDULER[0x32DF]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sun Mar 25 23:13:52 2018
Starting background process VKRM
Sun Mar 25 23:13:52 2018
VKRM started with pid=27, OS id=10350
Sun Mar 25 23:13:56 2018
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';
Sun Mar 25 23:13:56 2018
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';
Sun Mar 25 23:13:58 2018
LGWR: Standby redo logfile selected to archive thread 1 sequence 34
LGWR: Standby redo logfile selected for thread 1 sequence 34 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 34 (LGWR switch)
Current log# 4 seq# 34 mem# 0: /u02/ora_redo/orcl/redo04.log
Sun Mar 25 23:14:02 2018
Archived Log entry 30 added for thread 1 sequence 33 ID 0x595f2935 dest 1:
Sun Mar 25 23:14:15 2018
Shutting down archive processes
ARCH shutting down
ARC5: Archival stopped
Sun Mar 25 23:14:16 2018
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
LGWR: Standby redo logfile selected to archive thread 1 sequence 35
LGWR: Standby redo logfile selected for thread 1 sequence 35 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 35 (LGWR switch)
Current log# 1 seq# 35 mem# 0: /u02/ora_redo/orcl/redo01.log
Sun Mar 25 23:14:17 2018
Archived Log entry 35 added for thread 1 sequence 34 ID 0x595f2935 dest 1:
Sun Mar 25 23:14:17 2018
ALTER SYSTEM ARCHIVE LOG
Thread 1 cannot allocate new log, sequence 36
Checkpoint not complete
Current log# 1 seq# 35 mem# 0: /u02/ora_redo/orcl/redo01.log
LGWR: Standby redo logfile selected to archive thread 1 sequence 36
LGWR: Standby redo logfile selected for thread 1 sequence 36 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 36 (LGWR switch)
Current log# 2 seq# 36 mem# 0: /u02/ora_redo/orcl/redo02.log
Archived Log entry 37 added for thread 1 sequence 35 ID 0x595f2935 dest 1:
主库ALTER信息
Sun Mar 25 23:13:33 2018
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 12526] (orcl)
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Waiting for all FAL entries to be archived...
All FAL entries have been archived.
Waiting for dest_id 2 to become synchronized...
Active, synchronized Physical Standby switchover target has been identified
Switchover End-Of-Redo Log thread 1 sequence 30 has been fixed
Switchover: Primary highest seen SCN set to 0x0.0x125df9
ARCH: Noswitch archival of thread 1, sequence 30
ARCH: End-Of-Redo Branch archival of thread 1 sequence 30
ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
ARCH: Standby redo logfile selected for thread 1 sequence 30 for destination LOG_ARCHIVE_DEST_2
Archived Log entry 56 added for thread 1 sequence 30 ID 0x595eedcc dest 1:
ARCH: Archiving is disabled due to current logfile archival
Primary will check for some target standby to have received alls redo
Final check for a synchronized target standby. Check will be made once.
LOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target
Active, synchronized target has been identified
Target has also received all redo
Backup controlfile written to trace file /u01/ora_diag/diag/rdbms/orclms/orcl/trace/orcl_rsm0_12526.trc
Clearing standby activation ID 1499393484 (0x595eedcc)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 12 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 1073741824;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 1073741824;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 1073741824;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 1073741824;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 1073741824;
Archivelog for thread 1 sequence 30 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Switchover: Complete - Database shutdown required
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
Sun Mar 25 23:13:37 2018
Process (ospid 11804) is suspended due to switchover to physical standby operation.
Sun Mar 25 23:13:43 2018
Shutting down instance after CTL_SWITCH
DMON (ospid: 11820): terminating the instance
Instance terminated by DMON, pid = 11820
Sun Mar 25 23:13:45 2018
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = UNLIMITED
Total Shared Global Region in Large Pages = 38 GB (100%)
Large Pages used by this instance: 19329 (38 GB)
Large Pages unused system wide = 11 (22 MB)
Large Pages configured system wide = 19340 (38 GB)
Large Page size = 2048 KB
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 8
Number of processor cores in the system is 4
Number of processor sockets in the system is 1
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
NUMA status: non-NUMA system
cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
Grp 0:
Picked latch-free SCN scheme 3
Autotune of undo retention is turned off.
IMODE=BR
ILAT =415
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/ora_soft/oracle/product/11.2.0/db_1
System name: Linux
Node name: dbmater
Release: 2.6.32-696.23.1.el6.x86_64
Version: #1 SMP Tue Mar 13 22:44:18 UTC 2018
Machine: x86_64
Using parameter settings in server-side spfile /u01/ora_soft/oracle/product/11.2.0/db_1/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 2500
sessions = 3776
lock_sga = TRUE
nls_date_format = "YYYY-MM-DD HH24:MI:SS"
nls_time_format = "HH24:MI:SSXFF"
nls_timestamp_format = "YYYY-MM-DD HH24:MI:SSXFF"
nls_time_tz_format = "HH24:MI:SSXFF TZR"
nls_timestamp_tz_format = "YYYY-MM-DD HH24:MI:SSXFF TZR"
filesystemio_options = "DIRECTIO"
disk_asynch_io = TRUE
sga_target = 38656M
control_files = "/u02/ora_data/orcl/control01.ctl"
control_files = "/u02/ora_flash/orcl/control02.ctl"
db_block_checksum = "FULL"
db_block_size = 8192
compatible = "11.2.0.4.0"
log_archive_dest_1 = "LOCATION=/u01/ora_archive/orcl"
log_archive_dest_2 = "service=orcldg lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=orcldg"
log_archive_dest_state_2 = "ENABLE"
log_archive_min_succeed_dest= 1
fal_client = "ORCLMS"
fal_server = "ORCLDG"
log_archive_trace = 0
log_archive_config = "dg_config=(orclms,orcldg)"
log_archive_format = "%t_%s_%r.dbf"
log_archive_max_processes= 4
archive_lag_target = 0
_use_adaptive_log_file_sync= "FALSE"
db_recovery_file_dest = "/u02/ora_flash"
db_recovery_file_dest_size= 100G
standby_file_management = "AUTO"
db_lost_write_protect = "TYPICAL"
_log_deletion_policy = "ALL"
undo_tablespace = "UNDOTBS1"
_undo_autotune = FALSE
db_block_checking = "FULL"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
service_names = "orclms,orclms_DGMGRL"
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
session_cached_cursors = 300
audit_file_dest = "/u01/ora_diag"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orclms"
open_cursors = 300
_serial_direct_read = "FALSE"
pga_aggregate_target = 12883M
deferred_segment_creation= FALSE
dg_broker_start = TRUE
diagnostic_dest = "/u01/ora_diag"
Sun Mar 25 23:13:45 2018
PMON started with pid=2, OS id=13974
Sun Mar 25 23:13:45 2018
PSP0 started with pid=3, OS id=13978
Sun Mar 25 23:13:46 2018
VKTM started with pid=4, OS id=13984 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Mar 25 23:13:46 2018
GEN0 started with pid=5, OS id=13990
Sun Mar 25 23:13:46 2018
DIAG started with pid=6, OS id=13994
Sun Mar 25 23:13:46 2018
DBRM started with pid=7, OS id=13998
Sun Mar 25 23:13:46 2018
DIA0 started with pid=8, OS id=14002
Sun Mar 25 23:13:46 2018
MMAN started with pid=9, OS id=14006
Sun Mar 25 23:13:46 2018
DBW0 started with pid=10, OS id=14010
Sun Mar 25 23:13:46 2018
LGWR started with pid=11, OS id=14014
Sun Mar 25 23:13:46 2018
CKPT started with pid=12, OS id=14018
Sun Mar 25 23:13:46 2018
SMON started with pid=13, OS id=14022
Sun Mar 25 23:13:46 2018
RECO started with pid=14, OS id=14026
Sun Mar 25 23:13:46 2018
MMON started with pid=15, OS id=14030
Sun Mar 25 23:13:46 2018
MMNL started with pid=16, OS id=14034
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sun Mar 25 23:13:46 2018
DMON started with pid=19, OS id=14046
ORACLE_BASE from environment = /u01/ora_soft/oracle
Sun Mar 25 23:13:46 2018
alter database mount
Sun Mar 25 23:13:51 2018
NSS2 started with pid=21, OS id=14062
ARCH: STARTING ARCH PROCESSES
Sun Mar 25 23:13:54 2018
ARC0 started with pid=22, OS id=14068
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 1499515179
Sun Mar 25 23:13:55 2018
ARC1 started with pid=23, OS id=14072
Sun Mar 25 23:13:55 2018
ARC2 started with pid=24, OS id=14076
Allocated 33554432 bytes in shared pool for flashback generation buffer
Sun Mar 25 23:13:55 2018
ARC3 started with pid=25, OS id=14080
ARC1: Archival started
ARC2: Archival started
Starting background process RVWR
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Sun Mar 25 23:13:55 2018
RVWR started with pid=26, OS id=14084
Physical Standby Database mounted.
Lost write protection mode set to "typical"
ARC1: Becoming the active heartbeat ARCH
Completed: alter database mount
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
Beginning Standby Crash Recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Media Recovery Log /u01/ora_archive/orcl/1_30_971582287.dbf
Identified End-Of-Redo (switchover) for thread 1 sequence 30 at SCN 0x0.125df9
Resetting standby activation ID 0 (0x0)
Incomplete Recovery applied until change 1203705 time 03/25/2018 23:13:34
Completed Standby Crash Recovery.
SMON: enabling cache recovery
Dictionary check beginning
Dictionary check complete
Database Characterset is AL32UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: alter database open
Sun Mar 25 23:13:56 2018
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/ora_archive/orcl
db_recovery_file_dest_size of 102400 MB is 2.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sun Mar 25 23:13:58 2018
Primary database is in MAXIMUM AVAILABILITY mode
Changing standby controlfile to RESYNCHRONIZATION level
Standby controlfile consistent with primary
RFS[1]: Assigned to RFS process 14110
RFS[1]: Selected log 5 for thread 1 sequence 34 dbid 1499363020 branch 971582287
Sun Mar 25 23:13:59 2018
Starting Data Guard Broker (DMON)
Sun Mar 25 23:13:59 2018
INSV started with pid=28, OS id=14114
Sun Mar 25 23:14:02 2018
NSV1 started with pid=30, OS id=14124
Sun Mar 25 23:14:04 2018
RFS[2]: Assigned to RFS process 14128
RFS[2]: Opened log for thread 1 sequence 31 dbid 1499363020 branch 971582287
Archived Log entry 58 added for thread 1 sequence 31 rlc 971582287 ID 0x595f2935 dest 2:
Sun Mar 25 23:14:08 2018
RSM0 started with pid=33, OS id=14138
Sun Mar 25 23:14:08 2018
RFS[3]: Assigned to RFS process 14118
RFS[3]: Opened log for thread 1 sequence 32 dbid 1499363020 branch 971582287
Archived Log entry 59 added for thread 1 sequence 32 rlc 971582287 ID 0x595f2935 dest 2:
RFS[2]: Opened log for thread 1 sequence 33 dbid 1499363020 branch 971582287
Archived Log entry 60 added for thread 1 sequence 33 rlc 971582287 ID 0x595f2935 dest 2:
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='orcl';
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='orcl';
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 fal_server='orcldg' SCOPE=BOTH;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE
Attempt to start background Managed Standby Recovery process (orcl)
Sun Mar 25 23:14:11 2018
MRP0 started with pid=34, OS id=14142
MRP0: Background Managed Standby Recovery process started (orcl)
started logmerger process
Sun Mar 25 23:14:16 2018
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 8 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Clearing online redo logfile 1 /u02/ora_data/orcl/redo01.log
Clearing online log 1 of thread 1 sequence number 29
Sun Mar 25 23:14:16 2018
Changing standby controlfile to MAXIMUM AVAILABILITY level
RFS[1]: Selected log 6 for thread 1 sequence 35 dbid 1499363020 branch 971582287
Sun Mar 25 23:14:17 2018
Archived Log entry 61 added for thread 1 sequence 34 ID 0x595f2935 dest 1:
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE
Standby controlfile consistent with primary
RFS[1]: Selected log 5 for thread 1 sequence 36 dbid 1499363020 branch 971582287
Sun Mar 25 23:14:19 2018
Archived Log entry 62 added for thread 1 sequence 35 ID 0x595f2935 dest 1:
Sun Mar 25 23:14:29 2018
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 /u02/ora_data/orcl/redo02.log
Clearing online log 2 of thread 1 sequence number 30
Sun Mar 25 23:14:42 2018
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 /u02/ora_data/orcl/redo03.log
Clearing online log 3 of thread 1 sequence number 34
Sun Mar 25 23:14:54 2018
Clearing online redo logfile 3 complete
Clearing online redo logfile 4 /u02/ora_data/orcl/redo04.log
Clearing online log 4 of thread 1 sequence number 35
Sun Mar 25 23:15:07 2018
Clearing online redo logfile 4 complete
Sun Mar 25 23:15:07 2018
Media Recovery Log /u01/ora_archive/orcl/1_31_971582287.dbf
Media Recovery Log /u01/ora_archive/orcl/1_32_971582287.dbf
Media Recovery Log /u01/ora_archive/orcl/1_33_971582287.dbf
Media Recovery Log /u01/ora_archive/orcl/1_34_971582287.dbf
Media Recovery Log /u01/ora_archive/orcl/1_35_971582287.dbf
Media Recovery Waiting for thread 1 sequence 36 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 36 Reading mem 0
Mem# 0: /u02/ora_redo/orcl/standby_redo05.log
