| The problem of opening the database [message #166221] |
Wed, 05 April 2006 04:39  |
wanalife
Messages: 2
Registered: April 2006
Location: CI
|
Junior Member |
|
|
dear all
I have a problem of opening the database ,
which is as follows:
*****************************************************************
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01245: offline file 1 will be lost if RESETLOGS is d
ORA-01110: data file 1: 'F:\ORANT\DATABASE\SYS1INC.ORA'
*****************************************************************
It's great pleasure to have the reply from you!
thanks
|
|
|
|
|
|
| Re: The problem of opening the database [message #166353 is a reply to message #166221] |
Wed, 05 April 2006 20:40  |
wanalife
Messages: 2
Registered: April 2006
Location: CI
|
Junior Member |
|
|
thank you for your reply,at first ,I made the datafile be offline,then tryed to drop it , but oracle gives me the message as follows:
**************************************************************
svrmgr>alter database datafile 'F:\ORANT\DATABASE\SYS1INC.ORA' drop
*
ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END expected
**************************************************************
I am a new guy on the oracle, as far as I know,The datafile of sys1***.ORA can't be dropped.
thanks
|
|
|
|
| Re: The problem of opening the database [message #166366 is a reply to message #166353] |
Thu, 06 April 2006 00:19 |
aciolac
Messages: 242
Registered: February 2006
|
Senior Member |
|
|
One question - is the file 'F:\ORANT\DATABASE\SYS1INC.ORA' from the SYSTEM tablespace? If so, then You must get online them:
SQL>alter database datafile 'F:\ORANT\DATABASE\SYS1INC.ORA' online;
Possible will be necessary to recover them. It is very bad idea to put offline files from SYSTEM database.
|
|
|
|
| Re: The problem of opening the database [message #166890 is a reply to message #166366] |
Mon, 10 April 2006 03:04 |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
| aciolac wrote on Thu, 06 April 2006 00:19 |
One question - is the file 'F:\ORANT\DATABASE\SYS1INC.ORA' from the SYSTEM tablespace? If so, then You must get online them:
SQL>alter database datafile 'F:\ORANT\DATABASE\SYS1INC.ORA' online;
Possible will be necessary to recover them. It is very bad idea to put offline files from SYSTEM database.
|
Agree!
Furthur more, you cannot drop any datafiles before oracle10g. You only can drop tablespaces.
Alex zeng|Skype me: hans9zeng
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
