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

In this issue, the editor will bring you how to deal with DG discovery gap. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

1. Query gap

Select * from V$ARCHIVE_GAP

two。 Backup is very important.

-- list backup information

List backup of archivelog all

BS Key Size Device Type Elapsed Time Completion Time

--

42 2.09m DISK 00:00:02 2017-08-16 00:07:07

BP Key: 42 Status: AVAILABLE Compressed: NO Tag: TAG20170816T000626

Piece Name: / home/oracle/rmanbackup/arch_1fsc0kt9_1_1_20170816

List of Archived Logs in backup set 42

Thrd Seq Low SCN Low Time Next SCN Next Time

-

1111 1395047 2017-08-16 00:02:32 1395227 2017-08-16 00:06:17

1112 1395227 2017-08-16 00:06:17 1395240 2017-08-16 00:06:22

2 83 1379687 2017-08-15 23:27:17 1395043 2017-08-16 00:02:29

2 84 1395043 2017-08-16 00:02:29 1395231 2017-08-16 00:06:17

2 85 1395231 2017-08-16 00:06:17 1395244 2017-08-16 00:06:24

3. Restore

Restore archivelog from logseq 84 until logseq 85 thread 2

Restore archivelog from logseq 84 until logseq 85

Note: only the archive logs of this node are restored on the current node. If you need to restore the logs of other nodes, you need to add thread 2 to specify.

If you have enabled log application in the DG environment, you need to register the archive log, and the log is applied automatically.

Solution:

There are two ways to solve gap. Although the methods are slightly different, the principles are the same.

First, there is less gap, so you can directly scp the missing files to standby, which can be manually registered under standby.

ALTER DATABASE REGISTER LOGFILE'/ u01According to ArchivelogAccording to 99mm 626106231.arc'

2. There are more gap. Do scn-based backup in primary and create a new standbycontrolfile. Under the corresponding directory of the backup backupset and standbycontrolfile copy, you can perform restore and recover operations because in this case, too many archives are lost by standby, so the second method is recommended.

For the second point, there are more gap. Another way is to register the scp to the archive location of the slave database under rman, and the log application will be applied automatically when the log application is enabled.

Catalog start with'D:\ database backup file\'

The above is the DG that Xiaobian shares with you how to deal with gap. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.