Home » RDBMS Server » Backup & Recovery » Please help me recover this database
Please help me recover this database [message #405616] Thu, 28 May 2009 12:21 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #405627 is a reply to message #405623] Thu, 28 May 2009 12:53 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
ORA-01113: file string needs media recovery
Cause: An attempt was made to online or open a database with a file that is in need of media recovery.

Action: First apply media recovery to the file.


Babu
Re: Please help me recover this database [message #405628 is a reply to message #405627] Thu, 28 May 2009 12:56 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
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' 



If I look your control file and the above error message; Something differnt; Can you tel me exactly what you did?

Babu
Re: Please help me recover this database [message #405664 is a reply to message #405628] Thu, 28 May 2009 23:34 Go to previous message
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.

Previous Topic: Database backup
Next Topic: RMAN - Delete backed up archive logs
Goto Forum:
  


Current Time: Thu Dec 08 22:08:00 CST 2016

Total time taken to generate the page: 0.08681 seconds