Home » RDBMS Server » Backup & Recovery » Startup Failing (Oracle Home 91)
Startup Failing [message #340961] Fri, 15 August 2008 05:46 Go to next message
abis123
Messages: 31
Registered: February 2007
Member
I am hosting an Oracle database on a Virtual Machine (VM) and recently it (the VM) has become very unstable crashing frequently. This is what I feel has created a problem that stops me from being able to gain access to the database.

I cannot log on as a normal user as it informs me the database is initialising or shutting down. However I am able to log on as a SYSOPER but I then get the following error message when I shut-down and start-up the database:

ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 7233 change 78463090 time 08/14/2008 15:26:26
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\ORA9\REDO01.LOG'

I have 'Googled' the oracle errors but as they can refer to different files have found no answer yet. Any help would be very much appreciated. If possible backing up a single schema would be sufficient as I can just restore this to an earlier backup I have of the VM. Many thanks.
Re: Startup Failing [message #340967 is a reply to message #340961] Fri, 15 August 2008 06:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&q=oracle+log+corruption&meta=

Regards
Michel
Re: Startup Failing [message #341006 is a reply to message #340967] Fri, 15 August 2008 08:44 Go to previous messageGo to next message
abis123
Messages: 31
Registered: February 2007
Member
Firstly, thank you for your reply. I have looked through the Google results and went with the 'recover database until cancel', which brought up the following error message:

ORA-00279: change 7845390 generated at 08/04/2008 15:26:26 needed for thread 1
ORA-00289: suggestion: C:\ORACLE\ORA92\RDBMS\ARC00395.001
ORA-00280: change 28463090 for thread 1is in sequence #395

and the 'recover database until change 7846390', which brought up this error message:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORA9\SYSTEM01.DBF'

Can anyone suggest what I should do to fix the C:\ORACLE\ORADATA\ORA9\SYSTEM01.DBF file please? Many thanks.
Re: Startup Failing [message #341044 is a reply to message #340961] Fri, 15 August 2008 15:18 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
If you do not have all the archived redo log files since 4 August,
you should restore the DB from a previous backup.

If your database does not have good backups, it means you do not care if you lose the data in the DB.
Re: Startup Failing [message #341350 is a reply to message #341044] Mon, 18 August 2008 08:34 Go to previous message
abis123
Messages: 31
Registered: February 2007
Member
Not really, it would mean I forgot to do a backup. However I do have a month old backup and have decided to just revert back to that and make whatever changes I did to this over the past month. This time however I'm thinking a backup every other day would be smart!
Previous Topic: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
Next Topic: Incremental Backup and Read-Only / Read-Write tablespaces
Goto Forum:
  


Current Time: Wed Dec 07 16:14:34 CST 2016

Total time taken to generate the page: 0.08398 seconds