Q

Finding the SCN in the Alert Log

The Oracle documentation says you can examine the alert.log to find the SCN of the event and recover to a prior SCN. But I was unable to find any SCN in the Alert Log except the time at which I dropped my testing tablespace. Please help.

This Content Component encountered an error
The Oracle documentation says "You can also examine the alert.log to find the SCN of the event and recover to a prior SCN. Alternatively, you can determine the log sequence number that contains the recovery termination SCN, and then recover through that log."

But I was unable to find any SCN in the Alert Log except the time at which I dropped my testing tablespace. Secondly, how can I determine log sequence with recovery termination? Please help.

Unfortunately, the documentation is not exactly correct in this case.

It is rare that I find a SCN listed in my Alert Log. So you will have to use a different method. Instead of recovering via SCN, you can recover using a time. And the Alert Log does contain timestamps.

Alternatively, if you know the time, you can have Oracle determine the SCN for you with the DBMS_FLASHBACK.TIMESTAMP_TO_SCN function. This does require the database to be operational.

This was first published in August 2005

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