| Please help me recover this database [message #405616] |
Thu, 28 May 2009 12:21  |
lancyld
Messages: 9
Registered: May 2009
|
Junior Member |
|
|
I have used this create control file script to create the controlfile
CREATE CONTROLFILE SET DATABASE "FLAT" RESETLOGS NOARCHIVELOG
MAXLOGFILES 36
MAXLOGMEMBERS 1
MAXDATAFILES 1024
MAXINSTANCES 12
MAXLOGHISTORY 1361
LOGFILE
GROUP 1 (
'D:\oracle\oradata\FLAT\REDO01.LOG'
) SIZE 100M,
GROUP 2 (
'D:\oracle\oradata\FLAT\REDO02.LOG'
) SIZE 100M,
GROUP 3 (
'D:\oracle\oradata\FLAT\REDO03.LOG'
) SIZE 100M
DATAFILE
'd:\oracle\oradata\FLAT\SYSTEM01.DBF',
'D:\oracle\oradata\FLAT\BOMTABLES.DBF',
'D:\oracle\oradata\FLAT\CWMLITE01.DBF',
'D:\oracle\oradata\FLAT\DRSYS01.DBF',
'D:\oracle\oradata\FLAT\INDX01.DBF',
'D:\oracle\oradata\FLAT\PRADINDEX01.DBF',
'D:\oracle\oradata\FLAT\TOOLS01.DBF',
'D:\oracle\oradata\FLAT\UNDOTBS01.DBF',
'D:\oracle\oradata\FLAT\UNDOTBS02.DBF',
'D:\oracle\oradata\FLAT\USERS01.DBF',
--'F:\ORACLE\ORADATA\FLAT\PRADTEMP.DBF',
'F:\ORACLE\ORADATA\FLAT\PRADUSER.DBF'
;
then i use an alter database open command
alter database open;
output is
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
i use resetlogs switch
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\FLAT\SYSTEM01.DBF'
i try to use noresetlogs switch
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open
i try to recover database
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
please help me recover this database
|
|
|
|
| Re: Please help me recover this database [message #405617 is a reply to message #405616] |
Thu, 28 May 2009 12:25  |
lancyld
Messages: 9
Registered: May 2009
|
Junior Member |
|
|
i use a until cancel switch and i get this error
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 13 is unknown - rename to correct file
ORA-01110: data file 13: 'D:\ORACLE\ORA90\DATABASE\UNNAMED00013'
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01111: name for data file 13 is unknown - rename to correct file
ORA-01110: data file 13: 'D:\ORACLE\ORA90\DATABASE\UNNAMED00013'
|
|
|
|
| Re: Please help me recover this database [message #405619 is a reply to message #405617] |
Thu, 28 May 2009 12:30 |
lancyld
Messages: 9
Registered: May 2009
|
Junior Member |
|
|
i shut immediate and try to open the startup the database again and i get this error
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
|
|
|
|
| Re: Please help me recover this database [message #405623 is a reply to message #405619] |
Thu, 28 May 2009 12:45 |
lancyld
Messages: 9
Registered: May 2009
|
Junior Member |
|
|
i try to recreate the control file with noresetlogs and noarchivelogs options and again run alter database open;
i get this error
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 9.0.1.0.1 - Production on Thu May 28 23:14:59 2009
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
SQL> @d:flat.sql
Control file created.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'F:\ORACLE\ORADATA\FLAT\PRADUSER.DBF'
|
|
|
|
|
|
|
|
| Re: Please help me recover this database [message #405664 is a reply to message #405628] |
Thu, 28 May 2009 23:34 |
lancyld
Messages: 9
Registered: May 2009
|
Junior Member |
|
|
Our erp server crashed and windows could not be revived back
So i installed a second server and copied the dbf files and other required data files from the old crashed server into the new one
now after installing oracle (software only) i created a control file using the below create controlfile script
CREATE CONTROLFILE REUSE DATABASE "FLAT" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 36
MAXLOGMEMBERS 1
MAXDATAFILES 1024
MAXINSTANCES 12
MAXLOGHISTORY 1361
LOGFILE
GROUP 1 (
'D:\oracle\oradata\FLAT\REDO01.LOG'
) SIZE 100M,
GROUP 2 (
'D:\oracle\oradata\FLAT\REDO02.LOG'
) SIZE 100M,
GROUP 3 (
'D:\oracle\oradata\FLAT\REDO03.LOG'
) SIZE 100M
DATAFILE
'd:\oracle\oradata\FLAT\SYSTEM01.DBF',
'D:\oracle\oradata\FLAT\BOMTABLES.DBF',
'D:\oracle\oradata\FLAT\CWMLITE01.DBF',
'D:\oracle\oradata\FLAT\DRSYS01.DBF',
'D:\oracle\oradata\FLAT\INDX01.DBF',
'D:\oracle\oradata\FLAT\PRADINDEX01.DBF',
'D:\oracle\oradata\FLAT\TOOLS01.DBF',
'D:\oracle\oradata\FLAT\UNDOTBS01.DBF',
'D:\oracle\oradata\FLAT\UNDOTBS02.DBF',
'D:\oracle\oradata\FLAT\USERS01.DBF',
--'F:\ORACLE\ORADATA\FLAT\PRADTEMP.DBF',
'F:\ORACLE\ORADATA\FLAT\PRADUSER.DBF'
;
Please note i was not able to mount the PRADTEMP.dbf which i have commented above.
then i did the steps that i have specified earlier.
I donot have the archive files. neither have resetlogs.
I just want to mount the database and also want to extract data out. this erp is not used now.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
