FAL [client]: Failed to request gap sequence GAP, falgap

Source: Internet
Author: User

FAL [client]: Failed to request gap sequence GAP, falgap
I. Problem Description

After the host where the master and slave databases are located is restarted, rac (master database) is automatically started upon startup, but the slave database (Single Instance) is not started upon startup and has been manually started to mount, the standby database has been alter database recover standby database disconnect from session ;.

The archived logs of the master database cannot be synchronized to the slave database:

Rac1:

 

Rac2:

 

Slave database:

 

 

-- It is strange that v $ archive_gap is still empty.

View alarm logs:

 

Ii. Solution

First, check whether the standby database listening is started (when the status is 'ready', it indicates that the standby database listening has been started)

If the listener is not started, start the listener: lsnrctl start.

If the listener has been started:

Manually copy the missing logs from the master database scp/rcp, And then alter database register logfile.

Step 3:

For example, the following logs should be copied:

+ DATA/prod/1_29_856078807.arc 29 1

+ DATA/prod/2_14_856078807.arc 14 2

+ DATA/prod/1_30_856078807.arc 30 1

+ DATA/prod/2_15_856078807.arc 15 2

+ DATA/prod/2_16_856078807.arc 16 2

1: Use RMAN to copy the required archive files from the ASM Device

Run {

Copy archivelog '+ DATA/PROD/1_29_856078807.arc' to '/home/oracle/1_29_856078807.arc ';

 

Copy archivelog '+ DATA/PROD/export 30_856078807.arc' to '/home/oracle/export 30_856078807.arc ';

Copy archivelog '+ DATA/prod/2_14_856078807.arc' to '/home/oracle/2_14_856078807.arc ';

Copy archivelog '+ DATA/prod/2_15_856078807.arc' to '/home/oracle/2_15_856078807.arc ';

Copy archivelog '+ DATA/prod/2_16_856078807.arc' to '/home/oracle/2_16_856078807.arc ';

}

 

 

 

Starting backup at 27-AUG-14

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting archive copy

Input archive log thread = 1 sequence = 29 recid = 82 stamp = 856665609

Output filename =/home/oracle/1_29_856078807.arc recid = 89 stamp = 856669631

Channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02

Finished backup at 27-AUG-14

......

2: view the archive path in the slave Database

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination/arch/sdyprod

Oldest online log sequence 0

Next log sequence to archive 0

Current log sequence 0

3: Copy unsynchronized archived logs to the slave database in the master database

[Oracle @ rac1 ~] $ Scp 2*192.168.8.225:/arch/sdyprod/

Oracle@192.168.8.225's password:

2_14_856078807.arc 100% 1024 1.0KB/s

2_15_856078807.arc 100% 121KB 120.5KB/s

2_16_856078807.arc 100% 20KB 20.0KB/s

[Oracle @ rac1 ~] $ Scp 1*192.168.8.225:/arch/sdyprod/

Oracle@192.168.8.225's password:

201729_856078807.arc 100% 5356KB 5.2 MB/s

201730_856078807.arc 100% 12 MB 11.7 MB/s

[Oracle @ rac1 ~] $

4: Cancel log application in the slave Database

SQL> alter database recover managed standby database cancel;

Database altered.

5. register the log file

SQL> alter database register logfile '/arch/sdyprod/1_29_856078807.arc ';

......

Database altered.

SQL> alter database register logfile '/arch/sdyprod/2_16_856078807.arc ';

Database altered.

6: Start log application

SQL> alter database recover managed standby database disconnect from session;

Database altered.

-- This article reference: http://blog.itpub.net/14507784/viewspace-759605/

If the problem persists, see the article: http://www.xifenfei.com/1176.html

 

 


What is the java error "gap = 4" and "gap = 0?

Post an error message?
Didn't I declare an error to the gap object...
Which line of error should be displayed? Or paste your code to estimate that you have not initialized the object.

What does gap sequence mean?

I used youdao to check it out. If you can use youdao.com/#to check it out.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.