Home » RDBMS Server » Backup & Recovery » Data recovery using a dump File
Data recovery using a dump File [message #193222] Fri, 15 September 2006 06:12 Go to next message
BOMAYED
Messages: 16
Registered: September 2006
Junior Member
I have successfully created a new database using a dump file Smile

And .. I still have the old database which is giving me so many errors blaming be for deleting a redo log file by mistake! Things happen, I'm unable to recover the redo log files

I also don't have a backup of the redo log file . . so anyways!


I now have a new database , however the dump file was created like a month ago , so some data are missing . . Now . . the question is :

Is it possible . . somehow . . to access some tables and suck the last month data out of it from the old database even though I can't startup the database ?


Smile don't make fun of me , is it possible or is it not ?

[Updated on: Fri, 15 September 2006 06:20]

Report message to a moderator

Re: Data recovery using a dump File [message #193357 is a reply to message #193222] Fri, 15 September 2006 17:01 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
It is on the docs

http://download-east.oracle.com/docs/cd/A81042_01/DOC/server.816/a76993/recoscen.htm#11724

Br
Kim Anthonisen
Re: Data recovery using a dump File [message #193417 is a reply to message #193222] Sat, 16 September 2006 09:27 Go to previous messageGo to next message
BOMAYED
Messages: 16
Registered: September 2006
Junior Member
Before I read your reply , I have tried the following:

RA-00279: change 53577 generated at '2006-09-10:15:00:00 needed for thread 1
ORA-00289: suggestion : /oracle/arc_dest/arcr_1_802.arc
ORA-00280: change 53577 for thread 1 is in sequence #802
Specify log: [<RET> for suggested | AUTO | FROM logsource | CANCEL ]

I pressed ENTER and I always get an error saying


system01.dbf needs recovery

-------------------------

I'm wondering if I have two identical databases , one which is currupted due to some missing log files or so . . and one is working perfectly , can't I restore the missing files from the running database?

in other words , can I copy the system01.dbf from the windows machine and place it in to the currupted database on the solaris machine , will this help ?


I just need to reach a single table in the currupted database and get all the data out of it , that's all


[Updated on: Sat, 16 September 2006 09:28]

Report message to a moderator

Re: Data recovery using a dump File [message #193418 is a reply to message #193417] Sat, 16 September 2006 09:28 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

I am sorry, but absolutely no.

Are You running with archiving on?
Re: Data recovery using a dump File [message #193419 is a reply to message #193418] Sat, 16 September 2006 09:35 Go to previous messageGo to next message
BOMAYED
Messages: 16
Registered: September 2006
Junior Member
I have NOARCHIVELOG Sad
Re: Data recovery using a dump File [message #193422 is a reply to message #193419] Sat, 16 September 2006 10:22 Go to previous messageGo to next message
BOMAYED
Messages: 16
Registered: September 2006
Junior Member
I see , ok but what is system01.dbf for ? is it the main database file where all the data are stored?


[Updated on: Sat, 16 September 2006 10:23]

Report message to a moderator

Re: Data recovery using a dump File [message #193431 is a reply to message #193422] Sat, 16 September 2006 14:43 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
If You do not know about the SYSTEM tablespace and it's datafiles, I strongly suggest that You call Oracle Support.
- And NO, You cannot use a datafile from another database. The SYSTEM tablespace with it's datafile(s) contains bookkeeping information about the specific database. Plugging another file in will only make Your database totally unusable.

Does anything in the link I gave You mean something to You?

What does this query give?

SELECT group#, sequence#, status, archived FROM v$log


Br
Kim
Previous Topic: Getting error backup controlfile to trace in RMAN script
Next Topic: Disaster Recovery
Goto Forum:
  


Current Time: Sun Dec 04 08:21:46 CST 2016

Total time taken to generate the page: 0.08489 seconds