NTP on linux box was ahead of 5 hrs

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Mon, 18 Nov 2013 19:03:32 +0530
Message-ID: <CACzEWSVRLz5seAesWy_nwAiFWNvtVA9+2HjyNm95j9xO0BH_qg_at_mail.gmail.com>

Hello All,

NTP was running ahead of 5 hrs of normal time on Linux box.

We have oracle database running on that server version 10g.

Network team tried to synchronize the NTP and they synchronized the NTP on the server.

From oracle database endi have few questions.

I took a levelzero backup and all archive log backup immediately and asked the application team to release all the conections to the database and connection refresh so that none of the users are connected to the database, and then bounced the db and again took a level zero backup.

Am i missing any thing in this case that need to be taken care.

few more question in mind:-

---

Database was running and users were connected to the database during this issue occured, if some users committed the transactions and when NTP was 5 hrs ahead and does any inconsistency occur after the NTP was synchronized.

---

This has not occured but have a question for the below conditon. If suppose the DB would have crashed after the NTP synchronization and backup taken last sunday level zero, till what time would we able to recover the DB, as few archives have generated after when the NTP was 5 hrs ahead in time.

Please advise

Thanks
Nilesh

-- 
Thanks & Regards
Nilesh
Oracle DBA (sqlplus "/as sysdba" is my world)



"As our circle of knowledge expands, so does the circumference of darkness

surrounding it."--Einstein


"All men die, few men ever truly live" -- Braveheart

"You can get help from teachers, but you are going to have to learn a lot

by yourself, sitting alone in a room." --Dr. Seuss


"Know me for what I do and for not what I am. Judge me for what I can do

and not for what I have done."-Unknown


"Don't walk in front of me, I may not follow. Don't walk behind me, I may

not lead. Just walk beside me and be my friend."- Albert Camus


"Never argue with an idiot. They drag you down to their level and then beat

you with experience." - Unknown

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 18 2013 - 14:33:32 CET