Q

Check current SCN in control file

How to check current SCN or header in the control file?

How to check current SCN or header in the control file?

The V$DATABASE view has a column called CURRENT_SCN. The control file will be updated shortly after you query V$DATABASE. If you must see the SCN in the control file (not sure why this would be terribly important), you can dump the control file's contents. On my Web site I have a white paper titled "Dumping Oracle Blocks." Towards the end of that paper, I show how to dump the contents of the control file. This will show a number of SCNs for various operations logged in the control file.
This was first published in March 2007

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close