Archive gap on oracle db

1) Query v$archive_gap;

2) Note difference between low sequence and high sequence.

3) Copy the files to standby_archive_dest.

4) Do alter database register logfile for all the copied archive logs.

5) Managed recovery.

6) On the standby database, query the V$ARCHIVED_LOG view to verify the archived redo log was applied.

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;





Doing the 4th step updates the standby control file. The MRP process is checking the control
file when the managed recovery is activated and applies the new archive logs in the stdby control
file. In normal log-shipping, the update to the control file is done by the RFS.

Have no fear - Swami Vivekananda

First, believe in the world—that there is meaning behind everything.

Don't look back—forward, infinite energy, infinite enthusiasm, infinite daring, and infinite patience—then alone can great deeds be accomplished.

This is the first lesson to learn: be determined not to curse anything outside, not to lay the blame upon anyone outside, but stand up, lay the blame on yourself. You will find that is always true. Get hold of yourself.

Tell the truth boldly, whether it hurts or not. Never pander to weakness. If truth is too much for intelligent people and sweeps them away, let them go; the sooner the better.

This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger.

This I have seen in life—those who are overcautious about themselves fall into dangers at every step; those who are afraid of losing honor and respect, get only disgrace; and those who are always afraid of loss, always lose.

"Face the brutes." That is a lesson for all life—face the terrible, face it boldly. Like the monkeys, the hardships of life fall back when we cease to flee before them.

Those who work at a thing heart and soul not only achieve success in it but through their absorption in that they also realize the supreme truth—Brahman. Those who work at a thing with their whole heart receive help from God.

I, for one, thoroughly believe that no power in the universe can withhold from anyone anything they really deserve.

The whole secret of existence is to have no fear. Never fear what will become of you, depend on no one. Only the moment you reject all help are you free.

Fear is death, fear is sin, fear is hell, fear is unrighteousness, fear is wrong life. All the negative thoughts and ideas that are in the world have proceeded from this evil spirit of fear.

spiritual flower

Do not look for a spiritual flower every day. Sow
the seed, water it with prayer and right endeavor.
When it sprouts, take care of the plant, pulling out the
weeds of doubt, indecision, and indifference that may
spring up around it. Some morning you will suddenly
behold your long-awaited spiritual flower of Realization.
(Paramahansa Yogananda)

On Second thoughts in Pune

The anecdote is among the early days in pune when I was searching for a room. One day I went to a place called dahanukar colony in the kothrud area looking for a room. I had to urgently get a printout of the emails to my personal mail id listing the other places where I could enquire for accomodation. I was searching for a cyber cafe and looked high and low for one. After some enquiry and walkabout, I located a good-looking cyber cafe on the main road. Just after the entrance of the cyber-cafe two young (good-looking) ladies were standing in jeans and t-shirts.

With thoughts of urgency about my room-search filled in my mind I went inside ,after opening the door and asked them matter-of-factly "What is the hourly rate?" . They were confused so I looked elsewhere inside the cyber-cafe and I realised that the manager was sitting slightly out of sight of the main entrance. He seemed to have overheard the conversation but waited for me to ask the same question again. Rs.10/- he said. When I was at my seat, he started giving a strange smile to me. He was still smiling at me when I left the cyber-café.

Only couple of days back, I realised what he was trying to interpret wrt to my question to the two ladies !!!! Very bad , wot say???

Weakening a bad habit - Paramhansa Yogananda

Habits of thought are mental magnets that draw to you certain things, people, and conditions. Weaken a bad habit by avoiding everything that occasioned it or stimulated it, without concentrating upon it in your zeal to avoid it. Then divert your mind to some good habit and steadily cultivate it until it becomes a dependable part of you.

Devotion over reasoning

One should not reason too much; it is enough if one loves the Lotus
feet of the Mother. Too much reasoning throws the mind into
confusion. You get clear water if you drink from the surface of a
pool. Put your hand deeper and stir the water, and it becomes
muddy. Therefore pray to God for devotion.
(Ramakrishna, `The Gospel of Sri Ramakrishna' )