| ora-01110 [message #71517] |
Mon, 18 November 2002 10:22  |
leonardo celis
Messages: 2
Registered: November 2002
|
Junior Member |
|
|
|
After of the database shutdown anormal (the power suply was interrupt for the electricity company), I canīt start the database, the system shows: ORA-01110 : the datafile number 6 needs a media recovery, but I donīt have good backups.
|
|
|
|
| Re: ora-01110 [message #71519 is a reply to message #71517] |
Mon, 18 November 2002 10:59  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
you may not be able RESTORE ALL THE data.
but u may RECOVER IT.
C:>svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup nomount;
ORACLE instance started.
Total System Global Area 176182540 bytes
Fixed Size 70924 bytes
Variable Size 156504064 bytes
Database Buffers 19529728 bytes
Redo Buffers 77824 bytes
SVRMGR> alter database mount;
Statement processed.
SVRMGR> recover database;
Media recovery complete.
SVRMGR> alter database open;
Statement processed.
SVRMGR> |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
