Shulou(Shulou.com)06/01 Report--

1. Start / stop the MRP process

You need to create a standby redolog when log_archive_dest is LGWR, and you do not need to set standby redolog-- for arch. You must set standby redolog for real-time data synchronization, alter database recover managed standby database using current controlfile disconnect;-- data asynchronous synchronization, and data synchronization when the main library switches over archiving. Alter database recover managed standby database disconnect from session;-- closes MRP process alter database recover managed standby database cancel.

two。 Check the status of the master and standby libraries

Select OPEN_MODE,PROTECTION_MODE,ACTIVATION#,DATABASE_ROLE,SWITCHOVER#,SWITCHOVER_STATUS FROM database database; confirm that the status of the main database is to standby or sessions active, the protection mode should be maximum performance, and the role is PRIMARY. When querying the standby database, it is usually not allowed or sessions active, and the role is PHYSICAL STANDBY.

3. Check data synchronization

-View application log delay time: select value from v$dataguard_stats where name='apply lag';- view receiving log delay time: select value from v$dataguard_stats where name='transport lag';- view main library archive Primary: SQL > select thread#, max (sequence#) "Last Primary Seq Generated" from v$archived_log val, v$database vdbwhereval.resetlogs_change# = vdb.resetlogs_change#group by thread# order by 1 -View Archive received PhyStdby:SQL > select thread#, max (sequence#) "Last Standby Seq Received" from v$archived_log val, v$database vdbwhereval.resetlogs_change# = vdb.resetlogs_change#group by thread# order by 1 * *-View Archive PhyStdby:SQL > select thread#, max (sequence#) "Last Standby Seq Applied" from v$archived_log val, v$database vdbwhereval.resetlogs_change# = vdb.resetlogs_change#and val.applied in ('YES','IN-MEMORY') group by thread# order by 1 -View the details of archiving application select first_time,sequence#,applied from vault archivedlogism-check the master / slave library GAPselect * from v$archive_gap

4. Query ASM Diskgroup usage

SET LINES 300 PAGES 9999COL name FOR a15COL USED_PERCENT FOR a15SELECT GROUP_NUMBER,NAME,TOTAL_MB / 1024 total_gb,FREE_MB / 1024 USED_PERCENTFROM V$ASM_DISKGROUPORDER BY MB / 1024 TOTAL_MB ((TOTAL_MB-USABLE_FILE_MB) * 100 / TOTAL_MB) |'% 'USED_PERCENTFROM V$ASM_DISKGROUPORDER BY 1

5. Check the process

Main library (confirm that the ARCH process is normal) SQL > SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY PROCESS CLIENT_PROCESS SEQUENCE# STATUS- ARCH ARCH 731 CLOSINGDGRD Nash A 0 ALLOCATEDDGRD N Rue A 0 ALLOCATEDARCH ARCH 732 CLOSINGARCH ARCH 733 CLOSINGARCH ARCH 734 CLOSINGLNS LNS 735 WRITINGDGRD N Zero A 0 ALLOCATEDDGRD Nash A 0 ALLOCATED backup (to confirm the existence of MRP, ARCH, RFS process) SQL > SELECT PROCESS CLIENT_PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY PROCESS CLIENT_PROCESS SEQUENCE# STATUS- ARCH ARCH 735 CLOSINGDGRD N IDLERFS LGWR A 0 ALLOCATEDDGRD N A 0 ALLOCATEDARCH ARCH 731 CLOSINGARCH ARCH 693 CLOSINGARCH ARCH 692 CLOSINGRFS LGWR 736 IDLERFS UNKNOWN 0 IDLERFS UNKNOWN 0 IDLERFS Archival 0 IDLERFS LGWR 694 IDLEPROCESS CLIENT_PROCESS SEQUENCE # STATUS--MRP0 Nash A 736 APPLYING_LOGRFS UNKNOWN 0 IDLERFS Archival 0 IDLE

6. Query, adding standby log

Click (here) to collapse or open

Select GROUP#, DBID db_id, THREAD#, SEQUENCE#, BYTES, USED, ARCHIVED, STATUS, FIRST_CHANGE#, NEXT_CHANGE#,LAST_CHANGE# from v$standby_log

Alter database add standby logfile thread 1 group 7 size xxx,group 8 size xxx,group 9 size xxx,group 10 size xxx

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.