Skip to Content
avatar image
Former Member

oracle database verification


After i've installed a new production system, we had a disk problem on a partition and we've lost oraarch, origlogA and origlogB folders. I've created oraarch folder. I only lost offline redo log files and it is not very important because users has never been log on this system. I've created origlogA and origlogB folder and copy content of mirrlogA and mirrlogB folder to these folders

But i am not sure this database is healty or not. How can i sure about this issue? Have you got any recommendation?

Best Regards....

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 08, 2010 at 03:03 PM

    Make sure you take a offline offline backup of your database first.

    Did you copied the content to origlog* while DB was online or offline.

    Run dbcheck from brtools or DB13.

    Shutdown your DB and bring online, check the database alert_<SID>.log file under saptrace folder.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Sunil Bujade

      Thank you but this information is not related about my db verification problem. Isn't it? I think you give general recommendation and oracle release and parameters are not related with verification issue.

      Best Regards...

      Edited by: Hande Kilcer on Dec 12, 2010 10:24 PM

  • avatar image
    Former Member
    Dec 09, 2010 at 07:12 AM

    No worries,

    If it is a newly installed system, we can say that it's a dummy.

    So just make sure that you can shutdown and startup the DB without any issues.

    If any issue let us know.

    If no issues....then proceed with post installation steps - Latest kernel update, update statistics, DB verification etc.

    ORA1031 is a common error comes when the user doesn't have suf access privillages to execute and can easily resolved by giving suf access rights.


    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded