| file missing [message #401981] |
Thu, 07 May 2009 03:39  |
IT Guru
Messages: 59
Registered: January 2007
|
Member |
|
|
DB : 9i OS : linux 2.1
db size = 4tb on 32 diffrent mount points
------------------------------------------------------------
wanted to find out about corrupted datafile in database.
With rman command
backup validate logical structure ;
It populated v$database_block_corruption view.
Found 4 entry of same same file with fractured block.
Eg. file_id = 718
but same file_id not found in v$database or dba_data_files;
can file file 717 , 719. but 718 file not there.
what could be the reason.
[EDITED by LF: removed superfluous blank lines]
[Updated on: Thu, 07 May 2009 04:57] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
