-
ORA-01578: ORACLE data block corrupted (file # 1, block # 2)
Hi,
I can't able to connet to the database, while connecting i'm receiving the below error:
ERROR: ORA-01034: ORACLE not available
I shutdown the database and restarted it, while during this process i face new error :
ORA-01578: ORACLE data block corrupted (file # 1, block # 2)
Can any one help me to sort this out?
SQL*Plus: Version 3.0.11.1.2 - Production on Thu Aug 23 15:04:50 2012
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
Enter user-name: netmon
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-07318: smsget: open error when opening sgadef.dbf file.
SunOS Error: 2: No such file or directory
-
You posted this question in the wrong forum, so I moved it to the correct forum.
This is one reason why you want to use RMAN to backup your database. You can do block level recovery with RMAN. You should probably get an RMAN backup now before you try to recover any blocks, if you don't already have an RMAN backup.
Here is a document on getting started with RMAN
http://docs.oracle.com/cd/B28359_01/...0/rcmquick.htm
Here is a document for doing block level recovery.
http://docs.oracle.com/cd/B28359_01/...0/rcmblock.htm
Block level corruption should not happen as a matter of course, however it is relatively easy to deal with, once you have a good backup and recovery strategy.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|