Friday, July 18, 2008

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.

Friday, July 11, 2008

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.