No question at this time
DBA Top 10
1 B. Vroman 15700
2 M. Cadot 10200
3 T. Boles 8350
4 J. Schnackenberg 8300
5 A. Kavsek 7800
6 M. Hidayathullah ... 2500
7 P. Wisse 1200
8 G. Lambregts 1100
9 T. P 1000
10 B. Derous 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48277
Total active users1612
Act. users last 24h4
Act. users last hour0
Registered user hits last week185
Registered user hits last month836
Go up

Please help on REGISTRAR='RFS' AND APPLIED='NO';
Next thread: sar -v
Prev thread: Report - DBA and Apps DBA

Message Score Author Date
Hi All, We have noticed that the statuses of tw...... indrajit chatterjee Aug 02, 2018, 13:19
Do you have a standby database? If not then f...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Tim Boles Aug 08, 2018, 14:11
Yes Tim we do have a standby database.... indrajit chatterjee Aug 09, 2018, 08:18
Hi, first: <b>please</b> put SQL-output (for bo...... Jan Schnackenberg Aug 09, 2018, 09:24
Hello, I got the below output from the standby da...... indrajit chatterjee Aug 10, 2018, 18:59
Well, all looks good to me.... Jan Schnackenberg Aug 10, 2018, 19:14
Thanks but why am I getting below output when I am...... indrajit chatterjee Aug 12, 2018, 18:12
I would say: Yes. But I have no idea, what you mig...... Jan Schnackenberg Aug 12, 2018, 21:23
Yes I am using the queries from same database itse...... indrajit chatterjee Aug 14, 2018, 17:38
Please ignore my previous message as it was not co...... indrajit chatterjee Aug 14, 2018, 18:28
You are using the same view v$archived_log but are...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Tim Boles Aug 14, 2018, 19:37
Ok, even if you later said, that this was a mistak...... Jan Schnackenberg Aug 15, 2018, 07:54
<pre> THREAD# SEQUENCE# CREATOR REGISTR STA S AP...... indrajit chatterjee Aug 20, 2018, 16:18
Apologies Jan since I did not try to be smart and ...... indrajit chatterjee Aug 20, 2018, 16:23

Follow up by mail Click here


Subject: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: indrajit chatterjee, India
Date: Aug 02, 2018, 13:19, 80 days ago
Os info: RHEL 6.9
Oracle info: 11.2.0.4
Message: Hi All,

We have noticed that the statuses of two of the archive logs are like below where REGISTRAR='RFS' AND APPLIED='NO'; As per Oracle documentation REGISTRAR='RFS' AND APPLIED='NO' means the archivelogs have been archived but not applied. Please let us know what might be the reason for this behavior and what needs to be done from our end.



SQL> SELECT FIRST_TIME,thread#,sequence#,archived,applied from v$archived_log where REGISTRAR='RFS' AND APPLIED='NO';





FIRST_TIM THREAD# SEQUENCE# ARC APPLIED

--------- ---------- ---------- --- ---------

15-JUL-18 1 7569 YES NO

29-JUL-18 1 7736 YES NO



RECID NAME SEQUENCE# FIRST_TIM BLOCKS REGISTR DEL S

---------- ------------------------------ ---------- --------- ---------- ------- --- -

2597 7569 15-JUL-18 4 RFS YES D

3269 7736 29-JUL-18 14 RFS YES D
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: Tim Boles, United States
Date: Aug 08, 2018, 14:11, 74 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Do you have a standby database?

If not then from the said documentation you see in the description of v$archived_log

The value is always NO for local destinations.<\b>

If you have a standby database then it depends on the current status of your standby database and how you have archived apply setup.

Regards
Tim
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: indrajit chatterjee, India
Date: Aug 09, 2018, 08:18, 73 days ago
Message: Yes Tim we do have a standby database.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: Jan Schnackenberg, Germany
Date: Aug 09, 2018, 09:24, 73 days ago
Message: Hi,

first: please put SQL-output (for bonus points, the SQL statements, too) in pre-tags (see the little table at the top when you write a post here). It makes reading so much easier, if the whitespaces are not collapsed.


Now regarding your question:
If your standby database has problems with the communication with the primary, it sometimes happens that the ONLINE redo transmission fails to transfer a complete logfile. In this case the redolog will then be copied upon archival.

I've seen duplicate entries in v$archived_log in these cases.

To check this, you could execute this statement:


SELECT thread#, sequence#, registrar, archived, applied
FROM v$archived_log
WHERE thread# = 1
AND sequence# IN (7569, 7736)
AND standby_dest = 'YES';


I would expect multiple entries for both of these logfiles.

Regards,
Jan

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: indrajit chatterjee, India
Date: Aug 10, 2018, 18:59, 72 days ago
Message: Hello,
I got the below output from the standby database.



SQL> SELECT thread#, sequence#, registrar, archived, applied FROM v$archived_log WHERE thread# = 1 AND sequence# IN (7569, 7736) AND standby_dest = 'YES';



THREAD# SEQUENCE# REGISTR ARC APPLIED

---------- ---------- ------- --- ---------

1 7569 LGWR YES YES

1 7736 LGWR YES YES

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: Jan Schnackenberg, Germany
Date: Aug 10, 2018, 19:14, 72 days ago
Message: Well, all looks good to me.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: indrajit chatterjee, India
Date: Aug 12, 2018, 18:12, 70 days ago
Message: Thanks but why am I getting below output when I am using the below query ? Am I doing something wrong ?

select thread#,sequence#,archived,applied from v$archived_log where SEQUENCE#=7736 ;

THREAD# SEQUENCE# ARC APPLIED
---------- ---------- --- ---------
1 7736 YES NO
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: Jan Schnackenberg, Germany
Date: Aug 12, 2018, 21:23, 70 days ago
Message: I would say: Yes. But I have no idea, what you might be doing.

If you posted the complete SQL statement here, and you posted the correct, unedited result on Friday, then these two results can only be true if they come from different instances.

Why?

Because on Friday you posted a result for 7736, that said "APPLIED='YES'". That SQL statement had a WHERE-clause that could cause other lines for the same log to no be shown.

But today you post a query and a result for only this sequence number without any further filters. The line you had in your output on Friday MUST be in the output today, if you query from the same instance.

If you executed on of them on the primary and one on the standby, there MIGHT be this difference. I'm not 100% sure, what the "applied" column on a standby contains (I'm not at work now, and don't have access to a standby right now).

Can you please confirm, that you executed both queries on the same instance?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: indrajit chatterjee, India
Date: Aug 14, 2018, 17:38, 68 days ago
Message: Yes I am using the queries from same database itself that is from the standby database.Current output is below.

SQL> SELECT thread#, sequence#, registrar, archived, applied FROM v$archived_log WHERE thread# = 1 AND sequence# IN (7569, 7736) AND standby_dest = 'YES';

THREAD# SEQUENCE# REGISTR ARC APPLIED
---------- ---------- ------- --- ---------
1 7569 LGWR YES YES
1 7736 LGWR YES YES

SQL> select thread#,sequence#,archived,applied from v$archived_log where SEQUENCE#=7736 ;

THREAD# SEQUENCE# ARC APPLIED
---------- ---------- --- ---------
1 7736 YES NO
1 7736 YES YES
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: indrajit chatterjee, India
Date: Aug 14, 2018, 18:28, 68 days ago
Message: Please ignore my previous message as it was not correct. Here are the outputs of the queries from the standby database itself.


SQL>
SELECT thread#, sequence#, registrar, archived, applied
FROM v$archived_log
WHERE thread# = 1
AND sequence# IN (7569, 7736)
AND standby_dest = 'YES';SQL> 2 3 4 5

no rows selected



SQL> select thread#,sequence#,archived,applied from v$archived_log where SEQUENCE#=7736 and thread#=1;

THREAD# SEQUENCE# ARC APPLIED
---------- ---------- --- ---------
1 7736 YES YES



SQL> SELECT FIRST_TIME,thread#,sequence#,archived,applied from v$archived_log where REGISTRAR='RFS' AND APPLIED='NO';

FIRST_TIM THREAD# SEQUENCE# ARC APPLIED
--------- ---------- ---------- --- ---------
15-JUL-18 1 7569 YES NO
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: Tim Boles, United States
Date: Aug 14, 2018, 19:37, 68 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: You are using the same view v$archived_log but are querying it three different ways.

The first time you are limiting your query to only entries that have a STANDBY_DEST='YES'. You get 0 rows. This makes sense since these are on the standby and not being "sent" to the standby.

The second query tells us the status of sequence# 7736 thread #1. It has been applied.

The last one tells us you have a sequence# 7569 that has not been applied.

What it does not show us is if there are any other 7569 sequences recorded and their status.

Check for other sequence# of 7569.


SELECT thread#, sequence#, creator, registrar, standby_dest, status, applied, FAL from v$archived_log where sequence#=7569;
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: Jan Schnackenberg, Germany
Date: Aug 15, 2018, 07:54, 67 days ago
Message: Ok, even if you later said, that this was a mistake, the second output is EXACTLY what I expected. There are MULTIPLE entries for this sequence#.

Stop trying to be smart by filtering out everything you don't like to see. I was explicitly asking for the output of this exact statement because we need to see the whole picture.

If you keep showing us only one line while there are others, you keep us from seeing why the database might have not applied this one line.

With the next post you made the same mistake again.

I still stand by my point.

By the way. I'll just stop caring about this right now. You don't seem to think that my input is and good anyway.

Regards,
Jan
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: indrajit chatterjee, India
Date: Aug 20, 2018, 16:18, 62 days ago
Message:

THREAD# SEQUENCE# CREATOR REGISTR STA S APPLIED FAL
---------- ---------- ------- ------- --- - --------- ---
1 7569 LGWR LGWR YES A YES NO
1 7569 FGRD FGRD NO D NO NO
1 7569 RMAN RMAN NO D NO NO
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Please help on REGISTRAR='RFS' AND APPLIED='NO';
Author: indrajit chatterjee, India
Date: Aug 20, 2018, 16:23, 62 days ago
Message: Apologies Jan since I did not try to be smart and neither I had the intention to suppress the output. When I executed the query for the first time it was only showing as not being applied.It took some time to get applied later and it happened for both the sequences 7569 and 7736 for thread 1.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here