OraFAQ Forum: Server Utilities » DATAFILE SYSTEM IN STATUS SYSOFF

Home » RDBMS Server » Server Utilities » DATAFILE SYSTEM IN STATUS SYSOFF

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

DATAFILE SYSTEM IN STATUS SYSOFF [message #74709]

Mon, 07 February 2005 06:20

marcela
Messages: 6
Registered: July 2004

Junior Member

Please, somebody could help me?
I can't open database because I have the system datafile in status SYSOFF.
What can I do? How can I change that datafile to ONLINE?
Thanks a lot

Report message to a moderator

Re: DATAFILE SYSTEM IN STATUS SYSOFF [message #74719 is a reply to message #74709]

Tue, 08 February 2005 04:17

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Try to bring it online:

RECOVER DATAFILE '/path/file';
ALTER DATABASE DATAFILE '/path/file' ONLINE;

Also, check for problems in your ALERT.LOG file.

Best regards.

Frank

Report message to a moderator

Re: DATAFILE SYSTEM IN STATUS SYSOFF [message #74723 is a reply to message #74719]

Tue, 08 February 2005 06:06

marcela
Messages: 6
Registered: July 2004

Junior Member

Thanks a lot Frank.
I tried but...didn't work

I supouse that I must recreate the database. The only good news is this database was just for training....

Thanks anyway!

Marce

Report message to a moderator

Re: DATAFILE SYSTEM IN STATUS SYSOFF [message #118172 is a reply to message #74723]

Tue, 03 May 2005 08:15

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Hi all

when can we have the status of a file as SYSOFF. as per my knowledge status can be either "INVALID" or "AVAILABLE".

Thnx in advance.

Report message to a moderator

Previous Topic:	Log Miner and Lob datatypes
Next Topic:	Import schema from prod to test db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 06:15:40 CDT 2024