Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what is the method of opening and closing the Oracle11g DG MRP process". In the daily operation, I believe that many people have doubts about the method of opening and closing the Oracle11g DG MRP process. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the question of "what is the method of opening and closing the Oracle11g DG MRP process?" Next, please follow the editor to study!

1. Close the MRP process (stop the application log):

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

2. Start the MRP process (open the application log):

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

3. View the delay time of application log:

Select value from v$dataguard_stats where name='apply lag'

4. Check the delay time of receiving logs:

Select value from v$dataguard_stats where name='transport lag'

5. Delete the archive log from two days ago:

Su-oracle [switch to database user]

Rman target /

Delete noprompt archivelog until time 'sysdate-2' all

6. View ASM DISKGROUP utilization:

Set lines 300 pages 9999

Col name for a15

Col USED_PERCENT for a15

Select GROUP_NUMBER,NAME,TOTAL_MB/1024 total_gb,FREE_MB/1024,USABLE_FILE_MB/1024,round ((TOTAL_MB-USABLE_FILE_MB) * 100/TOTAL_MB) | |'% 'USED_PERCENT

FROM V$ASM_DISKGROUP ORDER BY 1

-- add:

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.