Home » RDBMS Server » Server Administration » system01.dbf
system01.dbf [message #198109] Sun, 15 October 2006 00:48 Go to next message
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
Re: system01.dbf [message #198113 is a reply to message #198109] Sun, 15 October 2006 02:04 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
??????????????

Re: system01.dbf [message #198115 is a reply to message #198114] Sun, 15 October 2006 02:14 Go to previous messageGo to next message
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

Re: system01.dbf [message #198223 is a reply to message #198115] Mon, 16 October 2006 04:02 Go to previous messageGo to next message
rahshar
Messages: 26
Registered: July 2006
Location: Oman
Junior Member
Thanks User52,

i'll give it a try.

Thanks once again.
Re: system01.dbf [message #198236 is a reply to message #198223] Mon, 16 October 2006 04:30 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You're Welcome !
Re: system01.dbf [message #198341 is a reply to message #198115] Mon, 16 October 2006 12:55 Go to previous messageGo to next message
joy_division
Messages: 4617
Registered: February 2005
Location: East Coast USA
Senior Member
user52 wrote on Sun, 15 October 2006 03:14
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.



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 Go to previous messageGo to next message
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
Re: system01.dbf [message #440933 is a reply to message #198109] Thu, 28 January 2010 00:01 Go to previous messageGo to next message
vivek.chauhan
Messages: 1
Registered: January 2010
Junior Member
please upload currupted files.
Re: system01.dbf [message #440938 is a reply to message #440933] Thu, 28 January 2010 00:38 Go to previous message
Michel Cadot
Messages: 63812
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: not able to sccess the oracle 10g server
Next Topic: one schema vs multiple schema
Goto Forum:
  


Current Time: Fri Sep 30 07:14:33 CDT 2016

Total time taken to generate the page: 0.11990 seconds