| Data recovery using a dump File [message #193222] |
Fri, 15 September 2006 06:12  |
BOMAYED
Messages: 16
Registered: September 2006
|
Junior Member |
|
|
I have successfully created a new database using a dump file 
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 ?
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 #193417 is a reply to message #193222] |
Sat, 16 September 2006 09:27  |
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 #193431 is a reply to message #193422] |
Sat, 16 September 2006 14:43 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
