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.

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 last published in August 2005

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close