GeekInterview.com
Series: Subject: Topic:
Question: 8 of 291

What is the use of SCN number? When does SCN increment?

Asked by: muralikasya | Member Since Dec-2009 | Asked on: Dec 22nd, 2011

View all questions by muralikasya   View all answers by muralikasya

Showing Answers 1 - 1 of 1 Answers
Neer.ocp10g

Answered On : Jan 20th, 2012

View all answers by Neer.ocp10g

The SCN is an important quantifier that oracle uses to keep track of its state at any given point in time. The SCN is used to keep track of all changes within the database, its a logical timestamp that is used by oracle to order events that have occurred within the database. SCNs are increasing sequence numbers and are used in redo logs to confirm that transactions have been committed, all SCNs are unique. SCNs are used in crash recovery as the control maintains a SCN for each data file, if the data files are out of sync after a crash oracle can reapply the redo log information to bring the database backup to the point of the crash. You can even take the database back in time to a specific SCN number (or point in time).

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Oracle DBA FAQ

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.