| database problem [message #70286] |
Mon, 20 May 2002 04:09  |
ajay d.vyas
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
hai
i start the db & it is giving this error
SVRMGR> connect internal
Connected.
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 57124108 bytes
Fixed Size 70924 bytes
Variable Size 40198144 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: 'D:ORACLEORADATAVINODUSERS123.DBF'
SVRMGR>
but i have important data in this dbf file
i don't have backup also
i want to recover the data
bye
vyas
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
