| Data Block corrupt [message #74054] |
Wed, 01 September 2004 00:54  |
Tarun Biswas
Messages: 23
Registered: May 2004
|
Junior Member |
|
|
hi friends
when i try to open one database it is not opening.from alert log i came to know the one data block is corrup on system tablespace datafile. how will i open the database? and how will i recover the corruptd block?
pls help....
Thanks
Tarun
|
|
|
|
| Re: Data Block corrupt [message #74056 is a reply to message #74054] |
Wed, 01 September 2004 03:42  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
Backup your database, then try the following from RMAN. Your DB must be mouted:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> BLOCKRECOVER CORRUPTION LIST;
The above commands will run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION, then repair the corrupted blocks recorded in this view:
If this doesn't work, you will have to log an iTAR with Oracle Support!
Best regards.
Frank
|
|
|
|
| Re: Data Block corrupt [message #74061 is a reply to message #74056] |
Wed, 01 September 2004 09:50 |
Vikas Arya
Messages: 7
Registered: August 2004
|
Junior Member |
|
|
If the data block belongs to a non system tablespace then u can take the datafile offline and open the database.
Latter you can try what Frank has suggested.
Aleast the database will be in open mode.
Incase what Frank has suggested does not work, you can try to recover the object to which the corrupt block belongs from the previous backup based on the backup plan u have got.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
