Home » RDBMS Server » Server Administration » file missing
file missing [message #401981] Thu, 07 May 2009 03:39 Go to next message
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

Re: file missing (merged) [message #402000 is a reply to message #401981] Thu, 07 May 2009 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not multipost
Follow posting guidelines
Do not put useless empty lines

Regards
Michel

[Updated on: Thu, 07 May 2009 06:42]

Report message to a moderator

Re: file missing (merged) [message #402019 is a reply to message #402000] Thu, 07 May 2009 05:51 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

what about dbv utiliy ?

babu
Re: file missing (merged) [message #402044 is a reply to message #402019] Thu, 07 May 2009 07:15 Go to previous messageGo to next message
IT Guru
Messages: 59
Registered: January 2007
Member
dbv utility but on which file ?
Re: file missing [message #402133 is a reply to message #401981] Thu, 07 May 2009 14:59 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You should submit a bug report to Oracle.
Previous Topic: downgrading an upgraded database
Next Topic: Oracle internal error
Goto Forum:
  


Current Time: Thu Dec 08 20:08:54 CST 2016

Total time taken to generate the page: 0.13968 seconds