• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 775
  • Last Modified:

Oracle restore from dbf files...

Folks

It seems that I will have to restore an Oracle 11 database from the actual file system level storage files, i.e. the *.dbf files (seems that the dumps are not recoverable :( ).

Although most likely not ideal I guess this should be possible… As such any pointer / recommendation would be most appreciated !

Regards

alex

PS: Running Oracle 10.2 XE on W2k3
0
Alexandre Takacs
Asked:
Alexandre Takacs
  • 3
  • 2
1 Solution
 
sdstuberCommented:
you cannot restore a version 11 db with oracle 10.2 XE
0
 
Alexandre TakacsCTOAuthor Commented:
Sorry by bad

This is Oracle 11 all around :)
0
 
sdstuberCommented:
Do you have all of the files?  All dbf,  control files, redo, spfile, etc?
Is your dba around?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Alexandre TakacsCTOAuthor Commented:
Well I believe I do have a full copy of all files (the database was stopped each time file level backup was performed and as far as I can tell everything is there). And I want to be the dab in this instance as muc as possible :)
0
 
mhenry20IT Operations DirectorCommented:
If the database was off line when the dbf files were backed up you can just put them back in place.  IF you have only one control file for the backup you can copy and use it for the rest of the control files needed.  If you did not backup your online redo files then you may need to reset logs when you start up.

If you have archive logs then the process is to recover your your files.  Startup mount the database and then "recover database until cancel using backup controlfile;"  This will examine the archive redo logs and apply any that newer then the backup.  When it cannot find any more usable log files you type cancel and then you can open the database: alter database open or alter database open reset logs.
 
0
 
Alexandre TakacsCTOAuthor Commented:
well FWIW it did indeed work ok by restoring the files "as is",,, amazing :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now