Home » RDBMS Server » Backup & Recovery » New to Oracle - NEED HELP IMMEDIATELY (Oracle 11g)
New to Oracle - NEED HELP IMMEDIATELY [message #572317] Mon, 10 December 2012 09:43 Go to next message
dschreiber
Messages: 1
Registered: December 2012
Location: South Milwaukee, WI
Junior Member
Good morning everyone,

We have a database that did backups with the dump files (.dmp) but when it goes to read the dumps, its saying that it can't read the header and needs to be recovered.

We don't have an Oracle support contract so we are trying to find out a way to recover these dump files or some way we can gain access to these files and have them in working order again.

Please feel free to email me or shoot me a private message. Any help would be greatly appreciated!

Thanks!
Re: New to Oracle - NEED HELP IMMEDIATELY [message #572318 is a reply to message #572317] Mon, 10 December 2012 10:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

First, please note that requesting help IMMEDIATELY tends to be counter-productive on a public forum: the various volunteers may view it as being a bit aggressive. After all, it is your problem, not ours.

Second, you need to give more information. At the moment we have no idea of what you are trying to do, or what the error is. Use copy/paste to to show exactly what happens when you do whatever it is that you are doing, and enclose this in code tags, as an example:
c:\users\john\home>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 10 16:12:29 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
Re: New to Oracle - NEED HELP IMMEDIATELY [message #572320 is a reply to message #572318] Mon, 10 December 2012 10:35 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
Perhaps the files are datapump dump files or exp-dump files instead of rman-backups.
Would also help how the backups were taken (commands?)
Re: New to Oracle - NEED HELP IMMEDIATELY [message #572412 is a reply to message #572320] Tue, 11 December 2012 14:06 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you do with DMP files? Did you, perhaps, FTP them "there" and "back" again? If so, did you do it in BINARY mode? If not, you should have.
Previous Topic: No RMAN records in control file
Next Topic: User restoration
Goto Forum:
  


Current Time: Thu Mar 28 07:56:40 CDT 2024