Check date and hour restore

Posted on 2011-05-09
Last Modified: 2012-05-11

How can I check at what time a db has been restored?


Question by:bibi92
    LVL 73

    Expert Comment

    you can look in the alert log for timestamps of major events

    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Not sure this exists inside the database itself.  Maybe another expert knows of some view that might contain this.

    What tool did the restore?  It might have logs that you can check.
    LVL 73

    Accepted Solution

    you could look in v$instance for startup_time too.

    assuming after your database restored and it hasn't been restarted since.
    The startup_time should reflect when the restoration happened.

    Author Closing Comment

    Thanks regards bibi

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now