OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » system01.dbf

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

system01.dbf [message #198109]

Sun, 15 October 2006 00:48

rahshar
Messages: 26
Registered: July 2006
Location: Oman

Junior Member

My system01.dbf file is corrupted, how can I retrieve the data and

I can Log in as sysdba and mount the database, but the database is unable to open because of the system01.dbf file is corrupted or virus infected. I cleaned the virus and no valid enteries found.

Please some one help

Report message to a moderator

Re: system01.dbf [message #198113 is a reply to message #198109]

Sun, 15 October 2006 02:04

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

If you have old consistent bkp then replace and open ur database.
****************
Check the Note:28814.1 Handling Block Corruptions in Oracle7 / 8 / 8i / 9i / 10g on the metalink.

[Updated on: Sun, 15 October 2006 02:11]

Report message to a moderator

Re: system01.dbf [message #198114 is a reply to message #198113]

Sun, 15 October 2006 02:11

rahshar
Messages: 26
Registered: July 2006
Location: Oman

Junior Member

Thanks user52,

But the probs is that, backup file location was on another computer on the network and it is down.
??????????????

Report message to a moderator

Re: system01.dbf [message #198115 is a reply to message #198114]

Sun, 15 October 2006 02:14

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

First check Metalink reference.

Second try to up ur network.

Third " system tbs " not content any user data so don't worry bcoz user data is not lost. system tbs content data dictionary information data.

possible u create new database
and export complete user data from old database
and
import complete user data from new database.

hope this helps

Report message to a moderator

Re: system01.dbf [message #198223 is a reply to message #198115]

Mon, 16 October 2006 04:02

rahshar
Messages: 26
Registered: July 2006
Location: Oman

Junior Member

Thanks User52,

i'll give it a try.

Thanks once again.

Report message to a moderator

Re: system01.dbf [message #198236 is a reply to message #198223]

Mon, 16 October 2006 04:30

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You're Welcome !

Report message to a moderator

Re: system01.dbf [message #198341 is a reply to message #198115]

Mon, 16 October 2006 12:55

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

user52 wrote on Sun, 15 October 2006 03:14

that assumes no users are putting any objects in the SYSTEM tablespace.

Quote:

possible u create new database
and export complete user data from old database
and
import complete user data from new database.

Maybe user tables are not (should not be) stored in the SYSTEM tablespace, but all the metadata and source code is. If there is no SYSTEM tablespace, I'm afraid you would be in for a big headache.
Additionally, how do you suppose one is to do an export is there is no SYSTEM tablespace?

[Updated on: Mon, 16 October 2006 12:56]

Report message to a moderator

Re: system01.dbf [message #198398 is a reply to message #198341]

Tue, 17 October 2006 01:16

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

I know "system tbs" content all metadata.
read my previous post i was written export complete user data mean "user tbs or may be data tbs" simple User input data not "metadata".

System Tbs is very important tbs in database.
it cann't be get offline.
it must for normal database operation.

[code]
Losing Datafiles in ARCHIVELOG Mode
If either a permanent or temporary media failure affects the datafiles of a database operating in ARCHIVELOG mode, then the following scenarios can occur.

Damaged Datafiles Database Status Solution
Datafiles in the SYSTEM tablespace or datafiles with active undo segments. Database shuts down. If the hardware problem is temporary, then fix it and restart the database. Usually, crash recovery recovers lost transactions. If the hardware problem is permanent, then recover the database as described in "Performing Closed Database Recovery".

Go Through Below link for more assistance.
http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/osrecov007.htm#i1011267

Report message to a moderator

Re: system01.dbf [message #440933 is a reply to message #198109]

Thu, 28 January 2010 00:01

vivek.chauhan
Messages: 1
Registered: January 2010

Junior Member

please upload currupted files.

Report message to a moderator

Re: system01.dbf [message #440938 is a reply to message #440933]

Thu, 28 January 2010 00:38

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I doubt (and I hope) that his corruption is now fixed after 40 months.
In addition, I don't think someone will upload a SYSTEM tablespace in a forum.
What had you in mind when you asked this?

Regards
Michel

Report message to a moderator

Previous Topic:	not able to sccess the oracle 10g server
Next Topic:	one schema vs multiple schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 11:49:01 CST 2024