Home » RDBMS Server » Backup & Recovery » Recovery with DBF, CTL and LOG.TXT files (8.1.5.0.0)
Recovery with DBF, CTL and LOG.TXT files [message #353629] Tue, 14 October 2008 07:09 Go to next message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
Hi

I am not expert in DBA and data recovery.

So can someone guide me (if possible) that how can i recover data if i have accidentally deleted oracle but managed to save DBF. CTL and LOG.TXT files present in oracle\oradata\<sid>name folder.

Thanks in advance

-Dude
Re: Recovery with DBF, CTL and LOG.TXT files [message #353737 is a reply to message #353629] Tue, 14 October 2008 23:09 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Your version is not supported.
The recovery process is as usual.
1)Restore/copy pfile. If dont have create and set associated parameter like db_name, control_files, memory etc.
2)start instance with the pfile
3)show control_files location in the pfile.
4)Restore /copy controlfiles(.CTL) to the location.
5)startup mount
6)alter database open resetlogs
Re: Recovery with DBF, CTL and LOG.TXT files [message #353834 is a reply to message #353629] Wed, 15 October 2008 05:12 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
dude4084 wrote on Tue, 14 October 2008 08:09
i have accidentally deleted oracle

What does this truly mean ?

What is LOG.TXT? Are these the redo logs ?
Was the database open when you "deleted oracle" ?
What operating system are you on ?
Re: Recovery with DBF, CTL and LOG.TXT files [message #353863 is a reply to message #353834] Wed, 15 October 2008 06:31 Go to previous messageGo to next message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
To Arju >>
I think i need complete step by step guidance.
Please guide.

To ebrian >>
Quote:
What does this truly mean ?



Ok here are the facts.

OS Windows 2000 was installed on Drive C while oracle was installed on drive D. My brother formatted drive C and reinstalled windows 2000. As a result oracle was not working and hence i can only retrieve files present in oradata\<sid> folder.

Quote:
What is LOG.TXT? Are these the redo logs ?


Yes, you are right they are REDO01.LOG.TXT and REDO02.LOG.TXT files.

Quote:
Was the database open when you "deleted oracle" ?

in above mentioned scenario, i think database was not opened.

Quote:
What operating system are you on ?

Operation system is windows 2000


Still seeing step by step guidance
-Dude
Re: Recovery with DBF, CTL and LOG.TXT files [message #354058 is a reply to message #353863] Thu, 16 October 2008 04:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can't use that files, you need to uninstall (detete oracle directory) or re-install oracle software.

or if you have backup of your database then restore it otherwise create new database.


Re: Recovery with DBF, CTL and LOG.TXT files [message #354068 is a reply to message #354058] Thu, 16 October 2008 06:06 Go to previous messageGo to next message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
Quote:
You can't use that files, you need to uninstall (detete oracle directory) or re-install oracle software.

or if you have backup of your database then restore it otherwise create new database.


I have deleted the oracle directory and has re-installed oracle.
But before deleting oracle, i have saved oradata folder having DBF, CTL and REDO**LOG.TXT files.

Now i am desirous to recover data from these DBF, CTL and LOG.TXT files and seeking help.
Re: Recovery with DBF, CTL and LOG.TXT files [message #354069 is a reply to message #354068] Thu, 16 October 2008 06:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

i have saved oradata folder having DBF, CTL and REDO**LOG.TXT files.

but that files is not useful for you becuase it is not a backup.
or it is not a simple OS files. it is database files which you want to create db. for that you need BACKUP.


Re: Recovery with DBF, CTL and LOG.TXT files [message #354071 is a reply to message #354069] Thu, 16 October 2008 06:13 Go to previous messageGo to next message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
Quote:
but that files is not useful for you becuase it is not a backup.
or it is not a simple OS files. it is database files which you want to create db. for that you need BACKUP.


so is there any method to save data in scenario which i have explained?

Re: Recovery with DBF, CTL and LOG.TXT files [message #354080 is a reply to message #354071] Thu, 16 October 2008 06:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Those files should definitely work IF they are truly the files that consisted of your database. For Windoze, you'll need to reinstall the Oracle software, create the Window's Oracle service with oradim and then you can "try" to start your database up. At this point, you'll know if you need recovery or not.

[Updated on: Thu, 16 October 2008 06:39]

Report message to a moderator

Re: Recovery with DBF, CTL and LOG.TXT files [message #354084 is a reply to message #354080] Thu, 16 October 2008 06:44 Go to previous messageGo to next message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
ebrian wrote on Thu, 16 October 2008 16:39
Those files should definitely work IF they are truly the files that consisted of your database. For Windoze, you'll need to reinstall the Oracle software, create the Window's Oracle service with oradim and then you can "try" to start your database up. At this point, you'll know if you need recovery or not.


Well, there was only one database present in the oracle before formatting and deletion of oracle directory. So i believe that the save files of DBF, CTL and LOG.TXT files definitely belongs to my data.

My Original sid name was ali. I am ready to create new database sid with the name of oradim but i don't know how to startup the database.

Kindly guide me step by step.
Re: Recovery with DBF, CTL and LOG.TXT files [message #354091 is a reply to message #354084] Thu, 16 October 2008 07:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Prior to starting the database, you need to ensure you have an appropriate pfile to reference for starting the database.

Check oradim for usage of this utility. As an example, you could use:

oradim -NEW -SID ali -STARTMODE manual -PFILE C:\oracle\product\8.1.5\database\initali.ora

At this point, you can try the following:

set oracle_sid=ali
sqlplus "/ as sysdba"
startup

At this point, you'll know if you need to perform recovery.
Re: Recovery with DBF, CTL and LOG.TXT files [message #354398 is a reply to message #354091] Sat, 18 October 2008 07:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Yes ebrain,
it will work if files are consistent but i don't think when OS drive is format that time db is shutdown.
Re: Recovery with DBF, CTL and LOG.TXT files [message #354403 is a reply to message #354398] Sat, 18 October 2008 08:15 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Actually, assuming the files didn't get physically corrupt, the files should work whether they are consistent or not.
Previous Topic: ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], [] (merged)
Next Topic: Datafile Corrupted
Goto Forum:
  


Current Time: Mon Dec 09 20:36:25 CST 2024